Tuesday, July 5

reset mysql root password

1) kill mysqld without -9 option

2) start mysqld with --skip-grant-tables option

3) mysql --user=root --port=3306 --host=server1

4)
use mysql;
update user set password=PASSWORD("letmein") where User='root';
flush privileges;
quit
OR
mysqladmin -u root flush-privileges password "letmein"


5) start mysqld with your regular option

0 comments:

Post a Comment