"GRANT GREATE DELETE ON . TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION " 这条有错误GRANT CREATE DELETE ON . TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION
请问是那里错了,我找不到啊,这句是照着源书打得,打了好几遍,还是有错误,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 to use near 'DELET E ON . TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION' at line 1
GRANT CREATE,DELETE ON *.* TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION
最后加分号结束; GRANT ALL PRIVILEGES ON database.* TO user@'host' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
这条有错误GRANT CREATE DELETE ON . TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION
corresponds to your MySQL server version for the right syntax to use near 'DELET
E ON . TO gamer IDENTIFIED BY "69778198" WITH GRANT OPTION' at line 1
GRANT ALL PRIVILEGES ON database.* TO user@'host' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;