Skip to main content

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,

  • Remote Host : The remote MySQL server IP or Host Name to connect.
  • Remote MySQL  User :  The user name to authenticate to the remote mysql server.
  • Remote User Password : The remote mysql  user password.

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.

 

 

Back to top