windows系统下mysql工具连接为什么会出现Error 1045(28000) Access Denied for user 'root'@'localhost'

Question

windowns 安装mysql-5.5.22-win32后，

Navicat工具连接数据库提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)?

直接使用命令行连接数据库正常，确认密码数据正确，解决方式为重置root密码。

请问哪些原因会导致该问题出现呢？

Ps：由于该故障，mysql重新安装过。

Answer 1

The access address must be unified. 127.0.0.1 is different from localhost or ip. There are also special characters in passwords. Different clients have different support for special characters

Answer 2

I searched and found this thread, http://bbs.chinaunix.net/thread-658853-1-1.html
Is the subject accessing the database locally? Or access the database from other networks (LAN, different network segments, public network).
It is also possible that the root password did not take effect in time after being set. In this case, the subject can try to log in using the default password of root.

Answer 3

If you have installed an integrated environment, it is possible that there are two mysql databases locally. The databases you connect to are different according to the access address, so even if it is the root user name or password, an error may be reported