lost connection to server at 'reading authorization packet' system error 0

mfarag's profile image mfarag posted 3 months ago in General Permalink

We have recently went through the process of updating our the minor release on my HeidiSQL. The latest version seems to prevent us from connecting to any My SQL 8 clients. We can still connect to the 5.7 servers.

We've tried downloading the 8.4 library but we were still unable to connect.

We noticed a recent comment around HeidiSQL still using old offsets which have been deprecated in MySQL 8. Has a fix been released for this? as we downloaded the nightly installer and this still hasn't resolved.

ansgar's profile image ansgar posted 3 months ago Permalink

If the title bar in your HeidiSQL app shows a version 12.7.0.6861 or higher then you have that mentioned bugfix.

Some more details from the connection setup would be helpful. For example usage of SSH tunnel and/or SSL.

mfarag's profile image mfarag posted 3 months ago Permalink

We are currently using SSL. Please find attached a screenshot of the existing settings. Has a fix been released?

1 attachment(s):
  • heidisql
mfarag's profile image mfarag posted 3 months ago Permalink

Attached screenshot of the advanced settings

1 attachment(s):
  • advanced_settings
ansgar's profile image ansgar posted 3 months ago Permalink

In that case you should defintely not use libmariadb but the newer libmysql:

Description

I was thinking you already tried that?

mfarag's profile image mfarag posted 2 months ago Permalink

we've tried libmysql-8.4.0.dll but that didn't resolve the issue. Is there a workaround?

ansgar's profile image ansgar posted 2 months ago Permalink

Is the error message is still the same, or?

Do you always get that error, or is that sporadically only? If you once get a connection, probably this is relevant for you: https://dev.mysql.com/doc/refman/8.4/en/error-lost-connection.html

tariqzaidi's profile image tariqzaidi posted 2 months ago Permalink

Getting this error. Lost connection to server at 'reading authorization packet', system error: 0 image.png

mfarag's profile image mfarag posted 2 months ago Permalink

error is always the same unless we disable SSL in the advanced settings

ansgar's profile image ansgar posted 2 months ago Permalink

@mfarag if not done already please update to v12.8, and play with the new verification option in the SSL tab.

Please login to leave a reply, or register at first.