允许局域网内其他主机访问本地MySql数据库

安装 https://www.bilibili.com/video/BV184411N76t?from=search&seid=15165680174824011451

alter user user() identified by "XXXXXX";

 

>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>select host, user from user;
mysql>flush privileges;