Spec-Zone .ru
спецификации, руководства, описания, API
|
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 user
table. You can check this by executing mysqlshow mysql user to see whether the Password
column is shorter than 16 characters. If so, you can correct
this condition by running the scripts/add_long_password
script.
The account has an old password (eight characters long). Update the account in the
user
table to have a new password.
You have specified a password in the
user
table without using the PASSWORD()
function. Use mysql to update the account in the user
table with a new password, making sure to use the PASSWORD()
function:
mysql>UPDATE user SET Password=PASSWORD('
->newpwd
')WHERE User='
some_user
' AND Host='some_host
';