Navicat使用SSH远程连接到MySql,报错80070007: SSH Tunnel: Server does not support diffie-hellman-group1-sha1 for keyexchange
尝试使用Navicat远程连接到我在阿里云服务器上的MySql,通过SSH。![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-U00bkrNo-1657865578997)(readmin.assets/1442251-20190103214414659-810146728.png)]](https://code84.com/wp-content/uploads/2022/09/8d4df51878f74ee99fb8617d1012163d.png)
但是报错: 80070007: SSH Tunnel: Server does not support diffie-hellman-group1-sha1 forkeyexchange
解决方案:【亲测有效】
1.打开
sudo vim /etc/ssh/sshd_config
2.在最后添加
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
3.wq!保存
4.执行 重新生成所有键:
ssh-keygen -A
5.重启ssh服务
sudo service ssh restart
再次连接,成功!
![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-rU4oEyXO-1657865578998)(readmin.assets/1442251-20190103215040342-1763178327.png)]](https://code84.com/wp-content/uploads/2022/09/c030a00c4259420b94ab3afa688c9a19.png)