How to make MySQL 3306 port publicly available on Ubuntu 13.04 server

Question

I am a research fellow at a university in Canada.

I installed MySQL on a cloud server running Ubuntu 13.04; however, I want the MySQL server to be publicly available, but MySQL is blocking port 3306.

Can I get help or resources on how to unlock the MySQL port so that it is public?

Thanks Jeremy

+3

jeremie_se Feb 19 '14 at 14:47

1 answer

Jürgen Steinblock · Accepted Answer · 2014-02-19T14:48:27+0000

You need to edit the my.cnf file and bind it to an external address or the 0.0.0.0 file is usually located in/etc/mysql

bind-address 0.0.0.0

Config can also be set skip-networking, and you should comment on it with #or completely delete the entry.