mysql 如何开启远程连接
时间:2016-05-15 20:13 来源:linux.it.net.cn 作者:IT
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
即可开启远程连接
(责任编辑：IT)
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 即可开启远程连接 (责任编辑：IT) |