KeyHelp Community

Hello,

Is it possible to change the mysqladmin password? I tried:

UPDATE mysql.user SET authentication_string = PASSWORD('newpass')
WHERE User = 'mysqladmin' AND Host = 'localhost';
FLUSH PRIVILEGES;

The affected rows was 1, but the login fails.

Thank you.

Hello,

this is not the SQL how one would update the password.

Use this instead:

UPDATE `mysql`.`user` SET `Password` = PASSWORD('newpass') WHERE `User` = 'mysqladmin';
FLUSH PRIVILEGES;

Perfect, thanks Alexander. Not sure where I got that other code from.

Merry Christmas.

Change mysqladmin password?