Root password reset for MySQL

Root password reset for MySQL

To set the MySQL root password:

#mysqladmin-uroot Password ' Qiangge ' (the underlined part is the root password)

# Mysql-uroot-pqiangge

If you forget the MySQL root password, the workaround is as follows:

(1) Edit MySQL master configuration file my.cnf

#vim/etc/my.cnf

Add a parameter under the [Mysqld] field

Skip-grant

(2) Restart the database service

#service mysqld Restart

(3) So you can access the database without authorization.

#/usr/local/mysql/bin/mysql-uroot

(4) Modify the corresponding user password

> Use MySQL;

> Update user set Password=password (' Your password '(new password)) where user= ' root ';

>flush privileges;

>quit;

(5) Modify/ETC/MY.CNF remove Skip-grant, restart Mysqld service

This article from "12350027" blog, declined reprint!

Root password reset for MySQL