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> can see Password The result returned a 41-bit string at starting with '*', and the first 16-bit MySQL official website gave two solutions 1, using new client API, 2, forced server uses old passwords Solution I first tried the first method, copy libmysql.dll from MySQL5.0 to the PHP expansion directory, replacing PHP The Libmysql.dll included in itself, 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' - Not specified program of.
