mysql_note

远程连接mysql 

#mysql -hxx.xx.xx.xx -uusername -ppassword

ERROR 2003 (HY000): Can't connect to MySQL server on 'xx.xx.xx.xx' (113)
mysql在iptables中添加规则：
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

ERROR 1045 (28000): Access denied for user 'root'@'xx.xx.xx.xx' (using password: YES)
mysql远程授权：

grant all pricileges on *.* to root@xx.xx.xx.xx identified by 'password';

多网卡，配置监听端口

[mysqld]
bind-address=0.0.0.0

远程连接 慢
[mysqld]
skip-name-resolve