Error
MySQL said:Access denied for user: 'cp007'@'localhost' (Using password: YES)
----------------------------------------------------------------------------這個錯誤是你沒有權限或者密碼輸入錯誤.Error
MySQL said:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
------------------------------------------------------------------------
To solve this problem, you should use one of the following approaches: Upgrade all client programs to use a 4.1.1 or newer client library.
Use an account that still has a pre-4.1-style password when connecting to the server with a pre-4.1 client program.
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('mypass');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Substitute the password you want to use for mypass in the preceding example. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
Tell the server to use the older password hashing algorithm:
Start mysqld with the --old-passwords option.
Assign a password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;
For each such account, use the Host and User values and assign a new password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.
MySQL said:Access denied for user: 'cp007'@'localhost' (Using password: YES)
----------------------------------------------------------------------------這個錯誤是你沒有權限或者密碼輸入錯誤.Error
MySQL said:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
------------------------------------------------------------------------
To solve this problem, you should use one of the following approaches: Upgrade all client programs to use a 4.1.1 or newer client library.
Use an account that still has a pre-4.1-style password when connecting to the server with a pre-4.1 client program.
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('mypass');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Substitute the password you want to use for mypass in the preceding example. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
Tell the server to use the older password hashing algorithm:
Start mysqld with the --old-passwords option.
Assign a password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;
For each such account, use the Host and User values and assign a new password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货