Hi All. I have two servers, 1.2.3.4 and 5.6.7.8 I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8.
a) On 5.6.7.8, mysql> show grants for 'root'@'%'; +-------------------------------------------------------------+ | Grants for root@% | +-------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION | +-------------------------------------------------------------+ 1 row in set (0.00 sec) b) >From 1.2.3.4, I do mysql --host=5.6.7.8 -uroot db_name ERROR 1045 (28000): Access denied for user 'root'@'1.2.3.4' (using password: NO) I am at complete loss, I have done all that I could find from google. I will be really, really grateful for ideas that could help me recover from this mess, that is aching me since last 3 hours :( Thanks and Regards, Ajay -- Regards, Ajay
