Mysql5.6 how to forget the root password _ MySQL

Mysql5.6 what should I do if I forget the root password? how can I reset the root password? The following describes how to solve Mysql5.6's password failure. For more information, see View the currently installed mysql version:

Root @ oraserver139 ~] # Rpm-qa | grep MySQL
MySQL-server-5.6.15-1.el6.x86_64
MySQL-client-5.6.15-1.el6.x86_64
MySQL-shared-compat-5.6.15-1.el6.x86_64
MySQL-devel-5.6.15-1.el6.x86_64
Perl-DBD-MySQL-4.022-1.el6.rfx.x86_64

1. 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. The following is my mysql installation directory.

cd D:/Program Files/MySQL/MySQL Server 5.6/bin

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

The following prompt message appears,

Do not close this command line window and open a new command line window again. Note: At this time, a warning may appear, so ignore it.

3. open a new cmd window again. Run the following command in the bin directory: mysql-u root-p. enter the password and press enter,

For example

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 and execute: mysql> flush privileges ;.

Now you can log on again. The password is successfully modified.

The solution to Mysql5.6 forgetting the root password is introduced here, and thanks for your support for the website.