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

windows中mysql报错

Error:

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

Solution

mysql安装目录下配置文件 my.ini
mysql报错 ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
在mysld下添加

skip-grant-tables 

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