Ubuntu Remotely Connect to MySQL Database

Ubuntu Remotely Connect to MySQL Database

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).

REGEX PostgreSQL Replace
PHP 7.1 with Win 10, XAMPP & SQLSRV Driver
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
October 1, 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://www.johnnyshongo.com/