远程连接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