Access Vagrant MySQL DB from local HeidiSQL GUI

[expired user #7868]'s profile image [expired user #7868] posted 10 years ago in General Permalink
I've setup a Vagrant machine on Virtualbox, I have MySQL on the machine. What I would like to do now is, create and manage my DB from the HeidiSQL GUI on my local machine. I've tried SSH tunnel but haven't been able to get it to work because of a "could not execute plink" error (I left the field blank)
[expired user #7868]'s profile image [expired user #7868] posted 10 years ago Permalink
I've managed to connect to a session (downloaded plink and added the path)however, when connecting I do not see the databases on my vagrant machine, instead I see some databases from my local machine.

Any i've tried switching port numbers, but that always results in either an error or still connecting to local dbs
ansgar's profile image ansgar posted 10 years ago Permalink
Watch out in the lower log panel, if there is some error message due to plink.exe execution. Then, use a command line box and start plink.exe yourself with the same parameters, and try to connect via HeidiSQL on the right port number.
justrusty's profile image justrusty posted 4 years ago Permalink

I am having issues with this too. Everything seems set up fine, all ports etc are correct, but the connection times out. When running putty from command line it says FATAL ERROR: Network error: Connection timed out

If anyone has any ideas I would be very appreciative

justrusty's profile image justrusty posted 4 years ago Permalink

[FIXED] Was just a case of making sure all the ports and ip addresses were correct and adding a user with all privileges from all ips. I had simply misunderstood some of the configuration and had a wrong port for the ssh tunnel and wrong ip set for the database

Please login to leave a reply, or register at first.