0 Replies Latest reply: Jan 20, 2012 2:00 PM by StephenM
StephenM Level 1 (110 points)

I have install 5.5.20 from mysql from the TAR file. that install was done from an admin user by the name of mysql. Using the mysql user, I have reached a point where I am unable to reset the root password. I have tried both method of resetting the password with no success. Here is what I did. (path omitted for brevity, but used in the commands)


shell>mysqld_safe --skip-grant-tables


mysql>UPDATE mysql.user SET Password=PASSWORD('newPass')

    -> WHERE User='root';

mysqlQuery OK, 0 rows affected (0.05 sec)

Rows matched: 0  Changed: 0  Warnings: 0


shell> mysqld_safe

shell> mysql -u root -p

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)




created an init file that had ths

--------contents of minit-------

UPDATE mysql.user SET Password=PASSWORD("newPass") WHERE User='root';




mysqld_safe --init-file=minit

killed mysqld


mysql -u root -p

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)



By the way, I closely monitored the .err file and nothing unusual or pacular showed up there.


Anyone see what I did wrong? Anyone have other suggestions?