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.
Vam je bil ta članek v pomoč?
Hvala za vaše mnenje! Potrebujete pomoč? Odprite zahtevek.
Sorodni članki
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.