数据库grant报错1064 (42000): You have an error in your SQL syntax； check the manual that corresponds t

不同版本sql语法不同导致
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
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 ‘identified by ‘123456’’ at line 1

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)