Configure Navicat to Access Remote Mysql – dedicated server

i got this error messages when access mysql from navicat tools

ssh tunnel server does not support diffie-hellman-group1-sha1 for keyexchange

the solution is :

you have to provide the correct key exchange

with your ubuntu dedicated server

sudo nano /etc/ssh/sshd_config

add this line at the bottom of our sshd config files :

KexAlgorithms diffie-hellman-group1-sha1,,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1
Ciphers 3des-cbc,blowfish-cbc,aes128-cbc,aes128-ctr,aes256-ctr

save it and run this :
ssh-keygen -A

and then restart ssh services:
sudo service ssh restart

now you can connect with your navicat. 

Rio - 1n4XVNjEASLdUmGojJfoD5JS21bD3JLZ9

Leave a Reply

Your email address will not be published. Required fields are marked *