用户 debian-sys-maint 的访问被拒绝 [英] access denied for user debian-sys-maint

问题描述

我遇到了 mysql 的问题.我试图执行这个:

I have had problem with mysql. I tried to execute this:

echo "show databases" | mysql -B -N

但我得到了:

ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

但是当我执行时:

/etc/init.d/mysql restart 

我得到了一个好的".

我做到了

GRANT ALL PRIVILEGES on *.* TO debian-sys-maint@localhost IDENTIFIED BY PASSWORD 'your password' WITH GRANT OPTION; FLUSH PRIVILEGES;

密码来自 /etc/mysql/debian.cnf.但这没有帮助.(当然我刷新了 priv 并重新启动了 mysql).

where password is from /etc/mysql/debian.cnf. But it didn't help. (of course I flushed priv and restarted mysql).

推荐答案

问题是，你的 GRANT 语句使用了 IDENTIFIED BY PASSWORD 子句，在这种情况下mysql期望获取散列密码，而不是明文密码.

The problem is, your GRANT statement uses IDENTIFIED BY PASSWORD clause, and in this case mysql expect to get a hashed password, not a plaintext one.

如果您希望提供明文密码，请改用 IDENTIFIED BY 'your password'.

Use IDENTIFIED BY 'your password' instead, if you wish to supply a plaintext password.

这篇关于用户 debian-sys-maint 的访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！