By default, your database only accepts connections from the server it lives on. If you need to connect from your own computer or an external application, you must allow remote MySQL access for a specific address. This guide explains how to do that safely in DirectAdmin.
Quand vous en avez besoin #
- Connecting a desktop tool like MySQL Workbench to your database.
- Allowing an external application or server to read your database.
- Letting a developer connect remotely for maintenance.
Allowing a remote host #
- Connectez-vous à DirectAdmin.
- Aller à Responsable de compte > Gestion de MySQL.
- Trouvez le Access Hosts option.
- Add the IP address that should be allowed to connect.
- Enregistrer.
La sécurité avant tout #
Remote access widens who can reach your database, so keep it tight:
- Allow specific IP addresses, never a wildcard that opens it to everyone.
- Utilisez un mot de passe solide pour votre base de données.
- Remove access hosts you no longer need.
Connexion #
Use your database name, username, password, the server hostname or IP, and port 3306 in your remote tool. If your own IP changes (many home connections do), you may need to update the allowed address.
Dépannage #
- Connexion refusée : confirm your current IP is on the access hosts list.
- Accès refusé : re-check the database user and password.
- IP keeps changing: ask your provider about a static IP or update the entry as needed.
Besoin d'aide ? #
Si la connexion à distance ne fonctionne pas, notre équipe d'assistance peut vous aider via le chat en direct.
