mysql允许其他电脑访问,授权mysql允许其他电脑访问

1 关闭windows防火墙,或者 添加入站规则允许mysql的端口(默认3306)

2 授权mysql允许其他电脑访问

mysql -uroot -p

use mysql;

select host,user from user;

update user set host ='%' where user ='root';

flush privileges;

  https://blog.csdn.net/liu53782/article/details/127746935

posted @ 2023-06-22 17:03  浮尘微光  阅读(351)  评论(0)    收藏  举报