Web lists-archives.com

Very strange issue while trying to login remotely




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