mysql - 更新mysql中授予权限中的host字段

Question

我有一个现有的表，我想使用 Grant 命令更新权限中的主机部分

mysql> show grants
    -> ;
+------------------------------------------------------------------------------------------------------------+
| Grants for ssc@localhost                                                                                   |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ssc'@'localhost' IDENTIFIED BY PASSWORD '*ABCDEFABCDEF' |
| GRANT ALL PRIVILEGES ON `ssc`.* TO 'ssc'@'localhost' WITH GRANT OPTION                                     |
+------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

Answer 1

为了能够从任何地方以 ssc 身份进行连接，您必须创建一个额外的用户并授予他必要的权限

CREATE USER 'ssc'@'%' IDENTIFIED BY '<your password>';
GRANT ALL PRIVILEGES ON `ssc`.* TO 'ssc'@'%' WITH GRANT OPTION;

在 Adding User Accounts 中了解更多相关信息