2
Guys I am trying to create a java environment in Vagrant, I installed mysql and I am not able to connect to my vm mysql by my Workbench on the host. This key that I am using is exactly the same one that I use in Putty via ssh and the right one. I also used this mysql user and password in vm.
Can anyone help me? Thanks!
0
This was his solution, but it is not the most appropriate for this problem. This happens because versions higher than 6.3 mysql Workbench do not accept the extension .ppk ssh key.
In my case, I had problems with Workbench version 8.0.
The most suitable solution for this problem is to perform the ssh key conversion with the . ppk extension to the Openssh format.
To do so, open Puttygen > Conversions > Import Key > 'Select your key . ppk' > Export Openssh > Select your directory and save.
Use this ssh file, and run the test on the connection again that will work.
Remember that this is only possible if the ssh key is included in the "authorized_keys" file of the remote server.
Reference:
https://dev.mysql.com/doc/connector-net/en/connector-net-ssh-tunneling.html
0
Hello, I managed to solve my problem the resolution was clueless pq so the key I was using in Workbench is the same of my Putty that I use to connect via SSH without asking password, then I removed the key from my Workbench and used the VM password and it worked. Thank you all.
Browser other questions tagged mysql-workbench ssh vagrant
You are not signed in. Login or sign up in order to post.
See the date of the question and the answer. When so make clear in your reply that it is an update of knowledge and not a disqualification from another or other answers.
– Augusto Vasques