Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060

Learning Hub Academy Feedback
, ,
1

hi,
i an getting below log-
System.Data.Odbc.OdbcException (0x80131937): ERROR [08S01] [MySQL][ODBC 8.0(a) Driver]Lost connection to MySQL server at ‘waiting for initial communication packet’, system error: 10060
why this error came and how to overcome from this error?

image
image742×862 94.2 KB

2

10060 is a Connection Time-out error that usually appears when the client does not receive a response from the server for a specific command. Most often this occurs when you try to connect in PASV mode to a server that prefers PORT for data connections. ERROR :> Can’t connect to remote server.
Found a reason - answering my question:

When I used to run MySQL from my application - it was running under system user privileges - so it used to pick " C:\WINDOWS\TEMP " as a temp directory- this directory was messed up - has lot of unnecessary files … and MySQL was stuck while processing files under this directory…

But when I ran it manually under My administrator account it was using his temp directory… C:\Users\USER_NAME\AppData\Local\Temp and everything was working like magic…

To fix this permanently I changed tmp directory through MySQL conf file and now My Application runs like the Wind… :slight_smile:

[mysqld]
tmpdir = 'PATH_TO_THE_DIRECTORY'

Unfortunately, i am not 100% sure in your case, but I think this will help get resolve your issue.
Best regards
Apps4Rent | CloudDesktopOnline

1 Like
3

Good tipp !
In my case it just was, that for any reason the user hat not sufficient rights on c:\windows\temp (Opened by explorer and Windows asked “yes” for access).
After that, trouble was solved :o)