Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

mysql

windows

networking

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
Sign in to Comment

Related questions

MySQL - How to modify column default value?
Mysql date warning data truncated
how to convert mysql database to class diagram
MySQL Insert 20K rows in single insert
Can't persist emojis with mysql and hibernate
Codeigniter : Error in ORDER BY CASE query
Auto increment by 1 in MySQL with clearDB
How to get COUNT query in django
How to do database version control without migration of specific framework? [closed]
unique combination of 2 columns in phpmyadmin database
Replicate my local database (Mysql) to remote database( phpmyadmin)
Why does a SQL query with != 0 not include NULL values?
com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
phpMyAdmin import file size 2M limit
How to convert from java.sql.Date to ZonedDateTime
SQLAlchemy AttributeError: 'Query' object has no attribute '_sa_instance_state' when retrieving from database
Get current year in MySQL WHERE clause
Can a Foreign Key be part of a Composite Primary Key for another table?
Multi-language indexes with Laravel Scout and Algolia
Laravel: How to get custom sorted eloquent collection using whereIn method

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!