Since started using MyDAC 3.30.1.13, I constantly get 'Lost connection to MySQL during query' error. I checked documentation and seems to me all possible causes from my side are ruled out.
Is it possible new MyDAC messed with TCP packet order so MySQL dropped the connection?
Lost connection to MySQL during query
Re: Lost connection to MySQL during query
We reproduced and fixed this error. Usually it happens on the execution of long queries. Fix of the problem will be available with the next version in about two weeks.
As a temporary solution you can set TMyConnection.Options.Direct := False
As a temporary solution you can set TMyConnection.Options.Direct := False