【搬运stackoverflow】
解决Navicat通过ssh方式连接远程数据库报错:The server key has changed. Either you are under attack or the administrator changed the key. New server key has
解决方式:移除Mac下~/.ssh/known_hosts文件,打开Finder,转到~/.ssh/这个路径下就找到known_hosts文件了,删除重新连接数据即可。
Question:
Navicat doesn't recognize new entries in known_hosts file on Mac and cannot connect to remote server
Answer:
UPDATE Feb 2022: this issue may have been fixed in more recent versions. See comments on the accepted solution.
Summary:
An existing connection to a remote database in Navicat was working using a domain name for the SSH > Host field. After building a new remote server and pointing the domain at the new IP address (and setting up the database and users, as well as adding your public RSA key to the new server), Navicat doesn't trust the key hash from the server. Replacing the entries in ~/.ssh/known_hosts
doesn't help.