MySQL Remote connections
Allow Remote Connections
MySQL by default is set to only allow connections from the localhost. This is an issue if you are creating services that allow connections from outside the MySQL service location.
This is being done on an Ubuntu 20.04 server, your file location may vary.
Edit the mysqld.cnf file in the following location with the command sudo nano (or vi).
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
There are two lines that are important. The bind address port is required to be set to either the specific IP that you want MySQL to service on, or to set it to 0.0.0.0. This address is the “all” address and allows the MySQL server to answer on all ip addresses that are attached to the machine. If you change your port, make sure you specify the port in all config files as the default port is 3306.
port = 3306
bind-address = 0.0.0.0