打开MySQL数据库远程访问的权限

SELECT User, Password, Host FROM user; – 查看现有用户,密码及允许连接的主机
GRANT ALL PRIVILEGES ON . TO ‘root’@’116.231.135.93’ IDENTIFIED BY ‘ts1999#opw1’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘ts1999#opw1’ WITH GRANT OPTION;

flush privileges;

原文地址:https://www.cnblogs.com/hzcya1995/p/13310921.html