mysql 向不工作的用户授予 sql 脚本

Question

标题说明了一切，这是我的代码

GRANT SELECT, INSERT, UPDATE, DELETE ON 'database_name' TO 'mysqluser'@'111.111.111.111';

它说

ERROR 1064 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax near ''database_name' TO 'mysqluser'@'111.111.111.111'' at line 1

Answer 1

这个:

GRANT SELECT, INSERT, UPDATE, DELETE ON 'database_name' TO 'mysqluser'@'111.111.111.111';

应该是:

GRANT ALL ON 'database_name'.* TO 'mysqluser'@'111.111.111.111';

在您的特定情况下(在我的 mysql 服务器上测试):

GRANT SELECT, INSERT, UPDATE, DELETE ON database_name.* TO 'mysqluser'@'111.111.111.111';