Forgot root password

If you forget the root password or other user password, don't worry, press Here's what you can do. 1. Edit the MySQL master profile my.cnf vim/etc/my.cnf   Add the parameter   skip-grant   under the [mysqld] field; 2. Restart the database Service Service mysqld Restart 3. This allows access to the database without authorization Mysql-uroot 4. Modify the corresponding user password use MySQL; Update user set Password=password (' Your password ') where user= ' root ';                                                             password                                     user Other formats.  flush privileges; 5.   Modify/ETC/MY.CNF remove skip-grant, restart MySQL service From http://www.aminglinux.com/bbs/thread-252-1-1.html

Forgot root password