开启Mysql远程访问

Mysql默认是不可以通过远程机器访问的,通过下面的配置可以开启远程访问.
我的Mysql环境是ubuntu+mysql5
1.修改/etc/mysql/my.conf,修改bind-address,指定为本机实际IP地址,你的my.con修改完大概是如下的样子

<!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --> [mysqld]
#
# * Basic Settings
#
default - character - set = utf8
default - storage - engine = INNODB

bind - address     =   192.168 . 1.107

user             =  mysql
pid - file         =   / var / run / mysqld / mysqld . pid
socket            =   / var / run / mysqld / mysqld . sock
port             =   3306
basedir          =   / usr
datadir          =   / var / lib / mysql
tmpdir           =   / tmp
language         =   / usr / share / mysql / english
skip - external - locking

2.用root登陆mysql执行如下命令

<!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --> grant   all   on  sonardb. *   to  sonar@ ' % '  identified  by   ' 123456 ' ;
grant   all   on  sonardb. *   to  sonar @localhost  identified  by   ' 123456 ' ;

sonardb替换为你想访问的数据库名,sonar是你的想使用的用户名,123456替换为你的密码,这样就开启了远程访问功能.