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

Rate this blog entry:
PHP 7.1 with Win 10, XAMPP & SQLSRV Driver
REGEX PostgreSQL Replace

Comments

 
No comments yet