赵峰 | 赵峰之城 | 赵峰的博客

» 阅读全文

MYSQL 帮助：

A.2.3 Client does not support authentication protocol

MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:

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.


• When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.


• 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 and the OLD_PASSWORD() function:
  mysql> SET PASSWORD FOR
  -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
  
  Alternatively, use UPDATE and FLUSH PRIVILEGES:
  mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
  -> WHERE Host = 'some_host' AND User = 'some_user';
  mysql> FLUSH PRIVILEGES;
  
  Substitute the password you want to use for ``newpwd'' in the preceding examples. 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:
  
  
  
  1. Start mysqld with the --old-passwords option.
  
  
  2. Assign an old-format 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 account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.
  
  
  
  

For additional background on password hashing and authentication, see section 5.5.9 Password Hashing in MySQL 4.1.


例子：
SET PASSWORD FOR 用户名@localhost = OLD_PASSWORD('密码');

» 阅读全文

» 阅读全文

1、父子二人经过五星级饭店门口，看到一辆十分豪华的进口轿车。儿子不屑地对他的父亲说：「坐这种车的人，肚子里一定没有学问！」父亲则轻描淡写地回答：「说这种话的人，口袋里一定没有钱！」
(注：你对事情的看法，是不是也反映出你内心真正的态度？)

2、晚饭后，母亲和女儿一块儿洗碗盘，父亲和儿子在客厅看电视。突然，厨房里传来打破盘子的响声，然后一片沉寂。是儿子望着他父亲，说道：「一定是妈妈打破的。」「你怎么知道？」「她没有骂人。」

» 阅读全文

一 
一条猎狗将兔子赶出了窝，一直追赶他，追了很久仍没有捉到。 
牧羊看到此种情景，讥笑猎狗说“你们两个之间小的反而跑得快得多。” 
猎狗回答说："你不知道我们两个的跑是完全不同的！我仅仅为了一顿饭而跑，他却是为了性命而跑呀！" 

» 阅读全文

» 阅读全文

» 阅读全文

» 阅读全文