Error "invalid username / password" running lots of queries
Posted on 2003-11-17
I have an application written in Delphi7 that connects to MySQL 3.23.53 via dbexpress. I have a text file that i am trying to import and have a routine that gets this data and inserts it (using insert into and parameters). This works fine, but after about 1000-2000 updates i get the message "invalid username / password" trying to run a query (or anything).
I have split the file into blocks of 1000 rows and it works fine (if i wait for a minute before running the next 1000).
Is there a max queries per minute or am i way off the mark?