trying to work with heidisql its not working and workbench keep freezing https://www.digitalocean.com/community/questions/unable-to-connect-to-mysql-server-using-heidisql
No need to change MySQL conf.
I’ve tried with HeidiSQL 9.2 @ Win7 Ultimate , and working well.
Networktype: MySQL (SSH tunnel) Hostname / IP : 127.0.0.1 Prompt for credentials: unchecked User: root Password: [root_password] Port: 3306 Compressed client/server protocol: unchecked
plink.exe location: C:\Program Files (x86)\PuTTY\plink.exe SSH host + port: [your_droplet_ip_address] Username: root Password: -leave empty- plink.exe.timeout: 5 Private key file: PATH_TO\private_key.ppk Local port: 3306
This worked for me https://rbgeek.wordpress.com/2014/09/23/enable-remote-access-of-mysql-on-ubuntu/ Enable remote access of MySql on Ubuntu Posted by rbgeek on September 23, 2014