Linux(Fedora) Enable mySql remote connection

Verify Service
#service mysqld status
#service iptables status

Add mySql deamon everytime

#chkconfig --level 2345 mysqld on

Firewall
#vi /etc/sysconfig/iptables


-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT  #mySQL Port

On MySQL


#mysql -u root

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit

References
[1] http://linuxers.org/howto/how-install-mysql-server-fedora