Mysql installation-free version _ MySQL

Mysql installation-free applications, first net stop mysql service, and switch to the task manager, there are mysql-related, it is best to close the process.

2. run the CMD command to switch to the MySql installation bin directory.

Cd/d D:/Program Files/MySQL Server 5.6/bin

Then execute mysqld -- skip-grant-tables (note that there is no semicolon ;)

The following message is displayed. do not close this command line window and open a new command line window.

3. run CMD and run mysql-u root-p to prompt you to enter the password and press enter.

Enter database

4. execute the command: update mysql. user set password = PASSWORD ('root') where User = 'root ';

In this way, the root user password is set to root.

5. refresh execution: flush privilege;

6. execute: exit

7. disable the net stop mysql service and restart the net start mysql service.

8. run mysql-u root-p

Enter password :*******

Input: root login