This post will show you how to whitelist your IP so that Linux dedicated servers can accept remote MySQL connections.Here are the steps for adding your IP address on the cPanel whitelist.
- Login to your cpanel account
- Search for Remote MySql or it will find under Database section
- Click on Remote mysql.
- New page will be open, Under Host field enter the IP address of your computer.
- Comment is Optional.(You can enter anything related to IP).
- Click on Add Host Button.
- Added IP list will be show under Manage Access Hosts
In this way you can access your Mysql Databases remotely.
How to view your personal computer IP
Use https://whatismyipaddress.com/ to view your personal computer IP address.
If IP constantly changes.
If your IP address changes whenever you go online or every so often. You have a couple of alternatives here. The most secure method would be to update your IP address in Remote MySQL whenever it changes. However, there are alternative solutions available to you. In the Add Access Hosts text field, you could type% (a percentage symbol). This allows any IP address to connect to your databases remotely. Another possibility is that the first two portions of your IP address never change. Then you may type 93.138.%.%, where the first two characters are your IP address.
