1、mysql -uroot -proot
2、use mysql;
3、insert into user(host,user) values('%','root');
4、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
5、service mysql restart
即可开启远程连接
1、mysql -uroot -proot
2、use mysql;
3、insert into user(host,user) values('%','root');
4、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
5、service mysql restart
即可开启远程连接