Mysql denied for user ' odbc@localhost ' | | Denied for user ' root@localhost '

1. Question Description:

1.1 MySQL Version:mysql-5.7.11-win64.zip

1.2 If connect to the MySQL service the first time, come across some problems

1.2.1 Mysql-u root-p (enter), no password (enter), you'll see

1.2.2 If you want to update the user's password like "Update user set password= ...", you'll see

2. Solution:

2.1 net stop MySQL (stop the MySQL service)

2.2 Mysqld-nt--skip-grant-tables (you'll see Cusor is waiting, it's OK,)

Open another CMD window

2.3 MySQL

2.4

Mysql>use MySQL

Mysql>update User Set Password=password ("123456") where user= "root";

Mysql>flush privileges;

Mysql>exit

2.5 net start MySQL

2.6 Mysql-u Root-p

2.7 Set Password=password ("123456");

3. Thinking

I had meet the problem before, but forget what to set it,

That's mean Writing is better than minding.

Mysql denied for user '[email protected]' | | Denied for user '[email protected]'