Look like you have to login in with mysql_secret, set the pw, then perform your update.
If this is the case, find the mysql_secret file, open/cat it, and copy the pw from the file. Then log in with that pw in the cmd line. To update the root pw, use: SET PASSWORD = PASSWORD( <<new pw>>); Then log out, and log back in with the root pw. Good luck. -----Original Message----- From: Ajay Garg [mailto:ajaygargn...@gmail.com] Sent: May-25-15 11:24 AM To: Mailing-List mysql Subject: 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
