sudo vim /etc/mysql/mysql.conf.d/mysqld.cnfHow 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: