mac上mysql更改绑定ip

按照这样操作

mysql -u root -pvmware
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
mysql>grant all privileges on *.* to 'root'@'%' identified by '密码';
mysql>flush privileges;

一波操作猛如虎

netstat -an|grep 3306

mac  mysql 
更新时间:2014-03-07 16:38:32

本文由 智慧煮粥 创作,如果您觉得本文不错,请随意赞赏
采用 知识共享署名4.0 国际许可协议进行许可
本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名
原文链接:http://zz.zzhub.cn/archives/macmysqlip
最后更新:2014-03-07 16:38:32

评论

Your browser is out of date!

Update your browser to view this website correctly. Update my browser now

×