Monday, March 23, 2015

Remotely connecting to MySQL Server



If you want to connect the MySQL by MySQL Workbench you need to configure the MySQL config file.

·       Log in the server and navigate to my.cnf file

$ sudo nano /etc/mysql/my.cnf

·       And comment the following line 

#bind-address          = 127.0.0.1

·       Save the file (ctrl+o) 

·       Then restart the MySQL service.

$ sudo /etc/init.d/mysql restart 

·       Enable MySQL port form the Firewall

$ sudo ufw allow 3306

Now you can connect to the MySQL server remotely

0 comments:

Post a Comment