How to enable remote connection to MySQL server

[jasoothai]

I followed this :
1. Edit /etc/sysconfig/iptables file:

nano -w /etc/sysconfig/iptables

2. Add following line before COMMIT:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

3. Restart Iptables Firewall:

service iptables restart

4. Test remote connection:

mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb

But when executing first command I got like this :

?kdkkd??ddkd?kd?kdkkd?kkdkd?kd?kd?kd?kd?kd?kd?kd?k d?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd?kd? kd?kd?kd?kd?k$






















^G Get Help ^O WriteOut ^R Read File ^Y Prev Page ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where Is ^V Next Page ^U UnCut Text ^T To Spell

Expand

Where is the commit line ?


Noobish question.
What is the use of enabling remote connection to MySQL server ?
I had set "Disallow root login remotely? [Y/n] Y" in MySQL Secure Installation.
What to do now. Please help.

jasoothai Reviewed by jasoothai on 21st Jun 2012. How to enable remote connection to MySQL server I followed this : 1. Edit /etc/sysconfig/iptables file: 2. Add following line before COMMIT: 3. Restart Iptables Firewall: 4. Test remote connection: But when executing first command I got like this : Where is the commit line ? :( Rating: 5