SSH Host Key Verification Error in dbForge Studio for MySQL

Attempting to connect to a server over SSH may fail with the following error message:

Can't connect to SSH server: The computed hash verification does not correspond to the received. (code 0)

The same connection may work successfully in PuTTY or other SSH clients.

This issue is commonly observed after the SSH server has been updated or its host key has changed.

Cause

dbForge Studio for MySQL stores SSH host keys in the local known_hosts file. If the host key presented by the server no longer matches the cached entry, the SSH connection is rejected to prevent potential security risks.

Resolution

1. Create a backup copy of the following file: %SystemDrive%\Users\%UserName%\.ssh\known_hosts
   
2. Open the known_hosts file in a text editor.
   
3. Locate and remove the entries corresponding to the SSH host you are trying to connect to.
   
4. Connect to the server again using an SSH client. After a successful connection, a new entry containing the current host key is automatically added to the known_hosts file.
   
5. Try connecting to the server from dbForge Studio for MySQL again.
   

Additional Information

If the issue persists after updating the known_hosts file, verify that the server host key has not changed unexpectedly and that the connection is being established to the correct SSH server.

• Related Articles

• How to Connect to MySQL Server

  In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

• Timestamps Not in Expected Timezone in dbForge Studio for Oracle

  If you're encountering timestamps that don't match your system's timezone in dbForge Studio for Oracle, this can typically be resolved with a quick configuration update. This issue may arise due to default formatting settings or discrepancies in how ...

• Creating a Connection from External Parameters in dbForge Studio for MySQL

  dbForge Studio for MySQL does not currently support creating or opening connections by passing connection parameters through command-line arguments or Privileged Access Management (PAM) solutions. The workaround described below allows a connection to ...

• Error: “Feature is not supported” (license key validation in .NET Standard)

  This error occurs when Devart .NET Standard assemblies cannot validate a license key at runtime. The guidance applies to all dotConnect providers. After migrating a working .NET Framework application to .NET Core / .NET 6–9 and referencing NuGet ...

• "Object Does Not Exist" Error During Data Export from the Command Line (MySQL)

  When exporting data from the command line using the /dataexport utility, the following error may occur: "Object 'database_name' does not exist" The database or object exists and can be accessed normally, but the export operation fails. This issue ...