root and then use either SET PASSWORD or UPDATE.
PASSWORD() function.
SET PASSWORD, do this:
mysql -u rootSET PASSWORD FOR ''@'localhost' = PASSWORD('newpw');SET PASSWORD FOR ''@'hostname' = PASSWORD('newpw');
SET PASSWORD
SELECT Host, User FROM mysql.user;
UPDATE to modify the user table directly.
mysql -u rootUPDATE mysql.user SET Password = PASSWORD('newpw') WHERE User = '';FLUSH PRIVILEGES;
How do I achieve anonymous account removal?
© 2007 John Michael Pierobon