Problems that cannot be logged in after mysql5 change code FelixSun 2004-04-19 First explain, the following description is limited to the WIN system other system I have not tried it, MySQL has modified the format of the user password since 4.1.1, from 16 points to the 16-bit 41, adopted a new verification method, but the previous client protocol does not support this method, so it causing the consequences that cannot be registered. Even if the password correctly logs in, prompts the following # 1250 - Client Does Not support authentication protocol requested by server; consider upgrading MySQL client executed in the window: C: / mysql / bin> mysql -urootWelcome to the MySQL monitor Commands end with; or /g.Your MySQL connection id is 1 to server version:. 5.0. 0-alpha-nttype '' help; '' or '' / h '' for help. Type '' / c '' to clear the buffer.mysql> select password ('' aa ''); ---- --------------------------------------- | Password ('' aa '') | ---------------------------------------- | * DEE59C300700AF9B586F9F2A702231C0AC373A13 | ------------------------------------------ 1 ROW IN Set (0.00 Sec) MySQL> From the above, the result of Password returns a 41-bit string starting with '' * '', and the first 16-bit MySQL official website gives two solutions 1, using new Client API, 2, forced server uses old password scheme I first tried the first method, copy libmysql.dll to PHP from MySQL5.0 In the extended directory, the Libmysql.dll included with the PHP itself is replaced, but the result is disappointing. PHP prompts to load php_mysql.dll failed: PHP Warning: PHP Startup: Unable to load Dynamic library '' C: / PHP5 / EXT / PHP_MYSQL .dll '' - Can't find the specified program.
