1. edit /etc/mysql/my.cnf
add "skip-grant-tables" in mysqld settings section
2. restart mysqld
/etc/init.d/mysql restart
3. connect mysql database
mysql -u root -p mysql
4. update root password
>update user set password=PASSWORD("12345") where user='root';
quit
5. delete the configuration added in step 1
6. restart mysqld again
/etc/init.d/mysql restart
DONE!
Posts
2 comments:
Great post.
One correct though, the update statement should specify mysql.user as the table name:
update mysql.user set password=PASSWORD("12345") where user='root';
I don’t suppose many of websites give this kind of information. password vault
Post a Comment