首先让我提一下，我已经看了很多建议的问题，但没有找到相关的答案。这就是我正在做的。
我连接到Amazon EC2实例。我可以用这个命令登录MySQL根目录:
mysql -u root -p
然后我用host %创建了一个新的用户帐单
CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';
授予用户bill的所有权限:
grant all privileges on *.* to 'bill'@'%' with grant option;
然后我退出root用户，尝试用bill登录:
mysql -u bill -p
输入正确的密码并得到以下错误:
错误1045(28000):用户“账单”@“localhost”(使用密码:YES)的访问被拒绝
当前回答
I discovered yet another case that appears on the surface to be an edge case; I can export to the file system, via SELECT INTO .. OUTFILE as root, but not as regular user. While this may be a matter of permissions, I've looked at that, and see nothing especially obvious. All I can say is that executing the query as a regular user who has all permissions on the data base in question returns the access denied error that led me to this topic. When I found the transcript of a successful use of SELECT INTO … OUTFILE in an old project, I noticed that I was logged in as root. Sure enough, when I logged in as root, the query ran as expected.
其他回答
省得你自己头疼……您的问题可能是口令周围没有引号。至少我的案子绕了我三个小时。
[client]
user = myusername
password = "mypassword" # <----------------------- VERY IMPORTANT (quotes)
host = localhost
http://dev.mysql.com/doc/refman/5.7/en/option-files.html
搜索“这是一个典型的用户选项文件:”，看看他们在那里陈述的例子。祝你好运，我希望能为别人节省一些时间。
好吧，我不确定，但可能是mysql安装目录中的my.cnf文件是罪魁祸首。 注释掉这一行，问题就可以解决了。
bind-address = 127.0.0.1
这是以下两者之间的区别:
CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';
and
CREATE USER 'bill'@'localhost' IDENTIFIED BY 'passpass';
检查:
mysql> select user,host from mysql.user;
+---------------+----------------------------+
| user | host |
+---------------+----------------------------+
| bill | % | <=== created by first
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
| bill | localhost | <=== created by second
+---------------+----------------------------+
命令
mysql -u bill -p
隐式访问'bill'@'localhost'，而不是'bill'@'%'。
“bill”@“localhost”没有权限
你会得到错误:
ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)
解决问题:
CREATE USER 'bill'@'localhost' IDENTIFIED BY 'passpass';
grant all privileges on . to 'bill'@'localhost' with grant option;
我通过删除旧的错误用户“账单”条目来解决这个问题(这是重要的部分:都来自mysql。用户和mysql.db)，然后创建和前面一样的用户:
FLUSH PRIVILEGES;
CREATE USER bill@localhost IDENTIFIED BY 'passpass';
grant all privileges on *.* to bill@localhost with grant option;
FLUSH PRIVILEGES;
工作完毕，用户正在连接。现在我将删除一些特权从它:)
这太迟了
我尝试了所有这些其他答案，并运行了许多不同版本的mysql -u root -p，但从来没有运行过
Mysql -u root -p
然后按[ENTER]输入密码。
一旦我这么做了，就成功了。希望这能帮助到一些人。
