b90220208
2005-12-02, 03:36 PM
目前最新 release 的 phpBB 2.0.18 在其官網上已宣稱支援 mysql 5
而在 PHP 方面好像沒有支援到 php 5,所以想請教該如何才能讓其在 php 5 下順利安裝與運作 ?? :eek:
以下是我的安裝經過,當搭配---
php 4:
則只要有處理了 authentication protocol 的問題,例如 mysql server 5 的密碼改用舊模式:
SET PASSWORD FOR user@host = OLD_PASSWORD('password');
就可順利執行安裝 phpBB2.
否則,就會出現如下之錯誤訊息:
----------------------------------------------------------------------------------------------
Warning: mysql_connect(): Client does not support authentication protocol requested by server;
consider upgrading MySQL client in ...\phpbb2\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
...\phpbb2\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
...\phpbb2\db\mysql4.php on line 331
----------------------------------------------------------------------------------------------
若換成 php 5:
則會出現錯誤訊息如下(什麼也沒提示)
---------------------------------
phpBB : Critical Error
Could not connect to the database
---------------------------------
以下,是我在 mysql 官網查到的資訊,若我沒會錯意,他的意思應該是 php 5 已經有支援 mysql 4.1 以上
的版本了,那麼為何會出現如上之無法連線資料庫的錯誤訊息? :eek:
我在安裝 Moveable Type 3.2 時,都很順利,難道是 phpBB2 沒有支援 PHP 5 嗎?
若我只想用 php 5 ,那該怎麼做,要改 phpBB2 的程式碼嗎? :eek:
==========================================================================================
The mysqli extension (stands for "MySQL, Improved"; added in PHP 5) is compatible with the
improved password hashing employed in MySQL 4.1 and higher, and no special configuration of
MySQL need be done in order to use this MySQL client library.
==========================================================================================
贊助商連結
而在 PHP 方面好像沒有支援到 php 5,所以想請教該如何才能讓其在 php 5 下順利安裝與運作 ?? :eek:
以下是我的安裝經過,當搭配---
php 4:
則只要有處理了 authentication protocol 的問題,例如 mysql server 5 的密碼改用舊模式:
SET PASSWORD FOR user@host = OLD_PASSWORD('password');
就可順利執行安裝 phpBB2.
否則,就會出現如下之錯誤訊息:
----------------------------------------------------------------------------------------------
Warning: mysql_connect(): Client does not support authentication protocol requested by server;
consider upgrading MySQL client in ...\phpbb2\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
...\phpbb2\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
...\phpbb2\db\mysql4.php on line 331
----------------------------------------------------------------------------------------------
若換成 php 5:
則會出現錯誤訊息如下(什麼也沒提示)
---------------------------------
phpBB : Critical Error
Could not connect to the database
---------------------------------
以下,是我在 mysql 官網查到的資訊,若我沒會錯意,他的意思應該是 php 5 已經有支援 mysql 4.1 以上
的版本了,那麼為何會出現如上之無法連線資料庫的錯誤訊息? :eek:
我在安裝 Moveable Type 3.2 時,都很順利,難道是 phpBB2 沒有支援 PHP 5 嗎?
若我只想用 php 5 ,那該怎麼做,要改 phpBB2 的程式碼嗎? :eek:
==========================================================================================
The mysqli extension (stands for "MySQL, Improved"; added in PHP 5) is compatible with the
improved password hashing employed in MySQL 4.1 and higher, and no special configuration of
MySQL need be done in order to use this MySQL client library.
==========================================================================================
贊助商連結