mysql

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

To view the MySQL listener ports: netstat -an | grep 3306 

The remote connection at 10065 firewalls do not open

/etc/sysconfig/Modify IPTABLE add
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
Restart the firewall
/etc/init.d/iptables restart

MySQL remote access authorization
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'admin' WITH GRANT OPTION;
 
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'admin' WITH GRANT OPTION;
 
FLUSH PRIVILEGES ;

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Enoch at December 09, 2013 - 11:28 PM