To use Remote MySQL in cPanel, follow these steps:
-
Log in to your cPanel account.
-
In the "Databases" section, click on the "Remote MySQL" icon.
-
Under the "Add Access Host" heading, enter the IP address or hostname of the server that you want to allow to access your MySQL databases.
-
Click on the "Add Host" button.
-
The server will now be added to the list of allowed hosts.
-
To access the MySQL databases from the remote server, you will need a MySQL client. Some popular MySQL clients include MySQL Workbench (GUI) and mysql (command line).
-
Open your MySQL client and connect to the database using the MySQL username and password for your cPanel account.
-
You can now use the MySQL client to manage and query the database from the remote server.
That's it! You should now be able to use Remote MySQL to access your MySQL databases in cPanel from a remote server. Be sure to only allow access to trusted servers and to use strong passwords to protect your MySQL databases from unauthorized access.
