Allowing remote MYSQL connections is often done to enable a program on your personal computer to access a database on the server.
1. Download navicat free software here & install it on your computer.
https://www.navicat.com/en/download/navicat-for-mysql/
2. Login into your cPanel Account.
In the Databases section, click Remote MySQL.
In the Host field, enter the IP address from where you want to access your databases. (Find Your IPV4 Address Here)
You can enter something like 1.2.3.% if you want to allow a range if IP addresses.
Click Add Host.
Configuration Settings:
Use the following configuration settings for connecting to your database:
| Field | What to Enter |
| Connection Name | Enter Your Connection Name |
| Hostname | Enter Shared IP Address/Hostname/Domain Name (Cloudflare services must be disable (encase if you are using it) if you want to use domain name) |
| Port | 3306 (Default) |
| DB Username | Database user's username |
| DB Password | Database user's password |
Now You Can Connect to Databases Remotely From Computer Using Navicat Software.
