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
February 27, 2020

Captcha Image

Latest Comments

Guest - Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Guest - Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Guest - Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.