Note: Â If you don't know what your IP address is, you can search "what is my ip" in Google and it will display your IP.
Adding an IP to cPanel's Whitelist
- In cPanel, find the "Databases" section.
- Select "Remote MySQL".
- Enter the IP address you wish to whitelist in the field provided.
- Click "Add Host".
Removing an IP from the Whitelist
Dynamic IP Addresses
If your IP regularly changes, you have what is called a dynamic IP address. Â You can manually update your IP in the whitelist every time it changes - this option is the most secure, as you're ensuring only you have access. Â On the other hand, you could add "%" to the whitelist, which will allow any IP to connect to your on-server databases. Â This is an insecure option, and is not recommended.
- Manually updated whitelist: Every time your IP changes, you log in to cPanel and update the whitelisted IP. Â This is the most secure option!
- Whitelist all IPs: Â Add "%" to the whitelist to allow all incoming IPs to connect to your databases. Â This is the least secure method, and as such we do not recommend it!
- Whitelist a subnet: Â If you notice that only the last two sections of your IP change, and the first two sets of numbers stay the same, you can whitelist that subnet. Â For example, 192.168.%.%, Â This is not very secure, but it is preferable to whitelisting all incoming IPs.