Web lists-archives.com

RE: Very strange issue while trying to login remotely




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:ajaygargnsit@xxxxxxxxx] 
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