mysql8和mysql5.7远程访问略有不同
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'Nice_59421';
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.03 sec)
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Nice_59421';
Query OK, 0 rows affected (0.01 sec)
而且mysql8对于密码格式也有要求,需要有符号和大小写