Set the password for the default mysql root User From: yangtai. blog.51cto. com334569213861 Case 1: If you forget the MySQL root Password, You can reset it using the following method: Case 2: phpmyadmin is added. Log On with the mysql user password, however, phpmyadmin cannot use a blank password to log on, that is, it is the root of mysql.
Set the password for the default mysql root User From: http://yangtai.blog.51cto.com/334569/213861/ Case 1: If you forget the MySQL root Password, You can reset it with the following method: Case 2: added phpmyadmin, when logging on, use the mysql user password to log on, but phpmyadmin cannot use a blank password to log on, that is, the mysql root
Set the password for the default mysql root User
From: http://yangtai.blog.51cto.com/334569/213861/
Case 1: If you forget the MySQL root Password, You can reset it using the following methods:
Scenario 2: phpmyadmin is added, and the mysql user password is used for Logon. However, phpmyadmin cannot use an empty password to log on, that is, adding a password to the mysql root User, you can directly jump to step 1.
Steps:
1. KILL the MySQL process in the system;
2. Run the following command to start MySQL without checking its permissions;
Mysqld_safe-skip-grant-tables &
3. Use the empty password to log on to MySQL as the root user;
Mysql-u root
4. Modify the password of the root user;
Mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root ';
Mysql> flush privileges;
Mysql> quit
5. Restart MySQL to log on with the new password.