Add Remote MySQL Server

To add a remote MySQL Server

You can add unlimited  number of remote  MySQL servers to your Eenos hosting control panel.

MySQL -> Add Remote MySQL Server

We recommend to add a MySQL 8 or higher compatible version of remote  database servers

You can add the MySQL  Community server, MariaDB server and Percona MySQL servers to the server pool.

Add A New Server

To add a new server you need to fill out the following,

Please  make sure the remote user have admin privileges on Mysql database , so that the user can create  other users and mysql databases

You may need to white list the remote server IP in firewall and open the mysql outgoing port 3306

How to grant remote user privilege ?

You need to perform the GRANT ALL PRIVILEGES query on the remote mysql server to allow your  Eenos server to connect to the remote database. An Example is given below

Your Eenos server IP is, 10.0.0.10

Remote server  user is , root

Remote mysql password is , changethis

Please  run the following query in remote MySQL server:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.0.10' IDENTIFIED BY 'changethis';

Please use a strong complicated password for the remote MySQL user.

 

 


Revision #1
Created 21 September 2023 09:20:46 by Eenos Official Editor
Updated 21 September 2023 09:32:38 by Eenos Official Editor