If you see the error: Access denied for 'publickey'.

return to Navicat and click Test Connection again.

edit that file and remove the line starting with the domain for your remote server.

Users//Library/Containers/12/Data/.ssh/known_hosts

the results will include something like (using Navicat Essentials for PostgreSQL as an example):.

in Terminal, run sudo find ~ -name known_hosts.

on the SSH tab, change the Host field from a domain to the new IP address.

in Navicat, edit the database connection.

So updating ~/.ssh/known_hosts doesn't affect the Navicat connection to the remote server.

Navicat uses a different known_hosts file than the operating system does. How to get Navicat to accept the new known_hosts data and authorize the connection? Either you are under attack or the administrator changed the key. Navicat uses the updated ~/.ssh/known_hosts file to authorize connection to the remote serverĮrror: The server key has changed.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.

Mysql navicat mac