mysql开启远程访问(无废话)

$ netstat -an | grep 3306 
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN

$ vi /etc/mysql/my.cnf

........
#将bind-address  = 127.0.0.1 前面加上 “#” 注释掉
#bind-address  = 127.0.0.1 
........

$ service mysql restart

$ netstat -an | grep 3306 
$ lsof -i : 3306
$ ps aux|grep mysql
root      3713  0.1  0.2   5064  1368 pts/0    S    10:20   0:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/bogon.pid
mysql     4096  0.3 19.2 332004 98160 pts/0    Sl   10:20   0:00 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-dir=/opt/lampp/lib/mysql/plugin/ --user=mysql --log-error=/opt/lampp/var/mysql/bogon.err --pid-file=/opt/lampp/var/mysql/bogon.pid --socket=/opt/lampp/var/mysql/mysql.sock --port=3306
root      4125  0.0  0.1   4356   736 pts/0    S+   10:22   0:00 grep mysql

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# skip-networking

$ iptables -A INPUT -i eth0 -p tcp --dport 3306 -j ACCEPT
$ iptables -A OUTPUT -p tcp --sport 3306 -j ACCEPT
$ service iptables save

$ mysql -u root -p
Enter password:

mysql> grant all privileges on *.* to `test`@"%" identified by "test用户的密码";