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
*Edify your MySQL "Losing Connection" Error with MySQL Remote Support *
At whatever point you are using MySQL Database by then damn without question you need to confront a kind of specific issue which ousts you to work with your MySQL Database. In any case, now you don't need to go up against this issue over and over in light of the route that at Cognegic we give MySQL Server 5.0 Support and in addition offer to wrap up the straightforwardness and execution of your MySQL Database. Our exceedingly committed masters increase the database execution and application transparency. So rapidly contact to MySQL Enterprise Backup and light up these issues inside surveyed day and age.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- firstname.lastname@example.org
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801