Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't connect to MySQL server on MySQLCC ERROR 1043 Bad Handshake

I can't connect to my server221 with MySQLCC and also through my webpage. I have managed to connect to server 253 with no errors. I am not sure what is wrong but I keep getting the error 1043 bad handshake. I am positive that all my userID and password are keyed in correctly. I can even ping the server 192.168.0.221

I am changing PC and on my previous PC, I have managed to connect to the server221 flawlessly with the same settings. I don't know where to even start debugging. Please help.

Pic

like image 892
Hanz Cheah Avatar asked Apr 11 '18 05:04

Hanz Cheah


People also ask

What is a bad handshake error?

SSL Handshake Failed is an error message that occurs when the client or server wasn't able to establish a secure connection. This might occur if: The client is using the wrong date or time. The client is a browser and its specific configuration is causing the error.

Why MySQL server is not connecting?

Here are some reasons the Can't connect to local MySQL server error might occur: mysqld is not running on the local host. Check your operating system's process list to ensure the mysqld process is present. You're running a MySQL server on Windows with many TCP/IP connections to it.


2 Answers

Make sure the version that the server installed is the same as your ODBC Connector at your PC. For example is your server installed 5.7.16 MySQL. Then you have to installed the 5.7.16 ODBC Connector that comes with the msi file. Don't go to the web and download the latest ODBC connector. I will not work

like image 101
Hanz Cheah Avatar answered Sep 18 '22 12:09

Hanz Cheah


This type of error comes with Mysql server 5.1 or older with versions, you need to update your MySQL server version.

like image 42
arpitbhatt027 Avatar answered Sep 17 '22 12:09

arpitbhatt027