mysql允许远程连接

2017-07-05  本文已影响0人  残风疏影

use mysql;
update db set host = '%' where user = 'root';
flush privileges;
grant all privileges on . to 'root'@'%' identified by '123456' with grant option;

修改ip

vim /etc/mysql/my.cnf

重启服务

service mysql restart

上一篇 下一篇

猜你喜欢

热点阅读