Can't access to phpMyAdmin (Win XP SP2) - [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Can't access to phpMyAdmin (Win XP SP2) - [SOLVED]

Postby JasperH » 09. October 2011 08:42

Hi all,

I'm new in website setup, a week ago I followed a guide-book to setup a wordpress page through XAMPP. At that moment, I could not access Apache properly as I had not freed Port 80. After several trials in uninstalling and re-installing the latest Apache and XAMPP, though the Apache runs normally, I just can't access http://localhost/phpmyadmin/.

Every time when I try to access it, it just returns

Not Found

The requested URL /phpmyadmin/ was not found on this server.


Would anyone tell me what I shall do to solve it? I have searched through internet for two days but get no idea in what's going on.

Many thanks!
Last edited by JasperH on 09. October 2011 12:16, edited 1 time in total.
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin

Postby Sharley » 09. October 2011 08:53

We require your XAMPP version and your Windows Version to provide the correct version support - please read:
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Thanks.

JasperH wrote: I just can't access http://localhost/phpmyadmin/
Try http://localhost/xampp/phpmyadmin the correct address. :shock:

Read the readme_en.txt file in the xampp folder.

Go to http://localhost and select your language and then exercise all the demos to make sure your installation is good.

You can also find the phpMyAdmin menu item in the left frame of the Welcome page, plus much more.


Have you tried using the new version 3 control panel, if you are not already using it, instead of the older default version 2.5* as it has more features with a more informative log window:
C:\xampp\xampp-control-3-beta.exe
You can, if you wish, create a shortcut on your desktop for easy access.

It is reported that in the next XAMPP release the CP3 will be the default control panel.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't access to phpMyAdmin

Postby JasperH » 09. October 2011 09:48

Thanks, Sharley.

I am currently using Window XP SP2 and XAMPP ver. 1.7.7 (ZIP archive).

I could access phpMyAdmin last week, I had created a database and added a new user for its authority. However after uninstalling and reinstalling XAMPP, I couldn't access it again. I have just tried the correct address (http://localhost/xampp/phpmyadmin), the same error appears.

When browsing http://localhost, it showed me "It Works!".

I have tried xampp-control-3-beta.exe and there is a button of error.log for MySQL. Would pasting the content here help?
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin

Postby Sharley » 09. October 2011 09:51

JasperH wrote:I have tried xampp-control-3-beta.exe and there is a button of error.log for MySQL. Would pasting the content here help?
Yes please.

Also the last part of C:\xampp\apache\logs\error.log file.

IT Works means no PHP is being parsed or Apache is not running and this topic resembles your issue:
viewtopic.php?f=16&t=48539

This post will help you to understand how to uninstall and then install XAMPP again:
viewtopic.php?p=179699#p179699
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't access to phpMyAdmin

Postby JasperH » 09. October 2011 10:04

Many thanks, Sharley!!

Here is the error.log file:
******************************************
Code: Select all
111009 16:38:41 [Note] Plugin 'FEDERATED' is disabled.
111009 16:38:41 InnoDB: The InnoDB memory heap is disabled
111009 16:38:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111009 16:38:41 InnoDB: Compressed tables use zlib 1.2.3
111009 16:38:41 InnoDB: Initializing buffer pool, size = 16.0M
111009 16:38:41 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file D:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
111009 16:38:41  InnoDB: Setting file D:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111009 16:38:41  InnoDB: Log file D:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
111009 16:38:41  InnoDB: Log file D:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111009 16:38:43  InnoDB: Waiting for the background threads to start
111009 16:38:44 InnoDB: 1.1.8 started; log sequence number 0
111009 16:38:44 [Note] Event Scheduler: Loaded 0 events
111009 16:38:44 [Note] D:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)

******************************************End of error.log file******************************************
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin

Postby Sharley » 09. October 2011 10:07

Nothing stands out there, what about the rest of my last post?

Please paste in forum code tags the CP3 log window or the xampp-control-3-beta.log file in the xampp folder.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't access to phpMyAdmin

Postby JasperH » 09. October 2011 10:40

I have checked D:\xampp\apache\logs, it is empty.

Below is the xampp-control-3-beta.log file:

Code: Select all
16:36:21  [main]    Initializing main
16:36:21  [main]    Windows version: 5.1 (build 2600) - Service Pack 2
16:36:21  [main]    Xampp version: 1.7.7
16:36:21  [main]    Control center version: 3.0.2 [ Compiled: Jul 21th 2011 - build #1 ]
16:36:21  [main]    Running as admin - good!
16:36:21  [main]    Working with basedir: "d:\xampp\"
16:36:21  [main]    Initializing moduls
16:36:21  [apache]    Possible problem detected: Port 80 in use by "httpd.exe"!
16:36:21  [main]    Starting check-timer
16:36:24  [mysql]    Starting mysql service...
16:36:44  [mysql]    Starting mysql service...
16:37:14  [main]    Deinitializing moduls
16:37:14  [main]    Deinitializing main

16:37:20  [main]    Initializing main
16:37:20  [main]    Windows version: 5.1 (build 2600) - Service Pack 2
16:37:20  [main]    Xampp version: 1.7.7
16:37:20  [main]    Control center version: 3.0.2 [ Compiled: Jul 21th 2011 - build #1 ]
16:37:20  [main]    Running as admin - good!
16:37:20  [main]    Working with basedir: "d:\xampp\"
16:37:20  [main]    Initializing moduls
16:37:20  [apache]    Possible problem detected: Port 80 in use by "d:\xampp\xampp-control-3-beta.exe"!
16:37:20  [main]    Starting check-timer
16:37:35  [mysql]    Starting mysql service...
16:38:22  [apache]    Stopping apache service...
16:38:25  [apache]    Stopping apache service...
16:38:31  [main]    Deinitializing moduls
16:38:31  [main]    Deinitializing main



Thanks again!
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin

Postby Sharley » 09. October 2011 10:45

No error log file means Apache has never started.

Does Apache show in a green background under Module?
Code: Select all
16:37:20  [apache]    Possible problem detected: Port 80 in use by "d:\xampp\xampp-control-3-beta.exe"!
This is strange as CP3 does not use port 80, something is very wrong here. :shock:

Click on the Netstat button see what is using port 80 and port 443 and let me know back.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't access to phpMyAdmin

Postby JasperH » 09. October 2011 10:56

The apache is shown with a green background.

For Port 80: httpd.exe. But I can't find Port 443 within the Netstat.
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin

Postby Sharley » 09. October 2011 11:05

Apache should be listening on both 80 and 443 in a normal installation - strange issue.

It may be possible that your XAMPP installation is corrupt or you still have some issues left behind when you installed and uninstalled a few times.

My advise is to follow my instruction I posted above to correctly uninstall and then download the zip or 7zip archive version mentioned in the instruction here.
viewtopic.php?p=186415#p186415

A clean fresh start may be the solution here as there are issues that are somewhat strange.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Can't access to phpMyAdmin

Postby JasperH » 09. October 2011 12:15

Hi~

The problem has been solved~

After following your instruction, I re-installed XAMPP and opened CP3. Initially, the condition was the same as what I posted earlier. Then I was puzzled about the "tick" in the Svc box next to apache. As your instruction stated clearly that "Make sure there are no ticks in any of the Svc check boxes.", I tried to click it and choose to uninstall the service. Then everything works well! :D

After recalling the steps done last week, I thought it might be caused by my action of updating apache (the guidebook suggested to install the latest apache version after installing xampp), which caused the service automatically "started" before I executed xampp. That's what I guessed... :roll:

Many thanks!!!
JasperH
 
Posts: 6
Joined: 09. October 2011 08:28

Re: Can't access to phpMyAdmin {SOLVED}

Postby Sharley » 09. October 2011 12:22

Your welcome and thanks for the feed back. 8)

Now you can move forward and enjoy what XAMPP has to offer.

Good luck and best wishes. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests