MySQL

• MySQL Servers
• Add Remote MySQL Server
• MySQL Root Password

MySQL Servers

To Manage MySQL Database Servers

This page will show all MySQL database servers configured in your Eenos hosting control panel.

MySQL -> MySQL Servers

You can manage the local  MySQL server and remote  MySQL servers from Eenos.

The local MySQL servers can be restart and disable.

If the database server is disabled , users can't create databases on this server.

The remote MySQL servers can restart  ,  disable , Edit settings, and Delete

Deleting a remote MySQL server will only delete the server from Eenos. It doesn't delete the databases.

 

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.

 

 

MySQL Root Password

Reset MySQL Root Password

This option will help you to reset reset the root password of Local MySQL Server

MySQL -> MySQL Root Password

To reset the   root password of MySQL server click the button Reset MySQL Root Password

The admin panel  generate a complicated random password to reset the root password. 

You can only reset the local MySQL root password,  you can't reset the remote  MySQL root passwords.