Solved

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

Posted on 2009-07-12
3
1,277 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

862 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

23 Experts available now in Live!

Get 1:1 Help Now