on the SSH tab in the 'Edit Connection.' window, click 'Test Connection'.in Navicat (specifically Navicat Essentials for PostGreSQL, but this issue will apply to any app in the Navicat suite on Mac) edit an existing connection to the remote server.in Terminal, ssh into the new remote server using the domain, and follow the prompts to add the new server to the known_hosts file.add the remote database and users on the remote server.add your RSA public key to the authorized keys on the remote server.point the domain for a remote database at a new IP address.Replacing the entries in ~/.ssh/known_hosts doesn't help.

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. Summary:Īn existing connection to a remote database in Navicat was working using a domain name for the SSH > Host field. UPDATE Feb 2022: this issue may have been fixed in more recent versions.

Key navicat for mysql