Errors encountered while installing MySQL decompression version

　　

Usually use EXE to install MySQL, today using decompression package, encountered a series of problems:

Environment: WIN10

MySQL version: mysql-5.7.21-winx64

Start a tutorial that always uses this page

Https://www.cnblogs.com/Michael1/p/5806384.html

Also experiencing this problem

According to the blogger's method, when using the mysqld--initialize times error, delete the Data folder under the Mysql-5.7.21-winx64 folder in order to run

Login error after running MySQL

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

The method in http://blog.csdn.net/mingtianhaiyouwo/article/details/49994275 cannot be resolved (mysqld--user=mysql--skip-grant-tables --skip-networking& still unable to log in after changing the command)

Later, in the My.ini configuration file, add the Skip-grant-tables command

Then restart the MySQL service

net stop MySQL

net start MSYQL

and use the mysql-u root mysql command to enter MySQL

Then use the command update mysql.user set Password=password (' root ') where user= ' root '

Change password, error unknown column ' Password ' in ' Field list '

The original MySQL database has no password This field, password field changed to Authentication_string

So change the statement to replace the update mysql.user set Authentication_string=password (' root ') where user= ' root ';

Then delete the Skip-grant-tables command in My.ini

Restart MySQL Service

The command line can be logged in normally, but when using Mysqlfront login, prompt password expires

Under command line, modify the password set password = password (' 123456 ');

Use client access again, no problem.

Always run cmd in admin mode

Reference: http://blog.csdn.net/lidachao01/article/details/72385498

Errors encountered while installing MySQL decompression version