windows系统下mysql工具连接为什么会出现Error 1045(28000) Access Denied for user 'root'@'localhost'
伊谢尔伦
伊谢尔伦 2017-04-17 11:32:47
0
3
651

windowns 安装mysql-5.5.22-win32后,

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

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

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

Ps:由于该故障,mysql重新安装过。

伊谢尔伦
伊谢尔伦

小伙看你根骨奇佳,潜力无限,来学PHP伐。

reply all(3)
Ty80

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

黄舟

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.

PHPzhong

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

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template