Definition
Error 1033 generally points to corruption of the .frm file for the table being queried. This can be caused by InnoDB reconfiguration, form file corruption, and permissions issued.
Sample
SELECT COUNT(*) FROM auth;
ERROR 1033 (HY000): Incorrect information in file: ‘./auth/auth.frm
Resolution
Check that the permissions on /tmp/ allow for reading and writing by the mysql user.
Stop MySQL, delete […]
Definition
Error 17 indicates that that either the MySQL server encountered an issue while trying to delete the directory containing the database to be dropped, or tried to create a temporary file that already existed during an ALTER TABLE statement.
Sample
mysql> DROP DATABASE foo;
Error dropping database (can’t rmdir ‘./foo/’, errno: 17)
mysql> ALTER TABLE foo …
Error on rename […]
Definition
The WITH ROLLUP clause is used with GROUP BY queries to generate extra rows in the dataset that represent group totals. Summary rows will show NULL in the group column(s) being summarized. WITH ROLLUP will summarize multiple level of groupings, providing totals across each group level. The WITH ROLLUP clause was added in MySQL 4.1.1.
The […]
Definition
When the MySQL server is installed as a service on Windows, it tries to use the service name mysql by default. If a previous installation was not completely removed before installing, this error can be encountered. This occurs because the mysql service already exists on the machine.
Sample
Cannot Create Windows Service for MySQL. Error:0
Resolution
Choose a […]
Definition
In MySQL version 4.1, the authentication protocol used for MySQL client-server communications was changed to make it more secure. This changed the format of hashed user passwords and broke compatibility for all clients and APIs designed against MySQL 4.0.
Sample
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL
Resolution
Upgrade to a 4.1 […]
Definition
Error 2003 indicates that the mysql client was unable to establish a connection with the MySQL server you specified.
Sample
C:\Documents and Settings\Administrator>mysql -u root -h 127.0.0.1 -p
Enter password: *****
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1′ (10061)
Resolution
Did you specify the correct hostname or IP address for the MySQL server? If you do not specify […]