工欲善其事

8.X 版本的配置

mysql> create user 'root'@'%' identified by 'a123456';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'root'@'%';
Query OK, 0 rows affected (0.00 sec)

8.0之前的配置

mysql> grant all privileges on *.* to 'root'@'%' identified by 'PASSWD';