Unable to connect to mysql on digitalocean using w

问题:

I have got my droplet set with the laravel app and database. Created my db while on putty ssh. Now when I am trying to connect to my mysql database as in image, i am getting error.

Error: Authentication error, unhandled exception caught in tunnel manager, plese refer to logs for details.

Note that my credentials are right, as that what I use to connect through putty. Any help on how can I see view my database?

回答1:

Got this solved like this.

Turns out this is an ssh level issue. The digital ocean server doesn't have the support for the Kex algorithm as mentioned in the error the following can be done to fix this.

Following steps needs to be done on the digital ocean server itself

1- Add the following lines to this file on the digital ocean server

$ sudo vim /etc/ssh/sshd_config

Ciphers [e-mail],[e-mail],aes256-ctr,aes128-ctr
MACs [e-mail],[e-mail],[e-mail],hmac-sha2-512,hmac-sha2-256,hmac-ripemd160,hmac-sha1
KexAlgorithms diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1,diffie-hellman-group-exchange-sha1

2- Restart the ssh service on the server

$ sudo service ssh restart

Now try connecting with mysql workbench again you should see that error gone. Check the logs for more errors if not successful but this did the trick for me.