[問題]配置Appserv 2.3.0 仍連接不到Mysql
版主: 版主管理群
版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
本區是討論關於 phpBB 2.0.X 架設安裝上的問題,只要有安裝任何外掛,請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表,違者砍文)
[問題]Could not connect to the datab
我的問題好像也是一樣呢?詳情如下:
●架設主機作業系統:Windows Xp Pro
●快速架站程式:Appserv 2.3.0(phpmyadmin 2.5.5)
●上網方式:ADSL
● phpBB2 版本:phpBB 2.0.6(c)
大家好:
我在C:\AppServ\www\ 下,把phpMyAdmin 改成 Xxx_phpMyAdmin 後,
設定管理帳號後,刪掉root帳號,再安裝php-nuke,可正常安裝,但卻一直無法安裝phpbb2 2.0.6 ,我試了快10次了,帳號、密碼都試了,但還是無解,
不知與更改phpmyadmin名稱有關否?
*錯誤訊息如下:
Warning: mysql_connect(): Access denied for user: 'phpbb2@localhost' (Using password: YES) in c:\appserv\www\phpbb2\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\phpbb2\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
●架設主機作業系統:Windows Xp Pro
●快速架站程式:Appserv 2.3.0(phpmyadmin 2.5.5)
●上網方式:ADSL
● phpBB2 版本:phpBB 2.0.6(c)
大家好:
我在C:\AppServ\www\ 下,把phpMyAdmin 改成 Xxx_phpMyAdmin 後,
設定管理帳號後,刪掉root帳號,再安裝php-nuke,可正常安裝,但卻一直無法安裝phpbb2 2.0.6 ,我試了快10次了,帳號、密碼都試了,但還是無解,
不知與更改phpmyadmin名稱有關否?
*錯誤訊息如下:
Warning: mysql_connect(): Access denied for user: 'phpbb2@localhost' (Using password: YES) in c:\appserv\www\phpbb2\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\phpbb2\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\phpbb2\db\mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
[問題]cap lock is what?
你好:我剛接觸這方面不久,不知你言的cap lock 在那,可否幫我解惑?Martinet 寫:確定一下是不是不小心按到 caps lock吧...XD(我就有這樣過..而且裝了不下15次都裝不下去=.......................=)
先謝謝你了。\\r
afa
[問題]PMA Database .. 未能確定...功能未啟動
不好意思,原來講的是鍵盤,還以為講phpmyadmin方面,但這我有注意到,不過還是很謝謝你了,下午裝了起來,但進去phpmyadmin內檢視資料庫,有出現一個問題,如下:夢幻LUGIA 寫:這.......〈汗〉
CAPS LOCK就在鍵盤上阿@@
那就是大小寫鎖定阿=口=
//////////////////////////////////////
建立新資料表於資料庫 phpbb2 :
名稱 :
欄位 :
錯誤
關聯資料表的附加功能未能啟動, 請按此 查出問題原因.
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
按「請按此」後出現:
////////////////////////////////////////////////////////////
資料庫 phpbb2 在 localhost 執行
PMA Database ... 未能確定[ 說明文件 ]
一般關聯功能 未啟動
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
再按[ 說明文件 ]後,出現旳主要說明如下:
/////////////////////////////////////////////////////////////////////////////////////
$cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below.
See the Quick Install section in this document for a quick way of creating those tables. Also, if you are using a Windows server, read FAQ 1.23.
If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb'].
If you are setting up a multi-user phpMyAdmin installation, you will need to create a new database and setup special privileges, so, as superuser:
create a new database for phpMyAdmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the database name in $cfg['Servers'][$i]['pmadb']
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
請問大家,知道原因那裏嗎?
菜鳥一個,問題多多,請海涵,謝謝每一位了。\\r
afa

