Setup notes:

• Edit /etc/mysql/My.cnf. Change bind-address to internal ipaddress

  bind-address =xxx.xx.206.128 reboot server (seems that restarting MySQL was not enough)

• Add the user on an external machine you want to allow to connect

• login to MySQL: mysql --user=root --password=password

• CREATE USER 'user'@'ipaddress' IDENTIFIED BY 'password';

• GRANT ALL PRIVILEGES ON . TO 'scottlove'@'xxx.xx.206.128' WITH GRANT OPTION;

Connnect MySQL workbench to remote MySQL

• Create a new connection from my MySQL Workbench screen
• Connection method = Standard TCP/IP over SSH
• SSH Hostname: hostname:port
• SSH Username: login user name.
• use configure server Management butten to set it up.

JDBC driver

Add MySQL-connector-jave-5.1.30-bin.jar to modules in project structure (intellj)

#MySQL-connector pip install mysql-connector-python --allow-external mysql-connector-python

#ODBC driver on windows

• download and run msi installer
• go to programfiles/MySQL/connector odbc 5.1
• run myodbc-installer
• AdminTools->ODBC Data Sources(64bit)->Add