How to allow MySQL to receive remote connections?

This is a very common question and I decided to make a short answer for my self and everyone else struggling with the same issue. No matter the environment you are running, all you will have to do is find the DBMS configuration file and replace the “bind-address”. Default value = 127.0.0 (local connections only) New value = 0.0.0.0 (listen on all interfaces) Now where’s the file located? That’s a great question. It depends on your environment and how MySQL was installed. In this guide I’m assuming you did the setup manually. Ubuntu:
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
Other unix systems: coming soon Windows: coming soon

Leave a Reply

Close Menu