How to enable remote connection to MySQL server ?
I followed this :
1. Edit /etc/sysconfig/iptables file:
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.
I followed this :
1. Edit /etc/sysconfig/iptables file:
2. Add following line before COMMIT:nano -w /etc/sysconfig/iptables
3. Restart Iptables Firewall:-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
4. Test remote connection:service iptables restart
But when executing first command I got like this :mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb
Where is the commit line ?ïkdkkd¿½ddkd½kdïkdkkd¿kkdkd½kd�kd�kd�kd�kd�kd�kd�kd�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
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.
Last edited: