Accessing your MySQL database from a remote server can be useful in case you would like to connect directly to your databases.
However, please note that this is only possible from HybridCloud and dedicated services.
If your service allows it, you can then access the MySQL database remotely by following the steps below.
Step 1 – Configuration in cPanel
- In the home page, choose “MySQL Remote” and fill in the “Remote Host” field:
- Enter an IP address.
- Once this is done, click on the Home button at the top left of the page, and choose “MySQL Database” this time.
- Create a new user with a password at the bottom of the page and give him restricted rights (e.g. SELECT, UPDATE, etc.).
Step 2 – Configuration of the Client Application
Create the connection string by filling in the following configurations:
- Database: mysql://IPOFSERVER/DatabaseName or hostname (name of the server).
- User: MyNewUser.
- Password: MyNewPassword.
Step 3 – Open port 3306 in TCP_IN
The adjustment of the firewall configuration will be required.
To do this, you will need to contact PlanetHoster team by ticket via the My Support section of your Customer Area.