Ubuntu系统中MySQL服务器搭建,用户设置权限,以及允许网络访问

MySQL服务安装:

http://blog.youkuaiyun.com/lizuqingblog/article/details/18423751

新建用户可以参考:

http://blog.youkuaiyun.com/leili0806/article/details/8573636

允许网络访问:

$sudo vim /etc/mysql/my.cnf

找到如下部分:
# Instead of skip-networking the default is now to listen onlyon
# localhost which is more compatible and is not less secure.
#bind-address 

         = 127.0.0.1 <---注释掉这一行就可以远程登录

参见:

http://blog.sina.com.cn/s/blog_60fcb5a10100qkyb.html