TCP/IP接続 memo
user権限の設定 $mysql> use mysql; $mysql> select User, Host from where User = 'user_name'; $mysql> update user set Host = 'ipaddress' where User = 'user_name';
my.cnf編集(ipアドレスで接続) [mysqld] skip-name-resolve
iptables設定 $/sbin/iptables -A INPUT -p tcp --dport 3306 -j ACCEPT $/etc/init.d/iptables save $/etc/init.d/iptables restart