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( <>);
Then log ou
it will not prompt for a password with the '-p'
try this:
mysql --host 5.6.7.8 -uroot db_name -p
I assume you do have a password set?
On Mon, May 25, 2015 at 11:24 AM, Ajay Garg wrote:
> 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.
>
Sorry,
The user had multiple passwords set up in mysql.user table.
Clearing the "other" passwords solved the issue.
Sorry for the inconvenience.
Thanks and Regards,
Ajay
On Mon, May 25, 2015 at 8:54 PM, Ajay Garg wrote:
> Hi All.
>
> I have two servers, 1.2.3.4 and 5.6.7.8
> I wish to login
