How do I Access Remote Mysql Database from Dedicated Server ?
Dedicated Server have the facility to access the remote database from this server . For this we need to allow the certain port in the server firewall. Once it is allowed we have to allow that remote server IP in the server to access the database.
Share This Now: [addtoany]
Watch Reseller Hosting Video Tutorial
Procedure
Access Remote Mysql Database from Dedicated Server
To Access the MySQL Database from remote server need to do some setting in our server, please follow the below procedure,
1. Login to the Dedicaed Server WHM as root user.
2. To access the MySQL Database as remote we need to enable the port 3306 in the firewall of that server, after that you can allow the IP address of remote server in the cPanel of that domain.
3. Go to the path,
Home » Plugins » ConfigServer Security & Firewall
4. Here you can able to see the option ” Firewall Configuration ”
5. Click that option and allow the port 3306 in both the options “TCP_IN =” and ” TCP_OUT = ” .
6. After allowing click “change” and restart the firewall. Now you can able to connect to the remote database from your server.
