Remote Access to MySQL Database
In some cases, you may need to access your MySQL database from an external location, for example using desktop database tools or local development environments.
To allow this, you need to open port 3306, which is the default MySQL port used for remote connections.
Once the port is open, you can connect to the database using tools like:
- MySQL Workbench
- phpMyAdmin
- HeidiSQL
- Toad Edge for MySQL
- SQLyog
- Navicat for MySQL
Secure access via authorized IP addresses
To maintain security, it is strongly recommended to allow remote access only from trusted and specific IP addresses. You can configure this through your cPanel interface.
How to authorize an IP for remote access
Log in to your cPanel and locate the Remote MySQL section.
Adding an authorized IP address
In the input field, enter the IP address you wish to authorize for remote access. Optionally, you can include a description to easily identify the source of the connection.
Once added, the IP address will appear under the Manage Access Hosts list and will be able to connect to your MySQL server.
