依次执行一下这几条命令：

mysql>use mysql;

mysql>select host ,user from user;

mysql> update user set host =’%’ where user=‘root’;

C:\WINDOWS\system32>mysql>use mysql

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\WINDOWS\system32>mysql>select host ,user from user

C:\WINDOWS\system32>mysql> update user set host =’%’ where user=‘root’

C:\WINDOWS\system32>mysql> flushprivileges

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

1、在cmd命令里面用  mysql -u root -p 密码    连接上mysql

2、输入ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';