cannot load MySQL extension, please check PHP Configuration
 

i just finished upgrading my php to php5 because i wanted to see the changes, but now my code doesnt do anything at all. like the one to connect to a database. it just gives me a blank white screen so when i went to check phpmyadmin to see if it was even submitting anything i got this error.'


"cannot load MySQL extension, please check PHP Configuration"

im pretty sure that i have installed PHP right. Does php my admin just not work with it, or is there somthing i need to do with mySQL to get it to work with php5. Thanks in advanced for any help that anyone has to offer.

Re: php5 and phpmyadmin??
 

To add to that, heres what happend after i followed the directions to the FRIGGIN T!!!!

i even add the line extension=php_mysql.dll the php.ini file. and when i start i get this error (when i start apache that is)

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll' - The specified procedure could not be found

even though if you navigate there on my harddrive its there?? ugh!!

Re: php5 and phpmyadmin??
 

You do know that PHP5 doesn't have MySQL installed like PHP4 right?

PHP5 has SQLite because of licesne differences or something, however you can install it.

Re: php5 and phpmyadmin??
 

well i was able to get most of it figured out. I had to rebuild the structure of the files in PHP5 then i had to move a few files around and add a few lines to the php.ini file to get php_mysql.dll to work again.

Re: php5 and phpmyadmin??
 

Killer_Typo, can you please share your findings in more detail 'cause I'm having the same problem. Thanks!

Re: php5 and phpmyadmin??
 

i honestly dont remember what i did now. but since php5 is now out of alpha and up for release it should be good to install now.

Re: php5 and phpmyadmin??
 

Here's how i solve the prob :

php.ini
extension_dir = "c:\php"

copy php_mysql.dll from c:\php\ext to c:\php
copy libmysql.dll and php_mysql.dll from c:\php to %Systemroot%\system and %Systemroot%\system32

Restart Apache2

Few of thoses steps are facultative but that's what i did.

Enjoy!

Re: php5 and phpmyadmin??
 

Hi,
Had same problem.

Same as above:
copy libmysql.dll
to windows system root system/ and system32/

I left my extention module path to be
php root ext/

though

That should mess with the activation of other modules then.

:)

Re: php5 and phpmyadmin??
 

Thanks for the replies. I'm really not sure why this 'still' isn't working. I have the dll files in the php\ext, php\, system\, AND system32\ folders. I have an environmental path to c:\php. It doesn't matter if I change the extension_dir to c:\php or leave it c:\php\ext. This is all I get with the latest version of phpMyAdmin.


I'd also like to mention that this was working 100% with php4. Any other suggestions 'cause, frankly, I'm a bit stumped on this??

Re: php5 and phpmyadmin??
 

I'm an idiot. PHP5 does not have MySQL enabled by default so the ;extension=php_mysql.dll in the php.ini file needs to be uncommented. Duh! :o

Thanks, everyone, for the assistance.