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.
Cuando lo necesites #
- 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 #
- Inicia sesión en DirectAdmin.
- Ir a Gestor de cuentas > Gestión de MySQL.
- Busca el Access Hosts option.
- Add the IP address that should be allowed to connect.
- Guardar.
La seguridad es lo primero #
Remote access widens who can reach your database, so keep it tight:
- Allow specific IP addresses, never a wildcard that opens it to everyone.
- Utiliza una contraseña segura para la base de datos.
- Remove access hosts you no longer need.
Conectando #
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.
Solución de problemas #
- Conexión rechazada: confirm your current IP is on the access hosts list.
- Acceso denegado: re-check the database user and password.
- IP keeps changing: ask your provider about a static IP or update the entry as needed.
¿Necesita ayuda? #
Si no consigues conectarte mediante el acceso remoto, nuestro equipo de asistencia puede ayudarte a través del chat en directo.
