How to set up a remote MySQL access via cPanel?
Before you can remotely connect to your databases, the IP operating via a remote connection must be allowed on your account.
Log in to your cPanel account (via your customer account or https://www.bmoname.com:2083).
In the Databases section of the control panel, click the MySQL Remote icon.
In the Host field, you must enter the IP address from which the remote connection will be established. If you want to connect from any IP address, enter the % symbol.
You can also enter a description of the remote host in the Comment area under the Host field.
Once you have entered the necessary information, click the Add Host button.
The access host should then be added and become visible in the section at the bottom of the page. You can now use it to establish a remote MySQL connection.
Here are the steps to configure a remote MySQL access:
Log in to your cPanel account (via your customer account or https://www.bmoname.com:2083).
In the Databases section of the control panel, click the MySQL Remote icon.
In the Host field, you must enter the IP address from which the remote connection will be established. If you want to connect from any IP address, enter the % symbol.
You can also enter a description of the remote host in the Comment area under the Host field.
Once you have entered the necessary information, click the Add Host button.
The access host should then be added and become visible in the section at the bottom of the page. You can now use it to establish a remote MySQL connection.
Updated on: 20/04/2023
Thank you!