missing the MySQL extension

  • JukeBoxWhiz

    (@jukeboxwhiz)


    10 years, 2 months ago

    Hello. first off the version I list is just a guess because I can’t get in dashboard to find the correct version. I just know the version is like 6 months old.

    I’m using XAMPP on a Windows 7 machine. Yesterday i got into the wordpress site to do some work and there was an update notification. Tried to update automatically and it would complain about too much time. Downloaded the version off the web separately and when I tried to install it complained about the file size.

    Someone on the web suggested changing setting in the php.ini file. I changed to what they recommended. Then there was a complaint about another setting, which I changed.

    Upshot – Now when I try to get to the index or the dashboard, I get this error:

    “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”

    I tried changing all the settings back and restarting XAMPP. Nope. Same message.

    I looked around for solutions to this problem, most of them are 9 or 10 years old and the solutions don’t work.

    For instance I have this:

    extension=php_mysql.dll
    extension=php_mysqli.dll

    I’m wondering, if nothing else, is it possible to get a fresh copy of php.ini?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Nathan Rodriguez

    (@ubuntulinux)

    10 years, 2 months ago

    You can try reinstalling XAMPP, or give WAMP Server a try.

    Randy Sandberg

    (@randywsandberg)

    10 years, 2 months ago

    You can run WordPress without having a php.ini file. What I’ve seen most is that folks create one in order to change the MAX upload file size.

    Here’s a handy guide for the php.ini file:

    http://us.php.net/ini.core

    Also, you can quickly find out all about your current PHP state by:
    1. Creating a file called phpinfo.php
    –> actually, as long as it ends with .php you can pretty much name it anything you wish
    2. Pasting this into it:

    <?php

 phpinfo()

?>

    3. Placing it in your site’s root directory
    –> at least that’s where I always put it
    4. Then simply point your web browser to http://www.mysite.com/phpinfo.php

    And BOOM! All kinds of helpful PHP info will be displayed. Then, after you tweak things with your new php.ini knowledge, you can see the fruits of your labor by rerunning this phpinfo.php file.

    Oh, this is only for testing purposes. NEVER leave the phpinfo.php file where anyone else can gain access to it being that some of the info shared might help compromise your system.

    Hope this helps!

    Randy Sandberg

    (@randywsandberg)

    10 years, 2 months ago

    P.S., On a brand new install of WordPress using MAMP ver. 3.5 on my MacBook Air, when I run my phpinfo.php file, I see:

    Loaded Configuration File	/Applications/MAMP/bin/php/php7.0.0/conf/php.ini
Scan this dir for additional .ini files	(none)
Additional .ini files parsed	(none)

    Thus, once you run the phpinfo.php file on your server, you’ll know which php.ini is loaded. Then you can remove it from your WordPress directory and run the phpinfo.php file again to find the default php.ini file. Which in my case, is HUGE! 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘missing the MySQL extension’ is closed to new replies.