Remote MySQL

EasyEngine (ee)

Remote MySQL Server Setup:

1. Allow Remote Access
2. Grant Remote Access

EasyEngine Server Setup:

1. Provide Remote MySQL Credential
2. Provide MySQL Grant Host Information

Allow Remote Access

If you would like to access remote MySQL server from EasyEngine, You have to adjust some settings on remote MySQL server.

vim /etc/mysq/my.cnf

# skip-networking 
bind-address = <PUBLIC_IP_OF_EASYENGINE_SERVER>

Now restart MySQL server:

service mysql restart

Grant Remote Access:

mysql -u root -p

mysql > grant all privileges on *.* to 'root'@'<PUBLIC_IP_OF_EASYENGINE_SERVER>' with grant option;
mysql> flush privileges;

Provide Remote MySQL Credential

For MySQL credential EasyEngine used ~/.my.cnf file. We need to add remote MySQL server details in ~/.my.cnf file

vim ~/.my.cnf

[client]
host=<REMOTE_MYSQL_HOST>
user=<REMOTE_MYSQL_USER>
password=<REMOTE_MYSQL_PASSWORD>

Provide MySQL Grant Host Information

vim /etc/easyengine/ee.conf

[mysql]
    grant-host=<PUBLIC_IP_OF_EASYENGINE_SERVER>