对用户拒绝CREATE命令?

show grants for charm@'localhost';

---------------------+

| Grants for charm@localhost |

+-----------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'charm'@'localhost' IDENTIFIED BY PASSWORD '*EDD1CD76B1331E363B2BAED3F0B7EAF28559FBEWD' |

| GRANT ALL PRIVILEGES ON `charmstyle_com`.`charmstyle_com` TO 'charm'@'localhost'

我用了

grant all on charmstyle_com to charm@'localhost' IDENTIFIED BY 't1q4gytrur';

flush privileges;

然后我导入数据库,它显示一个错误:

   ERROR 1142 (42000) at line 29: CREATE command denied to user 'charm'@'localhost' for table 'adminnotification_inbox'

回答:

您仅向“ charmstyle_com”数据库内的“ charmstyle_com”表授予用户权限。您可能想要的是授予“

charmstyle_com”(或至少“ adminnotification_inbox”表)中所有表的权限

 GRANT ALL PRIVILEGES ON `charmstyle_com`.* TO 'charm'@'localhost'

或者

 GRANT ALL PRIVILEGES ON `charmstyle_com`.`adminnotification_inbox` 

TO 'charm'@'localhost'

以上是 对用户拒绝CREATE命令? 的全部内容, 来源链接: utcz.com/qa/399861.html

回到顶部