我跟着78246
当我做
mysql> GRANT ALL PRIVILEGES ON *.* for 'root'@'%' IDENTIFIED BY 'password'; 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 'for 'root'@'%' IDENTIFIED BY 'password'' at line 1 我如何使它工作？
应该是，而不是。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';