打开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;

posted @ 2016-01-16 17:40  陆陆通通  阅读(122)  评论(0编辑  收藏  举报