Graphics and text tutorials for modifying Mysql5.7.11 initial password under Windows _mysql

Last week installed MYSL but not landing, find a long time to find this solution, said the detailed thank you.

[Summary: 1.my-default.ini renamed My.ini is extracting the contents of the catalog above My-default.ini a more name for My.ini. 2. Open Windows situation variable settings, new variable name mysql_home, variable value MyS]

1.my-default.ini renamed My.ini

Copy My-default.ini under the unpacked directory and change the name to My.ini.

2. Open Windows environment variable setting, new variable name mysql_home, variable value for MYSQL installation directory path, add in Path variable of environment variable;%mysql_home%\bin;

3. Several orders

Install MySQL service: mysqld--install

Start: net start MySQL

Stop: net stop MySQL

Uninstall: SC Delete mysql,mysqld-remove

The command line window must be open in admin mode and come to%mysql_home%\bin;

A. Installation Services: Mysqld--install.

B. Start service net start MySQL

(a problem may be encountered and the MySQL service is starting.) The mSQL service failed to start. The service did not report any errors. Please type NET helpmsg 3534 for more help.

Delete the Data folder and initialize the data directory with Mysqld--initialize. When the data is not deleted, the task manager is turned on to kill the mysqld process, and other startup or shutdown services failed to do the same thing. ）

When you successfully enter the service, use

Mysql-u root-p Carriage return

Enter password

Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

Turn off service net stop MySQL

Open in Safe mode, mysqld--skip-grant-tables

At this point, the cursor will always flash. Note, do not move, open another command line window.

4. The same operation as before came to the bin directory,

Login Mysql-u Root-p

The password is null, direct return;

We can go in.

And then

Use MySQL;

(Perhaps the previous version of the password is password,5.7.11 is authentication_string, you can select * from user, view)

(old version) update user set Password=password ("123456") where user= "root";

(5.7.11) Update user set Authentication_string=password ("123456") where user= "root";
In the end, flush privileges is OK.

5. Finally login to try.

Just start to fail, is the English mysqld process is still open, kill off on the line.

Finally, the root password was successfully modified.

The above is a small set of Windows to introduce the revised Mysql5.7.11 initial password of the graphics and text tutorial, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!