One of the simplest ways to restore the root password of the forgotten MySQL5.0 database:
Set password for 'root' @ 'localhost' = PASSWORD ('123 ');
Put the above file! Statement is SQL .txt
Stored in any folder
I am storing it in E:/sevser /.
Run E:/sevser/mysql/bin/mysqld-nt -- init-file = E:/sevser/SQL .txt in "run ".
Then restart the server. Then, the ROOT password is automatically changed to 123456.
Here E:/sevser/mysql/replace the MYSQL installation directory on your server
If you change the ROOT name, you need to change the 'root' name for you !!
There is also a method:
Windows:
1. log on to the system as a system administrator.
2. stop MySQL services.
3. go to the command window and enter the MySQL installation directory. for example, if my installation directory is c:/mysql, go to C:/mysql/bin.
4. skip the permission check and start MySQL,
C:/mysql/bin> mysqld-nt -- skip-grant-tables
5. open a new window, enter the c:/mysql/bin directory, and set the new root password.
C:/mysql/bin> mysqladmin-u root flush-privileges password "198651"
C:/mysql/bin> mysqladmin-u root-p shutdown
Replace newpassword with the root password you want to use. the second command will prompt you to enter a new password, repeat
Password.
6. stop MySQL Server and start Mysql in normal mode
7. You can use a new password to link to Mysql.
Command:
Net mysql start MYSQL
Net stop mysql stop MYSQL
The following uses Windows as an example. in linux, replace mysqld-nt in step 2 with safe_mysqld.
1. stop the mysql5 service:
Net stop mysql5
2. open a DOS window for execution:
C:/mysql/bin> mysqld-nt -- skip-grant-tables &
3. open another DOS window for execution:
C:/mysql/bin> mysql
> Update user set password = password ('000000') where user = 'root ';
Set the root password to 123456!
4. start the mysql5 service:
Net start mysql5