phpmyadmin error "Cannot load mysql extension"

[marknewbery@gmail.com]

Hi,
I have been trying to get a php, mySQL install to work and talk
together on Windows XP SP2 with IIS. So far I installed and received a
responce from php(V5 - manual install) though the

<?php phpinfo(); ?>

command which prints out the current settings of the php install.

I then installed mySQL complete setup (V5) and ran the server instance
config wizard. The, through the command line, set up a databse tables
that i required. In windows services mySQL is running however when
trying to use phpmyadmin i get the error "Cannot load mysql extension".

I have enabled the php_mysql.dll in the php.ini file and also, as
suggested in other posts, copied the libmysql.dll and php_mysql.dll to
both the system and system32 folders.

is this an issue with IIS and php 5 and mySQL 5 and should i uninstall
php 5 and use version 4 instead?

any help would be greatly appreciated.

Mark

[Erwin Moller]

Re: phpmyadmin error &quot;Cannot load mysql extension&quot;

marknewbery@gma il.com wrote:
[color=blue]
> Hi,
> I have been trying to get a php, mySQL install to work and talk
> together on Windows XP SP2 with IIS. So far I installed and received a
> responce from php(V5 - manual install) though the
>
> <?php phpinfo(); ?>
>
> command which prints out the current settings of the php install.
>
> I then installed mySQL complete setup (V5) and ran the server instance
> config wizard. The, through the command line, set up a databse tables
> that i required. In windows services mySQL is running however when
> trying to use phpmyadmin i get the error "Cannot load mysql extension".
>
> I have enabled the php_mysql.dll in the php.ini file and also, as
> suggested in other posts, copied the libmysql.dll and php_mysql.dll to
> both the system and system32 folders.
>
> is this an issue with IIS and php 5 and mySQL 5 and should i uninstall
> php 5 and use version 4 instead?[/color]

No, php5 and mysql are friends.

You must have made a mistake elsewhere.

A few 'popular' mistakes:
1) Have a few php.ini's around and edit the wrong one.
Check: phpinfo() tells you which path it is using to load php.ini

2) Is mysql working allright?
Check: Can you connect to it from commandline.

3) Do NOT store your dll's everywhere.
Understand where they should be.
(Check in php.ini for extensiondir)

Regards,
Erwin Moller
[color=blue]
>
> any help would be greatly appreciated.
>
> Mark[/color]