Add a specific domain name or IP to allow visitors to connect to MySQL databases.

**Step 1**

Logged into your cPanel in the “Database” section, locate the “Remote MySQL” item.

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalZRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--edc31dc9ab533dd9d0af47866cbbd75c82fc696f/image%20(86).png)

\
**Step 2**

Now enter the hostname (domain, server or IP address).
  

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalpRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--d01ddded03d1cd52c2acec72f327f419ff170a48/image%20(87).png)

\
The wildcard character “%” is allowed, when using it you allow access to all IPs that begin with 170.245.65 by replacing the final numbers with “%”.

Then just click on “Add host” and a success message should be displayed on your screen.

\
![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBamhRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--333a46d1444c67fe0dada1e43f9ab683ec1278b4/image%20(88).png)

**Step 3**

If you want to remove access to your bank, simply click “delete” on the item you want to remove.

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBamxRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c198bbe0436d2fd223d5b6a61dfaf0115a9da04d/image%20(89).png)

\
**Step 4**

You will be directed to this screen, and just click on “remove access host” and wait for a success message to be displayed on your screen.

![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBa1pRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--065a97abda99d901754f07a1190be58d384d5174/image%20(90).png)

\
![](http://34.207.224.239:3000/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBa2RRIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1c2228d978e6e79b933070d3ebe9afcbb73f8735/unnamed%20(10).png)

​\
Hope this helps !