Is it possible to change the mysqladmin password? I tried:
Code: Select all
UPDATE mysql.user SET authentication_string = PASSWORD('newpass')
WHERE User = 'mysqladmin' AND Host = 'localhost';
FLUSH PRIVILEGES;
Thank you.
Code: Select all
UPDATE mysql.user SET authentication_string = PASSWORD('newpass')
WHERE User = 'mysqladmin' AND Host = 'localhost';
FLUSH PRIVILEGES;
Code: Select all
UPDATE `mysql`.`user` SET `Password` = PASSWORD('newpass') WHERE `User` = 'mysqladmin';
FLUSH PRIVILEGES;