Solved

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

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

773 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