How to setup open MySQL Port (3306) on Ubuntu

by Petronald Green · June 24, 2013

Step 1: ensure we have mysql-server installed.

apt-get install mysql-server

Then: vim /etc/mysql/my.cnf

COMMENT OUT (with a '#'): 
"bind-address = 127.0.0.1"

Restart Server with

service mysql restart

——– To test with another linux client, use

mysql -h ip.or.hostname -u root -p

(ERROR 2003 (HY000): Can’t connect to MySQL server on ‘xyz’)

iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT

( ERROR 1130 (HY000): Host ‘69.80.43.240’ is not allowed to connect to this MySQL server)

Fix in phpmyadmin
Privileges Tab > root > add a new root with All hosts '%'