Unable to open phpmyadmin

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

Unable to open phpmyadmin

Postby wingted » 26. March 2009 22:14

When I go to http://localhost/phpmyadmin, I get a "page Not Found" error. I had problems orginally installing XAMPP, but it seems to be running now. Any help would be appreciated.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby Izzy » 27. March 2009 00:08

Check your error.log file xampp\apache\logs\error.log

What version of XAMPP?
What version of Windows?
Both omitted.

What do you see if you go to http://localhost
Can you run the CD Collection demo?

Can you go to http://127.0.0.1/phpmyadmin

What problems did you have when you first installed XAMPP?

Always try and give as much info as possible please.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Unable to open phpmyadmin

Postby wingted » 27. March 2009 14:16

Thanks for your reply. Here is the information hopefully you need:

Running Win XP Pro SP 2
Xampp ver. 1.7.0

Here are the last two entries in the error log:
[Thu Mar 26 16:53:27 2009] [notice] Child 5976: Starting thread to listen on port 9443.
[Thu Mar 26 16:53:27 2009] [notice] Child 5976: Starting thread to listen on port 8888

http://localhost - Two seperate windows of Microsoft information, IIS , etc. So "localhost" does come up. Not sure what you mean by the CD collection demo.

http://localhost/phpmyadmin - Page not Found
http://127.0.0.1/phpmyadmin - Page not Found

Originally when I installed Xampp, MySql would run, but Apache would not. Uninstalled and installed several times. Then I checked the Forum and an article had me go into two files and change the port settings. Apparently port 80 and 88 were taken by IIS. After that change I was able to go to the Xampp Control Panel and click START on Apache and MySql and they both show as running, which I did not have before.

Hopefully this information will help. And thanks for your reply.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby Izzy » 27. March 2009 15:27

Perhaps now you know how to uninstall and reinstall it would be best to have a fresh start.
Make sure before uninstalling that all XAMPP components are stopped and any ticks in the Svc boxes in the XAMPP Control Panel (XCP) are removed, then close the XCP.
Finally remove completely your old xampp folder.

Instead of using the installer version of XAMPP this time, download the EXE (7zip) version.

Extract the files to the C:\ drive and they will be placed in C:\xampp in their correct places.

Next run C:\xampp\xampp_setup.bat to set the paths correctly.


Now before we do anything else you are best disabling IIS as it will only cause you hassles as you have found out.

To disable IIS go to your Windows Control Panel and select Add or Remove Programs.
Then in the left menu column select the icon Add/Remove Windows Components.
A window opens with lots of item with tick boxes next to them.
Look for Internet Information Services (IIS) and remove the tick in the box, then follow the prompts to remove it.
You may have to reboot here to get rid of everything that might be hanging about.


Now that is out of the way and your PC has restarted, go to your C:\xampp folder and run xampp-portcheck.exe and make sure all the ports are "free".

Then open your XCP C:\xampp\xampp-control.exe and start Apache and MySQL and make sure there are no ticks in the Svc boxes and please note, do not click on the Admin... button next to MySQL or you may have more issues to contend with.

After you have the green running indication for both Apache and MySQL it is time to go to http://localhost and select your language and arrive at the XAMPP Welcome Page.

From here you can check out the demos to make sure XAMPP is installed correctly.

You should also be able to go to phpMyAdmin from this page or go to http://localhost/phpmyadmin in your browser.

Let me know back if all that works or if there is anything you don't understand or can't follow.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Unable to open phpmyadmin

Postby wingted » 27. March 2009 16:22

Thanks Izzy. I will give it the ole college try in the next day or so and be sure to let you know how i make out.

Before I did the last install, I did completely remove the Xampp folder, which I had not done prior to previous installs. So maybe that made a difference.

Be back with you soon.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby wingted » 30. March 2009 01:19

Izzy,

Your directions worked well, except for a snag. Everything into place clear down to where I opened the Xampp Control Panel. You said to make sure there were no ticks in any of the SVC checkboxes. There was one in the MySQL box. I cannot remove it. When I click on it, it says "To uninstall MySql, click Yes". I tried clicking "Cancel" but the checkmark was still there. The second time I clicked "Yes", which may have uninstalled it. I did that but the checkmark did not go away. So I closed out the CP and started it again. With the checkmark still in place, I started Apache and MySql. Both show as running. So then I went to http://localhost. I got the Xampp window. Not sure where I choose English tho. I clicked on "phpmyadmin", and I got an error banner that said "Cannot load mysql extension. Please check your PHP configuration". So there, I am stuck.

Any ideas. At least I way farther than I have been before. Something tells me that lousy checkmark has something to do with my problem.

Thanks for your help.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby Izzy » 30. March 2009 01:50

Double click on xampp\mysql\mysql_uninstallservice.bat file.

Then go back to XCP and see if the tick has gone and then Start MySQL so it shows the green running indication.

On a new installation after removing the old xampp folder you should have been asked for your language when you went to http://localhost/

Let me know how it goes this time please.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Unable to open phpmyadmin

Postby wingted » 30. March 2009 03:18

Okay, clicked on xampp/mysql/...... file. It ran okay. Then I opened the XCP and the tick is gone. Bot services are running. Then went to localhost, where I get the German header, but an English navigation. Tried to open the phpmyadmin, and I get the same error as before.

Getting frustrating.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby wingted » 30. March 2009 03:21

More Info.

Here is the text of error message:

1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.


Hope this sheds some light.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby Izzy » 30. March 2009 03:32

Search your PC for php.ini files and delete or rename any that you find other than those in the xampp folder.

Restart Apache and try again.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Unable to open phpmyadmin

Postby wingted » 30. March 2009 11:25

Izzy,

You're a genius. Got it. When I first opened up localhost, it did ask me for my choice of language. Now I am able to open phpmyadmin.

Thanks a million for your help.

Ted
wingted
 
Posts: 16
Joined: 26. March 2009 20:30

Re: Unable to open phpmyadmin

Postby Izzy » 30. March 2009 11:30

You're welcome Ted and thanks for posting back that you now have it all working.

Good luck and now you can enjoy your XAMPP experience.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Unable to open phpmyadmin

Postby twocs » 30. March 2009 16:39

I just installed XAMPP and had the exact same problem, trying to get into phpadmin. The problem was that I had already installed PHP on my computer, so XAMPP automatically used the file C:/Program Files/PHP/php.ini instead of the C:/XAMPP.

Apparently, running phpadmin for the first time requires extension=php_msql.dll, so that line must not be commented out in the php.ini that is being used. If you have this trouble, go to localhost/xampp/phpinfo.php to check which Loaded Configuration File is being used. As mentioned above, the alternate versions could be deleted from your computer. I suppose this is a result of XAMPP checking first in the C:/program files/PHP for the php.ini, before checking in the XAMPP folder itself.
twocs
 
Posts: 1
Joined: 30. March 2009 16:17


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 77 guests