MySQL password is incorrect

ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)

ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:yes)

One, modify the My.ini. Restart the MySQL service (remember to restart.).

Add a line below mysqld Skip-grant-tables

　　

or cmd skip-grant-table in the Mysql\bin directory

Two. Blank password login, select database

Mysql-u root-p; #空密码登录

show databases; #查看数据库

Use db_name; #选择数据库

Three. Change your password

Update user SetPassword Set password ("*********") where user= "root"; #更改密码

Flush privileges; #刷新数据库

Exit

Four. Restore My.ini

MySQL password is incorrect