| Gordon Burditt 2005-06-25, 8:23 pm |
| >I just upgraded to Mandriva 2005 and I'm having issues
>creating users in mysql. I'm doing the user creation
>using webmin. I keep getting the following error
>
>"Lost connection to MySQL server during query"
This error message can be caused by several problems:
1. Your connection exceeded its idle timeout and got dropped by the server.
This is especially an issue if persistent connections in PHP or
mod_perl are used and you have an idle timeout set.
2. The MySQL server was restarted since the connection was established
(e.g. with mysqladmin shutdown).
2a. The MySQL server dumped core (and may have been restarted
by safe_mysqld). I had this problem with mysqld 5.0.3; 5.0.6
seems to have fixed it. (Those versions aren't for production.)
3. Something in the client scribbled on the mysql connection handle
structure. This was difficult to find with the C API, but unlikely
to be the problem if you are accessing mysql via PHP or Perl.
Gordon L. Burditt
|