Enable and Allow Remote Access to MySQL Server

By default your MySQL Server has default configuration to allow only local connection. So if your application connects MySQL in localhost, then the basic configuration can be left untouched.

If you are planning to allow and enable remote access to MySQL server, then follow the steps below :

Find the MySQL configuration file which mostly is located at /etc/my.cnf. Using a shell editor like vim or nano, find the following line and comment it

bind-address = x.x.x.x (x.x.x.x points to the ip address you wanted to access from remotely, incase multiple servers, just comment it like below)

#bind-address = x.x.x.x

Also for people using old MySQL server, make sure you also comment the following line

# skip-networking

Restart your MySQL server

service mysqld restart

and try to connect your application with database present in remote server.
Note: You also need to give GRANT access to the db user on that particular DB.


Also published on Medium.

Author: Sankaranand

I'm a Web Strategist & Agile Project Manager with an Engineering in Information Technology. I specialise in creating Strategy for The Web and developing websites for businesses. I also blog about technology and life.

Leave a Reply

Your email address will not be published. Required fields are marked *