MySQL Error 1045, user cannot connect

1.root users can log in

Sqlin User is a newly created statement that cannot connect to MySQL

The root user logs in, re-modifies the user's password, executes the statement

use mysql； update user set password=password("sqlin") where user="sqlin(用户名)";

This statement indicates that the password for the user named Sqlin user is changed and the password () encryption operation is performed, and must not be directly
' password= ' Sqlin "'

2.root User Login not

Open the My.ini under MySQL, find [mysqld], add a line below:

Skip-grant-tables

Restart MySQL, log in root, follow the above method to modify the root password, and then delete the My.ini added statements, restart MySQL, you can normally log on.

MySQL Error 1045, user cannot connect