I am trying to write a query on one MySQL server to access data on another MySQL server. Any idea how to do it?
I tried with a query as below
Select * from hostnameB.DBname.table
Where this query was tried to execute on MySQL server with hostname A and table to access was on hostname B. It didn't work.
Is there any other way to do this?