mysql - RELOAD 权限以刷新主机

Question

我已连接到远程 mysql 服务器，但在几次连接不良(由于自动化)后，我被服务器阻止。我正在尝试解锁自己。

提示建议我执行mysqladinlush-hosts

# This was done locally
$ mysql -h remote_host -u user_name
ERROR 1129 (HY000): Host 'remote_host' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
$ mysqladmin flush-hosts
mysqladmin: refresh failed; error: 'Access denied; you need (at least one of) the RELOAD privilege(s) for this operation'

我收到此消息:

mysqladmin: refresh failed; error: 'Access denied; you need (at least one of) the RELOAD privilege(s) for this operation'

因为我对 mysql 和 mysql-workbench 还很陌生，所以我不确定如何解决这个问题。

我还尝试通过 SSH 连接到 remote_host 并输入命令 mysqladminlush-hosts 但出现错误:

error: 'Access denied for user 'user1'@'localhost' (using password: NO)'

Answer 1

Google 中关于“mysql RELOAD 权限”的第二个链接 - FLUSH syntax :

To execute FLUSH, you must have the RELOAD privilege.

突出显示的链接显示:

The RELOAD privilege enables use of the FLUSH statement. It also enables mysqladmin commands that are equivalent to FLUSH operations: <...>

并且，在该页面上，依次有一个 --user option .