Solved

phpmyadmin - Cannot load mysql extension. Please check your PHP configuration.

Posted on 2009-07-12
3
1,276 Views
Last Modified: 2013-12-13
I've checked out some of the "solutions"  to my problem on here and haven't come up with the right solution for me...other than headaches :)

I've attached the phpinfo document that i've saved. I have the php.ini files in both the php and C:\Windows section, the path is pointing to my ext folder in the PHP folder.

I'm still getting the Cannot load mysql extension. Please check your PHP configuration.

I bought a new computer with Vista on it. My old computer has Vista also, but It actually has running copies of apache, mysql, php, and phpmyadmin. I've set it up, but apparently can't get the new computer to work with phpmyadmin.

Php and Apache are talking apparently, I installed the GUI software for mysql, and the Admin version said that mysql is running. I've restarted my computer countless times.

I even put the libmySQL.dll in the different folders like people have suggested. I've also uncommented the php_mysql.dll and the php_mysqli.dll areas in the php.ini file.

Any help would be much appreciated. I've spent a day work on installing all of this stuff on the new computer - which put me a day behind on my freelance work.
PHPInfoDoc.docx
0
Comment
Question by:AlteredHope
  • 2
3 Comments
 
LVL 108

Assisted Solution

by:Ray Paseur
Ray Paseur earned 100 total points
ID: 24836398
IIRC, MySQL support is no longer bundled in PHP, and you have to do a separate install of MySQL.  In phpinfo() I have a separate MySQL section that does not appear in the Word document you posted.  So maybe just adding the modules does not do the trick - maybe there is an install step?
0
 

Author Comment

by:AlteredHope
ID: 24836467
I don't think I understand what your saying about an install step? I did install everything separately, in this order, apache, php, mysql, and then phpmyadmin which isn't working.

I think I left off some stuff from the phpinfo page. I've attached another copy.
0
 

Accepted Solution

by:
AlteredHope earned 0 total points
ID: 24836917
Fixed it.

Around line 133 of the config.inc.php file for PhpMyAdmin (Version 2.10.2) It was set to

$cfg['Servers'][$i]['extension']       = 'mysql';

I changed mysql to say

$cfg['Servers'][$i]['extension']       = 'mysqli';

and it works.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now