Allowing remote connections on your MySQL Database on Linux Hosting

KB Tags associated with this article:
Use all tags
KB Tags
adhoc1
Body

 

Before connecting to MySQL from another computer, the connecting computer must be added to the server as an Access Host to enable connection to the server.

Step 1:Log in to cPanel.

Login to the cPanel of the domain name for which you want to enable Cloudflare. 

Learn More 

Step 2: Add the Access Host.

Remote MySQL

  1. Once you access the cPanel, under the Databases section, click Remote MySQL.
  2. Under the Add Access Host section, add the IP address of your remote server or your public static IP address in the Host field. ​​​​​​​
  3. Click Add Host.

Adding the IP address will whitelist it and you will be able to make connections to the database from the whitelisted IP address. 

Configuration Settings:

Use the following configuration settings for connecting to your database

Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.