| Bug #16629 | ERROR 2013 (HY000): Lost connection to MySQL server during query | ||
|---|---|---|---|
| Submitted: | 19 Jan 2006 11:46 | Modified: | 19 Jan 2006 12:16 |
| Reporter: | Bastian Schern | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.18-max-log | OS: | Linux (SuSE 9.1) |
| Assigned to: | CPU Architecture: | Any | |
[19 Jan 2006 12:16]
MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=15598
Description: The whole server crashes if I use the SET PASSWORD command is used. Error message: "ERROR 2013 (HY000): Lost connection to MySQL server during query" The server is not crashing if the UPDATE command is used to set a new password. How to repeat: mysql> SET PASSWORD FOR 'admin'@'' = PASSWORD('secret'); ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE *** ERROR 2013 (HY000): Lost connection to MySQL server during query Suggested fix: UPDATE mysql.user SET Password=PASSWORD('secret') -> WHERE User='admin' AND Host='';