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 firstname.lastname@example.org:2414 with user username
Now, we’ll see the leading motives that outcome in MySQL failed connection and how our Help Engineers repair them.
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
- SSH Username:- cloud server user name
- MySQL Hostname:- hostname received though building the database instance by means of the API.
- 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.
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.
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.
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.]
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.