MySQL Manual
A Problems and Common Errors
- A.2 Common Errors When Using MySQL
- A.2.1
Access deniedError - A.2.2
MySQL server has gone awayError - A.2.3
Can't connect to [local] MySQL serverError - A.2.4
Client does not support authentication protocolerror - A.2.5
Host '...' is blockedError - A.2.6
Too many connectionsError - A.2.7
Some non-transactional changed tables couldn't be rolled backError - A.2.8
Out of memoryError - A.2.9
Packet too largeError - A.2.10 Communication Errors / Aborted Connection
- A.2.11
The table is fullError - A.2.12
Can't create/write to fileError - A.2.13
Commands out of syncError in Client - A.2.14
Ignoring userError - A.2.15
Table 'xxx' doesn't existError - A.2.16
Can't initialize character set xxxerror - A.2.17 File Not Found
- A.2.1
A.2.14 Ignoring user Error
If you get the following error:
Found wrong password for user: 'some_user@some_host'; ignoring user
this means that when mysqld was started or when it reloaded the
permissions tables, it found an entry in the user table with
an invalid password. As a result, the entry is simply ignored by the
permission system.
Possible causes of and fixes for this problem:
-
You may be running a new version of
mysqldwith an oldusertable. You can check this by executingmysqlshow mysql userto see if the password field is shorter than 16 characters. If so, you can correct this condition by running thescripts/add_long_passwordscript. -
The user has an old password (8 characters long) and you didn't start
mysqldwith the--old-protocoloption. Update the user in theusertable with a new password or restartmysqldwith--old-protocol. -
You have specified a password in the
usertable without using thePASSWORD()function. Usemysqlto update the user in theusertable with a new password. Make sure to use thePASSWORD()function:mysql> UPDATE user SET password=PASSWORD('your password') -> WHERE user='XXX';
