mysql设置远程可访问

mysql -u root -p

use mysql;

select host, user, authentication_string, plugin from user;

grant all privileges on *.* to 'root'@'%' identified by 'password';//设置所有人可访问

flush privileges;//刷新

 

 

 
posted @ 2019-11-11 17:28  二哈666欸  阅读(179)  评论(0编辑  收藏  举报