How to allow MySQL database to connect remotely in DirectAdmin?

DirectAdmin installs CSF firewall by default in its setup. You won't be able to access the MySQL port 3306 remotely using telnet. Also, you can't access the database remotely as well.  First of all, add port 3306 on your CSF firewall installed on DirectAdmin.

Allow MySQL Port on CSF

  1. Login to the DirectAdmin Panel. At the Extra features option, click on config server security & firewall.

  2. Click on the firewall configurations.

Uninstall Firewall

          If you would like to uninstall the CSF firewall, you can just run the below command and uninstall it. 

cd /etc/csf
sh uninstall.sh

Allow Database to connect remotely

  1. Log in to your User account created in DirectAdmin.

  2. Click on MySQL Management.

  3. Double click on your database name.

  4. At the Access Hosts, enter the IP Address of the remote location from where you want to connect remotely and click on Add New button.

Now, try to connect your database remotely, and it should work.

Related Articles

How to create a user account in DirectAdmin?

Please refer to the following article on creating a user account in DirectAdmin. Log in to...

How to install DirectAdmin controlpanel on Centos 7.x?

DirectAdmin is a GUI based control panel used for Linux OS like CentoOS and RHEL. It is cheaper...

How to create the MySQL database in DirectAdmin?

Perform the following steps to create the MySQL database from DirectAdmin control panel:...

How to move a website to the dedicated IP Address in DirectAdmin?

Please refer to the following steps to move the website or your domain name to the dedicated IP...

How to host a domain in DirectAdmin?

DirectAdmin is a hosting control panel for Linux server. Please perform the following steps to...

  • 0 Users Found This Useful

Was this answer helpful?