How to access external database table in MySQL

Question

I have two MySQL databases in 2 different hosts.

I would like to from MySQL A table 1 to connect and retrieve data from MySQL B table 2.

I do not know which one should set up privilege in order to connecting both each other.

I keep receiving:

SELECT command denied to user 'MySQL A'@'localhost' for table 'MySQL B table 2'

what do you want to do in table 1 with the data from table 2? — Tobas, Jul 04 '12 at 08:27

score 0 · Answer 1 · answered Jul 04 '12 at 08:29

0

You will need to set up federated tables.

The alternative is 2 connections, 2 queries and combine the results.

answered Jul 04 '12 at 08:29

Brian

1 Answers1