执行:
GRANT SELECT, INSERT,UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,CREATE TEMPORARY TABLES, DROP, REFERENCES . bugs.*TO bugs@localhost IDENTIFIED BY ’123’;提示:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. bugs.*TO bugs@localhost IDENTIFIED BY 123' at line 1不知道有没有人知道怎么解决? 谢谢.
GRANT SELECT, INSERT,UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,CREATE TEMPORARY TABLES, DROP, REFERENCES . bugs.*TO bugs@localhost IDENTIFIED BY ’123’;提示:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. bugs.*TO bugs@localhost IDENTIFIED BY 123' at line 1不知道有没有人知道怎么解决? 谢谢.
GRANT SELECT, INSERT,UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,CREATE TEMPORARY TABLES, DROP, REFERENCES on bugs.* TO bugs@localhost IDENTIFIED BY ’123’;
你可以参考一下手册中的语法说明。MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html