mysql8 授权远程登录_MySQL8 远程授权访问

在测试环境，想实现MySQL 8 数据库的远程访问授权。

传统的方法已经不行，报1064错误

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' 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 'IDENTIFIED BY '123456' WITH GRANT OPTION' at line 1

需要使用新的语句。

GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

参考：/doc/refman/8.0/en/grant.html