In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file;
/etc/mysql/my.cnf
Find the following line;
bind-address = 127.0.0.1
Comment it out, and change it to the following;
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
You then need to restart the MySQL service using the following line;
sudo service mysql restart
You should now be able to remotley connect to the MySQL database (assuming you have already created a database user and granted the necessary permissions).
By accepting you will be accessing a service provided by a third-party external to https://www.johnnyshongo.com/
Comments