By default, your database assumes it will only be talked to by "localhost"(your website).But what if you're developing a desktop app, or connecting from a reporting tool like Tableau?
The Firewall Barrier
For security, cPanel blocks external database requests. To open the gate, you must use the Remote MySQL tool.
How to Connect
- Find your IP address (Google "what is my ip").
- In cPanel, go to Remote MySQL.
- Add your IP to the access list.
- In your app, set hostname to your domain (e.g.,
championstack.com) instead oflocalhost.
Warning: Never use the wildcard
% (allow all IPs) unless strictly necessary. It opens your database to bruteforce attacks.
Flexible hosting for developers. Build better with Champion Stack.
Launch your idea today
Don't overpay for hosting. Get the speed and support you deserve starting at just R29/mo.
View Plans