Remote MySQL access
How to allow connections to your database from your computer or another server using Remote MySQL.
By default only a script running on the same server can connect to the database. If you want to connect from a tool such as MySQL Workbench, DBeaver or from another server, you first need to allow your IP address.
- Find your public IP address (search for "what is my IP").
- In cPanel open Databases → Remote MySQL.
- Enter the IP address in the Host field and click Add Host.
- In your connection tool enter the server address (see your welcome email or Access details and addresses), port 3306, and the database user and password.
Security tips#
- Add only the IP addresses you really need. Avoid the wildcard
%, which allows the entire internet. - Home IP addresses often change. When the connection stops working, check whether your IP changed and remove the old one.
- Use a strong, unique password for the database user.
- When you no longer need remote access, remove the host from the list.
War dieser Artikel hilfreich?
Danke für Ihr Feedback! Brauchen Sie Hilfe? Eröffnen Sie ein Ticket.
Verwandte Artikel
Creating a new MySQL databaseHow to create a database and a user in cPanel and link them with the right privileges.Connecting to a database from PHPA PDO and mysqli connection example using localhost, and the most common connection errors.Account security and passwordsPractical measures to protect cPanel, email and your site: strong passwords, updates and safe habits.phpMyAdminBrowse, edit and search database tables through a web interface.