:: DEVELOPER ZONE
MySQL Reference Manual :: A.2.14 Ignoring user
Search the MySQL manual:
- A.2 Common Errors When Using MySQL Programs
- A.2.1 Access denied
- A.2.2 Can't connect to [local] MySQL server
- A.2.3 Client does not support authentication protocol
- A.2.4 Password Fails When Entered Interactively
- A.2.5 Host 'host_name' is blocked
- A.2.6 Too many connections
- A.2.7 Out of memory
- A.2.8 MySQL server has gone away
- A.2.9 Packet too large
- A.2.10 Communication Errors and Aborted Connections
- A.2.11 The table is full
- A.2.12 Can't create/write to file
- A.2.13 Commands out of sync
- A.2.14 Ignoring user
- A.2.15 Table 'tbl_name' doesn't exist
- A.2.16 Can't initialize character set
- A.2.17 File Not Found
Additional languages
Additional formats
If you get the following error, it means that when
mysqld was started or when it reloaded the grant
tables, it found an account in the user table
that had an invalid password.
Found wrong password for user
'
some_user'@'some_host';
ignoring user
As a result, the account is simply ignored by the permission system.
The following list indicates possible causes of and fixes for this problem:
You may be running a new version of mysqld with an old
usertable. You can check this by executing mysqlshow mysql user to see whether thePasswordcolumn is shorter than 16 characters. If so, you can correct this condition by running thescripts/add_long_passwordscript.The account has an old password (eight characters long) and you didn't start mysqld with the
--old-protocoloption. Update the account in theusertable to have a new password or restart mysqld with the--old-protocoloption.-
You have specified a password in the
usertable without using thePASSWORD()function. Use mysql to update the account in theusertable with a new password, making sure to use thePASSWORD()function:mysql> UPDATE user SET Password=PASSWORD('newpwd') -> WHERE User='some_user' AND Host='some_host';
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.