The first thing to check is whether the linked server user haas the correct permissions on the remote server.

you can use the following to find which user is being used to login to the remote server.

SELECT [srv].[name],

[srv].[data_source],

[ll].[remote_name]

FROM sys.servers AS [srv]

INNER JOIN sys.linked_logins AS [ll]

ON [srv].[server_id] = [ll].[server_id]

WHERE [srv].[name] = 'TMS6';

then once use have your remote user name, you can run Show Grants for that user on the MYSQL server.

SHOW GRANTS FOR 'user'@'server';