MySQL workbench failed to connect – Top 2 fixes

MySQL Workbench makes it possible for connecting to remote server databases from your individual laptop or computer.

Even so, MySQL workbench failed to connect errors come about due to MySQL version compatibility or set up troubles.

A single such error is,

Failed to Connect to MySQL at 7129bXXX43dc.XXXX.com:3306 via SSH tunnel at wheelxx@xxx.x.xxx.xx:2414 with user username

At Bobcares, we generally get requests from our shoppers to set up MySQL workbench as portion of our Server Management Solutions.

Now, we’ll see the leading motives that outcome in MySQL failed connection and how our Help Engineers repair them.

&nbsp

How to Connect to a Cloud Database by means of MySQL Workbench

MySQL workbench is s no cost, visual tool for database architects, developers, and DBAs. Also, it delivers a platform for database management like improvement, administration, database design and style, creation, and so forth. The upkeep of a database becomes simple with this special tool.

Properly, MySQL Workbench is offered on Windows, Linux and Mac OS X. And, that’s however yet another purpose for its reputation.

Right here, let’s see how our Help Engineers connect to Cloud Databases by means of MySQL Workbench.

1. Initially, we go to http://www.mysql.com/solutions/workbench/ and set up MySQL WorkBench.

2. Then, we launch MySQL Workbench, pick Server Administration >> New Server Instance selection.

3. We pick the Remote Host selection and enter the URL you received when you developed the database instance. Once again, we click Continue.

4. Subsequent, we go to Connection Process menu >> pick Normal TCP/IP more than SSH.

5. Also, we alter the worth for SSH hostname to name or IP address of a Cloud Server that we have developed.

6. Then, we enter the following worth as

  1. SSH Username:- cloud server user name
  2. MySQL Hostname:-  hostname received though building the database instance by means of the API.
  3. Username:- enter the username received when you developed the database instance.

7. Following that, we click Continue.

8. Lastly, we enter the database instance password.

That’s it, we’ll get the Server Administration screen.

&nbsp

Prevalent troubles soon after setting up MySQL Workbench

From our knowledge in managing servers, we’ve observed shoppers facing distinctive types of troubles soon after installing MySQL Workbench.

Let’s see how our Help Group solved these popular errors.

&nbsp

Missing SSL certificate

Not too long ago, one particular of our shoppers contacted us with a difficulty associated to MySQL Workbench. Also, each the SSH connection to the server and from the server to the cloud database worked. But when attempted connecting from MySQL Workbench, it didn’t function. He received an error from Workbench. The error stated,

Failed to Connect to MySQL at 7129b041xxxx476e8d37651071b12a6681b732.rackspaceclouddb.com:3306 via SSH tunnel at xxx.x.xxx.xx:2414 with user username connection error: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown.

On checking, our Help Engineers located that the difficulty was associated to the SSL of the Cloud instance. In order to resolve the difficulty, the solutions had been to either configure MySQL workbench to connect without the need of SSL OR configure SSL for the cloud instance.

Even so, configuring MySQL workbench without the need of SSL can be a safety danger. So, we set up SSL with the Cloud Database instance and solved the difficulty.

&nbsp

Incompatible MySQL version

Similarly, yet another client had an error when attempted to setup workbench for cloud hosting platforms like Appian. He got an error "failed to connect to MySQL at localhost 3306 with user root".

Whilst checking, our Help Engineers located that the installed version of MySql was MySql 8.X which is not compatible with workbench. As a result, we installed the Version 5.7.X version and it sorted out the difficulty.

[Never worry about MySQL workbench failed to connect errors anymore! We are here to fix it for you.]

&nbsp

Conclusion

In brief, errors like MySQL workbench failed to connect may well come about due to MySQL version compatibility or mainly because of missing SSL certificate. Now, we saw how our Help Engineers set up MySQL workbench and repair associated errors.

The post MySQL workbench failed to connect – Best 2 fixes appeared 1st on Bobcares.