Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MySQL Workbench could not connect to the SSH Server, how to solve?

3720642Oct 11 2018 — edited Oct 29 2018

I've recently had to change the SSH keys of my hosts, due to them being virtualized clones. The problem is that now I don't know how to make MySQL Workbench connect with SSH. It gives me a warning stating that the public key changed (correct), then it gives me a generic error: "Could not acquire management access for administration System Error:"

Testing the connection will instead simply state Test Connection ERROR.

So, how do I make the workbench acknowledge the new SSH key and fix the warnings?

Possibly important to state, before I changed the keys, I could connect without a problem with the workbench SSH.

This post has been answered by 3720642 on Oct 29 2018
Jump to Answer

Comments

3720642
Answer

The documentation wasn't helpful. After some messing around I found out that the problem was because I forgot to delete the line from my user's known_hosts file regarding the old fingerprint. (/home/username/.ssh/known_hosts)

Marked as Answer by 3720642 · Sep 27 2020
1 - 2

Post Details

Added on Oct 11 2018
2 comments
7,891 views