[問題] phpMyAdmin始終無法使用..:(
版主: 版主管理群
[討論] 我也是遇到這樣的問題，不過有另外的解法!!
phpMyadmin的說明原文提到(中文)：
[4.4] phpMyAdmin always gives "Access denied" when using HTTP authentication.
(phpMyAdmini在HTTP驗證模式下一直出現權限錯誤)
This could happen for several reasons:
(可能有以下原因)
$cfg['Servers'][$i]['controluser'] and/or $cfg['Servers'][$i]['controlpass'] are wrong.
($cfg['Servers'][$i]['controluser']和$cfg['Servers'][$i]['controlpass'] 設定錯誤)
The username/password you specify in the login-dialog are invalid.
(帳號密碼輸入錯誤)
You have already setup a security mechanism for the phpMyAdmin-directory, eg. a .htaccess file. This would interfere with phpMyAdmin's authentication, so remove it.
(你可能將phpMyAdmin的目錄設定其他權限,例如.htaccess檔案,這樣會影響到phpMyadmin的認證,所以請移除)
後來我發現我的設定都是正確的，但是在IIS的資料夾的權限設定是錯的，我想也許apache也是一樣，請參考看看
[4.4] phpMyAdmin always gives "Access denied" when using HTTP authentication.
(phpMyAdmini在HTTP驗證模式下一直出現權限錯誤)
This could happen for several reasons:
(可能有以下原因)
$cfg['Servers'][$i]['controluser'] and/or $cfg['Servers'][$i]['controlpass'] are wrong.
($cfg['Servers'][$i]['controluser']和$cfg['Servers'][$i]['controlpass'] 設定錯誤)
The username/password you specify in the login-dialog are invalid.
(帳號密碼輸入錯誤)
You have already setup a security mechanism for the phpMyAdmin-directory, eg. a .htaccess file. This would interfere with phpMyAdmin's authentication, so remove it.
(你可能將phpMyAdmin的目錄設定其他權限,例如.htaccess檔案,這樣會影響到phpMyadmin的認證,所以請移除)
後來我發現我的設定都是正確的，但是在IIS的資料夾的權限設定是錯的，我想也許apache也是一樣，請參考看看
2.4.3安裝的時候只問你伺服器位置跟信箱
沒有問你mysql的帳號密碼,之後就直接安裝了
安裝完畢之後要連到phpMyadmin時,就出錯了....
另外問一下可不要移除2.4.0直接安裝2.4.1覆蓋嗎?
沒有問你mysql的帳號密碼,之後就直接安裝了
安裝完畢之後要連到phpMyadmin時,就出錯了....
另外問一下可不要移除2.4.0直接安裝2.4.1覆蓋嗎?
●架設主機作業系統：Windows xp
●快速架站程式：Appserv v2.4.0
●免費空間連結：架在本電腦上
●我的上網方式：ADSL 浮動 IP
●我安裝的程式：Apache + php + MySql
●我的 phpBB2 版本：phpBB 2.0.14
●我的 phpBB2 連結網址： http://roup.dynalias.com/phpbb2/index.php
●我安裝過的外掛：文字氣泡,EasyMOD,金錢MOD
●我使用的風格：whatisreal
●快速架站程式：Appserv v2.4.0
●免費空間連結：架在本電腦上
●我的上網方式：ADSL 浮動 IP
●我安裝的程式：Apache + php + MySql
●我的 phpBB2 版本：phpBB 2.0.14
●我的 phpBB2 連結網址： http://roup.dynalias.com/phpbb2/index.php
●我安裝過的外掛：文字氣泡,EasyMOD,金錢MOD
●我使用的風格：whatisreal
[建議] Linux Fedora 3 MySQL 無法連結
發生下列的 Error 訊息.
#2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
我在網路上找到一篇討論. 需要修改 SELinux 的設定。
我更改後 phpMyAdmin 就可以連結 mysql 。
但安全性降低的作法似乎不是很好，最終解決方案我看不懂，有那位高手看過後再跟大家說明一下吧.
Source :
http://forums.devshed.com/t14130/s.html
------------------------------------
I have been having the same problem and I have found the solution -- at least for me. The problem for me is that I had just installed Fedora Core 3. Starting with Fedora Core 3, SELinux is turned on by default. SELinux is the Secure Edition that has extra security features. I turned SELinux off and I stopped getting the error. I will do some more research and see if I can just turn off parts of SELinux to get MySQL to work with PHP and Apache.
-------------------------------------
this is the procedure I've followed to configure SELinux :
Now things work (without the reboot mentioned in the previous contribution).
Hope this narrows things down.
Also, see next post for the *REAL* fix.
------------------------------------------------------------------------
The *REAL* fix
This problem was hashed out in a fairly readable way in the RedHat fedora-selinux-list forum. The initial post is now at
https://www.redhat.com/archives/fedora- ... 00013.html
You'll want to read most of the followups.
The preferred solution involves creating an selinux domain, "mysqld_t," that has permission to read and write a particular socket. Manipulating selinux sounds hairy, but the instructions are fairly straightforward. The correct solution is the first one suggested in
https://www.redhat.com/archives/fedora- ... 00015.html
NB: the line that reads:
* service mysql restart
should read:
* service mysqld restart
good luck!
#2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
我在網路上找到一篇討論. 需要修改 SELinux 的設定。
我更改後 phpMyAdmin 就可以連結 mysql 。
但安全性降低的作法似乎不是很好，最終解決方案我看不懂，有那位高手看過後再跟大家說明一下吧.
Source :
http://forums.devshed.com/t14130/s.html
------------------------------------
I have been having the same problem and I have found the solution -- at least for me. The problem for me is that I had just installed Fedora Core 3. Starting with Fedora Core 3, SELinux is turned on by default. SELinux is the Secure Edition that has extra security features. I turned SELinux off and I stopped getting the error. I will do some more research and see if I can just turn off parts of SELinux to get MySQL to work with PHP and Apache.
-------------------------------------
this is the procedure I've followed to configure SELinux :
代碼: 選擇全部
From Startmenu select
"System settings"
Then choose
\n"Security settings or security level"
A window appears with 2 tabs : "Firewall options" and "SELinux"
Choose SELinux.
At the bottom half of the window you have a lisbox, listing (at least on my PC)
HTTPD Service
Name Service
NIS
SELinux Service Protection
Open SELinux Service Protection
Select "Disable SELinux protection for mysqld daemon"
Click "OK"
Open HTTPD Service
Select "Disable SELinux protection for httpd daemon"
Click "OK"
-----------------------------------------
In my Fedora Core 3 (in which I have already run "fixfiles reset"), I was able to get a PHP call to mysql_connect() working by just disabling the SELinux protection of the httpd daemon (as described in the previous submission to this thread). I left the protection of the mysql daemon running. Then:
# /etc/init.d/httpd restart
# /etc/init.d/mysqld restart (for good measure, probably not necessary)
Hope this narrows things down.
Also, see next post for the *REAL* fix.
------------------------------------------------------------------------
The *REAL* fix
This problem was hashed out in a fairly readable way in the RedHat fedora-selinux-list forum. The initial post is now at
https://www.redhat.com/archives/fedora- ... 00013.html
You'll want to read most of the followups.
The preferred solution involves creating an selinux domain, "mysqld_t," that has permission to read and write a particular socket. Manipulating selinux sounds hairy, but the instructions are fairly straightforward. The correct solution is the first one suggested in
https://www.redhat.com/archives/fedora- ... 00015.html
NB: the line that reads:
* service mysql restart
should read:
* service mysqld restart
good luck!
最後由 novajiang 於 2005-04-20 09:17 編輯，總共編輯了 1 次。
-
hollowaysxp
- 竹貓忠實會員
- 文章: 535
- 註冊時間: 2004-06-01 22:39
- 來自: 仙境傳說回憶最美~台灣桃園
- 聯繫:
Re: [問題] 我的也是
FC3內建的Mysql不太可能，因為FC3的Mysql是3.x版。alexday 寫:Dear all
os:linux fredoa 3(可能打錯 請包含)
沒想到 也是有人和我有相同問題.
太 了~了,但我看了一下~ 也是沒有答案 說怎麼解
請大大給我解決方法~~
3q
除非你自己裝4.1.x
●架設主機作業系統：FreeBSD 6.2-RELEASE (自行架設)
●我的上網方式：FTTB+VDSL HINET 10M/2M
●我安裝的程式：Apache 2.0.59+ PHP Version 4.4.4 + MySql 4.1.21+phpMyadmin 2.9.1.1
●我的 phpBB3 版本：phpBB3.0.1
●我的 phpBB3 連結網址 http://nitcs.itrello.com/forum/
NITCS歡迎你
NITCS論壇
●我的上網方式：FTTB+VDSL HINET 10M/2M
●我安裝的程式：Apache 2.0.59+ PHP Version 4.4.4 + MySql 4.1.21+phpMyadmin 2.9.1.1
●我的 phpBB3 版本：phpBB3.0.1
●我的 phpBB3 連結網址 http://nitcs.itrello.com/forum/
NITCS歡迎你
NITCS論壇
Re: [建議] Linux Fedora 3 MySQL 無法連結
[quote="novajiang"]發生下列的 Error 訊息.
#2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
我在網路上找到一篇討論. 需要修改 SELinux 的設定。
我更改後 phpMyAdmin 就可以連結 mysql 。
但安全性降低的作法似乎不是很好，最終解決方案我看不懂，有那位高手看過後再跟大家說明一下吧.
Source :
http://forums.devshed.com/t14130/s.html
在linux下試試執行以下指令\r
setsebool -P mysqld_disable-trans=1
上面的說明是圖形介面的作法
#2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
我在網路上找到一篇討論. 需要修改 SELinux 的設定。
我更改後 phpMyAdmin 就可以連結 mysql 。
但安全性降低的作法似乎不是很好，最終解決方案我看不懂，有那位高手看過後再跟大家說明一下吧.
Source :
http://forums.devshed.com/t14130/s.html
在linux下試試執行以下指令\r
setsebool -P mysqld_disable-trans=1
上面的說明是圖形介面的作法