installing phpMyAdmin on Server 2008 with IIS7

Reece
Reece used Ask the Experts™
on
I cannot get phpMyAdmin to work on my web server.
I have Server 2008 with IIS7, MySQL and PHP all working fine.
I have a few existing WordPress sites that are working fine, but I'm looking to add a few more and setup some database backup and maintenance procedures.

I've added a new site called phpMyAdmin, added the application pool.
Pointed it to the phpMyAdmin folder in inetpub and configured the config.inc.php file.

If I try to access http://localhost I get the following message:
phpMyAdmin - Error
The mysql extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>


if I try to access http://localhost/phpinfo.php, the page is blank, but if I load phpinfo.php on one of the active websites, it loads and tells me all is well.

What have I missed or got wrong?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ReeceICT Consultant
Commented:
just noticed that the phpinfo.php file in phpMyAdmin is coded with
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpinfo() wrapper to allow displaying only when configured to do so.
 * @package PhpMyAdmin
 */

/**
 * Gets core libraries and defines some variables
 */
require_once './libraries/common.inc.php';


/**
 * Displays PHP information
 */
if ($GLOBALS['cfg']['ShowPhpInfo']) {
    phpinfo();
}
?>

Open in new window

So, I've changed it to
<?php

phpinfo();

?>

Open in new window

and now it shows the info...

Can this help me?

Commented:
I think you need to add the necessary php extensions for mysql. Reinstall PHP, and when going through the install you'll see the "Choose Items to install" on that screen is an extensions drop down. Go through there and install the sql extensions you need. I don't believe these are installed by default.
ICT Consultant
Commented:
The new site was using an old php install.   I've changed it to the php install that the existing sites use and everything works ok.  I've removed the old php install so this doesn't happen again.
ReeceICT Consultant

Author

Commented:
self resolved

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial