bt下在安全开放3306端口
# 5.6
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
# 8.0
use mysql
select host,user,plugin from user;
update user set host='%' where user ='root';
select host,user,plugin from user;
FLUSH PRIVILEGES;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
select host,user,plugin from user;
FLUSH PRIVILEGES;