By default your database only accepts connections from the server itself. To connect from your computer or an external application, you allow remote MySQL access for a specific address. This guide explains how in cPanel, safely.
Wanneer je dit nodig hebt #
- Connecting a desktop tool like MySQL Workbench.
- Allowing an external application or server to reach the database.
- Letting a developer connect remotely.
Allowing a host #
- Log in op cPanel.
- In de Databases sectie, openen Remote MySQL.
- Enter the IP address allowed to connect.
- Klik op Add Host.
Veiligheid voorop #
- Allow specific IPs, never a wildcard open to everyone.
- Gebruik een sterk wachtwoord voor de database.
- Remove hosts you no longer need.
Verbinding maken #
Use your database name, user, password, the server hostname or IP, and port 3306 in your remote tool. If your home IP changes, update the allowed address when needed.
Problemen oplossen #
- Verbinding geweigerd: confirm your current IP is on the list.
- Toegang geweigerd: re-check the user and password.
Hulp nodig? #
Als de verbinding via de externe toegang niet tot stand komt, kan ons ondersteuningsteam u via de livechat helpen.
