cent os mysql can not worked for remote access
1.error you need the SUPER privilege for this operation fixed: first ssh: # service mysqld stop # /usr/bin/mysqld_safe --skip-grant-tables second ssh: # mysql mysql> use mysql; mysql> select Host,User,Password from user; mysql> update user set Host= '%' ,Password=PASSWORD( 'your new password' ) where User= 'root' and Host= 'localhost' and Password= 'root3306' ; mysql> flush privileges; mysql> exit; # /etc/init.d/mysqld restart then first ssh can continue work. 2.error 10060 to login remote mysql,open firewall in linux: # /sbin/iptables -I INPUT -p tcp --dport 80 -j ACCEPT # /sbin/iptables -I INPUT -p tcp --dport 22 -j ACCEPT # /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT # /etc/rc.d/init.d/iptables save