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?
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…
[mysqld] tmpdir = 'PATH_TO_THE_DIRECTORY'