MySql 修改登陆规则

每次搭环境都要重新修改, 记录一下:

在Linux里面:

# ./mysql -uroot -p
查看权限:

> use mysql;

> select host, user from user;

> grant all privileges on *.* to 'root'@'%';

> flush privileges;

> grant all privileges on *.* to 'root'@'%' identified by 'password!';

 

posted @ 2018-11-25 16:26  Montauk  阅读(108)  评论(0编辑  收藏  举报