Hi,
I need to create a sql select statement which join 2 databases, where both the database have to connect with different port numbers,
db1 port: 3306
db2 port: 3311
select something from db1.table1 A left join db2.table2 B on A.id = B.id
when i execute it, the error msg come out:
SELECT command denied to user 'username'@'localhost' for table 'table1'
I need to solve it urgently, all helps will be appreciated
Thanks in advanced.
Yii Ing