Remote MySQL

EasyEngine (ee)

Prerequisite

1. Allow Remote Access
2. Grant Remote Access

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>

Grant Remote Access:

mysql -u root -p

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