命令如下,登录ssh ~~~ mysql -u root -h localhost -p use mysql update user set host='%' where user='root' and host='localhost';//所有机器可连接 update user set host='106.39.178.131' where user='root' and host='localhost';//指定ip可连接 GRANT ALL PRIVILEGES ON *.* TO '用户'@'%'IDENTIFIED BY '密码' WITH GRANT OPTION; 指定用户可远程连接 flush privileges; ~~~