救救我 不能進入phpMyAdmin畫面

phpMyAdmin Running Discuss
關於 phpMyAdmin 架設使用操作討論,非本程式相關問題一律砍文!

版主: 版主管理群

回覆文章
kaifung
星球普通子民
星球普通子民
文章: 3
註冊時間: 2007-03-11 03:59

救救我 不能進入phpMyAdmin畫面

文章 kaifung »

phpMyAdmin 那一頁 一直不能進入,
按了 load大約幾分之後就變了白畫面 :-|
重新開機再試一次出了#2003 - 伺服器並無回應
chiouss
竹貓忠實會員
竹貓忠實會員
文章: 1741
註冊時間: 2002-11-29 18:19

文章 chiouss »

你把 Apache 和 MySQL 都 stop & start 一次,Apache 不要直接用 restart。然後,碰到這種情形記得要先看你的 access.log 和 error.log
kaifung
星球普通子民
星球普通子民
文章: 3
註冊時間: 2007-03-11 03:59

文章 kaifung »

chiouss 寫:你把 Apache 和 MySQL 都 stop & start 一次,Apache 不要直接用 restart。然後,碰到這種情形記得要先看你的 access.log 和 error.log
STOP & STAR一次之後情況一樣
[Sun Mar 11 12:03:19 2007] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sun Mar 11 12:03:19 2007] [notice] Child 2496: Exit event signaled. Child process is ending.
[Sun Mar 11 12:03:20 2007] [notice] Child 2496: Released the start mutex
[Sun Mar 11 12:03:21 2007] [notice] Child 2496: Waiting for 250 worker threads to exit.
[Sun Mar 11 12:03:21 2007] [notice] Child 2496: All worker threads have exited.
[Sun Mar 11 12:03:21 2007] [notice] Child 2496: Child process is exiting
[Sun Mar 11 12:03:21 2007] [notice] Parent: Child process exited successfully.
[Sun Mar 11 12:03:40 2007] [notice] Apache/2.0.59 (Win32) PHP/4.4.5 configured -- resuming normal operations
[Sun Mar 11 12:03:40 2007] [notice] Server built: Jul 27 2006 15:55:03
[Sun Mar 11 12:03:40 2007] [notice] Parent: Created child process 4568
[Sun Mar 11 12:03:40 2007] [notice] Child 4568: Child process is running
[Sun Mar 11 12:03:40 2007] [notice] Child 4568: Acquired the start mutex.
[Sun Mar 11 12:03:40 2007] [notice] Child 4568: Starting 250 worker threads.
[Sun Mar 11 12:03:41 2007] [error] [client 66.249.65.131] script 'C:/AppServ/www/faq.php' not found or unable to stat
[Sun Mar 11 12:04:57 2007] [error] [client 66.249.65.131] script 'C:/AppServ/www/memcp.php' not found or unable to stat
[Sun Mar 11 12:05:03 2007] [error] [client 66.249.65.131] File does not exist: C:/AppServ/www/kaifungz.no-ip.org
[Sun Mar 11 12:05:24 2007] [error] [client 66.249.65.131] File does not exist: C:/AppServ/www/kaifungz.no-ip.org
[Sun Mar 11 12:06:16 2007] [error] [client 66.249.65.131] script 'C:/AppServ/www/register.php' not found or unable to stat
[Sun Mar 11 12:07:26 2007] [error] [client 66.249.65.131] File does not exist: C:/AppServ/www/kaifungz.no-ip.org
[Sun Mar 11 12:07:37 2007] [error] [client 66.249.65.131] script 'C:/AppServ/www/stats.php' not found or unable to stat
[Sun Mar 11 12:07:47 2007] [error] [client 66.249.65.131] File does not exist: C:/AppServ/www/kaifungz.no-ip.org
[Sun Mar 11 12:08:27 2007] [error] [client 66.249.65.131] script 'C:/AppServ/www/stats.php' not found or unable to stat
原來有很多錯誤=.=
66.249.65.131 - - [11/Mar/2007:12:05:24 +0800] "GET /kaifungz.no-ip.org?sid=LJsy6n HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:06:16 +0800] "GET /register.php?sid=c4VuYN HTTP/1.1" 404 303
66.249.65.131 - - [11/Mar/2007:12:07:26 +0800] "GET /kaifungz.no-ip.org?sid=Js0XL5 HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:07:37 +0800] "GET /stats.php?sid=LWOMHw HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:07:47 +0800] "GET /kaifungz.no-ip.org?sid=rblNoP HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:08:27 +0800] "GET /stats.php?type=creditsrank&sid=ELvOn2 HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:09:06 +0800] "GET /faq.php?sid=fLO3dn HTTP/1.1" 404 298
66.249.65.131 - - [11/Mar/2007:12:09:24 +0800] "GET /register.php?sid=eqlcbE HTTP/1.1" 404 303
66.249.65.131 - - [11/Mar/2007:12:09:56 +0800] "GET /kaifungz.no-ip.org?sid=yV6fkK HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:10:30 +0800] "GET /kaifungz.no-ip.org?sid=4YrSQQ HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:10:32 +0800] "GET /index.php?sid=UUWbRP HTTP/1.1" 200 3439
66.249.65.131 - - [11/Mar/2007:12:11:58 +0800] "GET /memcp.php?action=buddylist&sid=zrpvF4 HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:12:32 +0800] "GET /register.php?sid=bkI3eG HTTP/1.1" 404 303
66.249.65.131 - - [11/Mar/2007:12:13:10 +0800] "GET /kaifungz.no-ip.org?sid=KY3mRN HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:13:13 +0800] "GET /kaifungz.no-ip.org?sid=O5U6Zw HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:13:20 +0800] "GET /faq.php?page=using&sid=ub5mky HTTP/1.1" 404 298
66.249.65.131 - - [11/Mar/2007:12:13:25 +0800] "GET /memcp.php?sid=RKUjl0 HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:14:37 +0800] "GET /faq.php?sid=EKEszz HTTP/1.1" 404 298
66.249.65.131 - - [11/Mar/2007:12:15:28 +0800] "GET /memcp.php?action=buddylist&sid=pyRFpo HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:15:39 +0800] "GET /register.php?sid=pu0hCI HTTP/1.1" 404 303
66.249.65.131 - - [11/Mar/2007:12:16:21 +0800] "GET /kaifungz.no-ip.org?sid=f5zV9w HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:16:23 +0800] "GET /stats.php?sid=PqFow7 HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:16:24 +0800] "GET /kaifungz.no-ip.org?sid=lKFLyX HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:16:31 +0800] "GET /faq.php?sid=48S3Jl HTTP/1.1" 404 298
66.249.65.131 - - [11/Mar/2007:12:18:38 +0800] "GET /kaifungz.no-ip.org?sid=MjKLaP HTTP/1.1" 404 309
66.249.65.131 - - [11/Mar/2007:12:18:59 +0800] "GET /stats.php?type=creditsrank&sid=QmEN0G HTTP/1.1" 404 300
66.249.65.131 - - [11/Mar/2007:12:19:02 +0800] "GET /faq.php?sid=0EdNmF HTTP/1.1" 404 298
66.249.65.131 - - [11/Mar/2007:12:19:14 +0800] "GET /memcp.php?sid=jboJWK HTTP/1.1" 404 300
問題應該在stat.php 那些我沒有的php=.= 這是什麼來的 要在那找回來
kaifung
星球普通子民
星球普通子民
文章: 3
註冊時間: 2007-03-11 03:59

文章 kaifung »

重新安裝別的版本後 登入後出現#1130 的錯誤
Host 'my.router' is not allowed to connect to this MySQL server
即是router 的問題? 應該開放那一個post的連接呢?
不用router之後 都係#1130=.=
error.log
[Mon Mar 12 17:30:20 2007] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Mar 12 17:30:20 2007] [notice] Child 2852: Exit event signaled. Child process is ending.
[Mon Mar 12 17:30:21 2007] [notice] Child 2852: Released the start mutex
[Mon Mar 12 17:30:22 2007] [notice] Child 2852: Waiting for 64 worker threads to exit.
[Mon Mar 12 17:30:22 2007] [notice] Child 2852: All worker threads have exited.
[Mon Mar 12 17:30:22 2007] [notice] Child 2852: Child process is exiting
[Mon Mar 12 17:30:22 2007] [notice] Parent: Child process exited successfully.
[Mon Mar 12 17:30:29 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
[Mon Mar 12 17:30:29 2007] [notice] Server built: Jan 9 2007 23:17:20
[Mon Mar 12 17:30:29 2007] [notice] Parent: Created child process 968
[Mon Mar 12 17:30:30 2007] [notice] Child 968: Child process is running
[Mon Mar 12 17:30:30 2007] [notice] Child 968: Acquired the start mutex.
[Mon Mar 12 17:30:30 2007] [notice] Child 968: Starting 64 worker threads.
[Mon Mar 12 17:30:30 2007] [notice] Child 968: Starting thread to listen on port 80.
[Mon Mar 12 17:30:45 2007] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Mar 12 17:30:45 2007] [notice] Child 968: Exit event signaled. Child process is ending.
[Mon Mar 12 17:30:46 2007] [notice] Child 968: Released the start mutex
[Mon Mar 12 17:30:47 2007] [notice] Child 968: Waiting for 64 worker threads to exit.
[Mon Mar 12 17:30:47 2007] [notice] Child 968: All worker threads have exited.
[Mon Mar 12 17:30:47 2007] [notice] Child 968: Child process is exiting
[Mon Mar 12 17:30:47 2007] [notice] Parent: Child process exited successfully.
[Mon Mar 12 17:30:56 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
[Mon Mar 12 17:30:56 2007] [notice] Server built: Jan 9 2007 23:17:20
[Mon Mar 12 17:30:56 2007] [notice] Parent: Created child process 4008
[Mon Mar 12 17:30:56 2007] [notice] Child 4008: Child process is running
[Mon Mar 12 17:30:56 2007] [notice] Child 4008: Acquired the start mutex.
[Mon Mar 12 17:30:56 2007] [notice] Child 4008: Starting 64 worker threads.
[Mon Mar 12 17:30:56 2007] [notice] Child 4008: Starting thread to listen on port 80.
[Mon Mar 12 17:37:55 2007] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Mar 12 17:37:55 2007] [notice] Child 4008: Exit event signaled. Child process is ending.
[Mon Mar 12 17:37:56 2007] [notice] Child 4008: Released the start mutex
[Mon Mar 12 17:37:57 2007] [notice] Child 4008: Waiting for 64 worker threads to exit.
[Mon Mar 12 17:37:57 2007] [notice] Child 4008: All worker threads have exited.
[Mon Mar 12 17:37:57 2007] [notice] Child 4008: Child process is exiting
[Mon Mar 12 17:37:58 2007] [notice] Parent: Child process exited successfully.

access.org

127.0.0.1 - kaifung [12/Mar/2007:17:28:18 +0800] "GET /phpMyAdmin/ HTTP/1.1" 302 -
127.0.0.1 - kaifung [12/Mar/2007:17:28:40 +0800] "GET /phpMyAdmin/error.php?error=%232003+-+%E4%BC%BA%E6%9C%8D%E5%99%A8%E4%B8%A6%E7%84%A1%E5%9B%9E%E6%87%89 HTTP/1.1" 200 1092
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET / HTTP/1.1" 200 3448
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET /appserv/members.gif HTTP/1.1" 304 -
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET /appserv/annoicon.gif HTTP/1.1" 304 -
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET /appserv/flag-thai.png HTTP/1.1" 304 -
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET /appserv/flag-english.png HTTP/1.1" 304 -
127.0.0.1 - - [12/Mar/2007:17:31:46 +0800] "GET /appserv/softicon.gif HTTP/1.1" 304 -
127.0.0.1 - - [12/Mar/2007:17:31:47 +0800] "GET /phpMyAdmin/ HTTP/1.1" 401 1093
127.0.0.1 - kaifung [12/Mar/2007:17:31:51 +0800] "GET /phpMyAdmin/ HTTP/1.1" 302 -
127.0.0.1 - kaifung [12/Mar/2007:17:32:12 +0800] "GET /phpMyAdmin/error.php?error=%232003+-+%E4%BC%BA%E6%9C%8D%E5%99%A8%E4%B8%A6%E7%84%A1%E5%9B%9E%E6%87%89 HTTP/1.1" 200 1092
127.0.0.1 - kaifung [12/Mar/2007:17:33:47 +0800] "GET /phpMyAdmin/ HTTP/1.1" 302 -
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET / HTTP/1.1" 200 3448
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET /appserv/annoicon.gif HTTP/1.1" 200 1182
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET /appserv/members.gif HTTP/1.1" 200 755
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET /appserv/flag-thai.png HTTP/1.1" 200 545
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET /appserv/softicon.gif HTTP/1.1" 200 474
61.93.6.2 - - [12/Mar/2007:17:35:02 +0800] "GET /appserv/flag-english.png HTTP/1.1" 200 576
61.93.6.2 - - [12/Mar/2007:17:35:05 +0800] "GET /phpMyAdmin/ HTTP/1.1" 401 1093
61.93.6.2 - kaifung [12/Mar/2007:17:35:08 +0800] "GET /phpMyAdmin/ HTTP/1.1" 302 -
61.93.6.2 - kaifung [12/Mar/2007:17:35:11 +0800] "GET /phpMyAdmin/error.php?error=%232003+-+%E4%BC%BA%E6%9C%8D%E5%99%A8%E4%B8%A6%E7%84%A1%E5%9B%9E%E6%87%89 HTTP/1.1" 200 1092
chiouss
竹貓忠實會員
竹貓忠實會員
文章: 1741
註冊時間: 2002-11-29 18:19

文章 chiouss »

mysql 預設的 root 權限只限 localhost 登入,所以你的 phpMyAdmin 裡面 MySQL server host 請射程 localhost 而不要設定成 domain name,不然就請先改過 root 的權限
chienli23
星球普通子民
星球普通子民
文章: 1
註冊時間: 2012-01-05 09:02

Re: 救救我 不能進入phpMyAdmin畫面

文章 chienli23 »

有沒有可能跟hosts的設定有關?

我是安裝appserv 2.60與PHP和mySQL

安裝完成後用瀏覽器開啟localhost/phpmyadmin,卻什麼畫面與錯誤訊息都沒有,

之後上網爬文,一位分享者教學,將c:/windows/system32/etc/hosts檔案,以管理者身份開啟的記事本程式開啟此檔案,

並將底下說明註解內容 - 127.0.0.1 localhost 前的"#"拿掉,

# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
# ::1 localhost

儲存檔案,再重新開啟瀏覽器後,輸入localhost/phpmyadmin,

即會出現登入畫面,並可進入了

提供參考
回覆文章

回到「phpMyAdmin」