討論區 › Database › MySQL 4.0.x and MySQL 4.1.x 認證方式的不同

JDP 發表於 2005-5-9 18:06:44

MySQL 4.0.x and MySQL 4.1.x 認證方式的不同

It's incompatibility of authorization MySQL 4.0.x and MySQL 4.1.x
Utilizing files authorization

for MySQL v4.0.x
libmysql.dll
php_mysql.dll

for MySQL v4.1.x
libmysqli.dll
php_mysqli.dll

使用MySQL 4.1.x解決方法：
'''phpMyAdmin'''
open config.inc.php (C:\appserv\www\phpMyAdmin)
On line 73
change
->from: 'mysql';
->to: 'mysqli';
'''PHP'''
open php.ini (C:\windows or C:\winnt)
On line 580
change
->from: extension=php_mysql.dll
->to: extension=php_mysqli.dll
'''restart Apache'''

JDP 發表於 2006-3-3 16:18:33

MySQL 4.1.x or MySQL 5.0 使用舊的密碼編碼

SET PASSWORD FOR root@localhost = OLD_PASSWORD('password');

查看完整版本: MySQL 4.0.x and MySQL 4.1.x 認證方式的不同