Reset the system. A lot of MySQL password articles are very good spare.

Method 1: Use the Set password command

Mysql-u Root

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

Method 2: Use Mysqladmin

mysqladmin-u root Password "Newpass"

If Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

Method 3: Edit the user table directly with update

Mysql-u Root

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';

mysql> FLUSH privileges;

This can be done when the root password is lost

Mysqld_safe--skip-grant-tables&

Mysql-u Root MySQL

mysql> UPDATE user SET Password=password ("New password") WHERE user= ' root ';

mysql> FLUSH privileges;

Http://jingyan.baidu.com/article/0320e2c198ad5f1b87507bc8.html

This is barely able to be seen, just installed in the case of MySQL, with mysql-u Root landing, and then with set PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' 123456 ');

Digression, now this win10 although very unstable, this is the Start menu is completely open, but I use the system comes with the reset function, rapid one-click Reload System, keep desktop files and system user name password, even the development environment is not re-installed, but the JDK still have to have, The program folder is not preserved, if it was installed in other partitions, it is really neat, no one to tell you? The JDK is green. In this way only the database, a bit small error, no backup database Ah, only from the server to engage.

Reset the system. A lot of MySQL password articles are very good spare.