mysql允许任何用户访问

来源:互联网 发布:淘宝外观专利侵权投诉 编辑:程序博客网 时间:2024/06/07 01:27

update user set host = '%' where user = 'root';SELECT host, user FROM user;  

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;                                  123456为密码

FLUSH PRIVILEGES;

原创粉丝点击