navicat 链接阿里云服务器数据库报80070007 的错误
navicat用ssh跳转登录mysql连接时报:
80070007: SSH Tunnel: Server does not support diffie-hellman-group1-sha1 for keyexchange
是由于ssh 配置缺少KexAlgorithms与Ciphers导致。
解决办法是进入/etc/ssh/sshd_config在最下面 加入下面配置:
KexAlgorithms diffie-hellman-group1-sha1,curve25519-sha256@libssh.org,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
执行下面代码
ssh-keygen -A
重启SSH
sudo service ssh restart