• This is a solution to the fairly common problem:

    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    Provided of course you do have apache/php/mysql installed and mostly working already.

    If you do, one solution is to place this bit of code in wp-settings.php before the check for MySQL which will load the mysql module if it’s available:

    if (!extension_loaded('mysql'))
    {
    if (!dl('mysql.so')) {
    exit;
    }
    }

    However, next time you upgrade WordPress you will need to remember to re-hack this code into wp-settings.php (unless it gets added to an official release someday).

    The better solution is to edit your php.ini (generally in /etc/php4/apache or similar under linux) and add the mysql module to the list of extensions at the very end of the file with:

    extension=mysql.so

    Restart Apache and you should be all set.

    I’ve tested this specifically on Debian Sarge with Apache 2.0.54, MySQl 4.0.24, and PHP 4.3.10-15

    I’m not taking credit for it, as Herman had most of the solution in this post ( https://comox.textdrive.com/pipermail/wp-hackers/2005-April/000821.html ), I’m just expanding on it. Hopefully this will make it onto the wiki and save folks some time in the future.

    Also, minor nitpick, but “…missing the MySQL which…” needs to be re-written. Either lose ‘the’ or add ‘module’ for a better sounding sentance.

Viewing 9 replies - 16 through 24 (of 24 total)
  • If you have a debian system, it’s as easy as:
    apt-get install php5-mysql

    Restart apache, and that is it!!

    I am getting this error message on OS X 10.4.7 trying to install WordPress 2.0.3. I’ve got the default version of Apache 1.3.33 but with PHP 5.1.4 and MySQL 4.1.20.

    I started up another thread as this is so Windows specific and I have an odd combination of versions.

    https://www.ads-software.com/support/topic/81007?replies=3

    I just want to note that for most applications you’re not going to notice a difference between PHP4 and PHP5 EXCEPT when PHP5 breaks things. For example, last I checked phpBB did not support PHP5, and I am fairly certain there are other major applications which don’t support it either.

    Thank you all for your helpful diagnostic advice above. I used a combination of posts to solve the problem so here is a brief recount of what I did.

    I have installations of
    – PHP 5.1.4 (using the Windows Binaries PHP 5.1.4 installer)
    – MySQL 5.0.22
    – Microsoft IIS 5.1
    all running on Windows XP locally.

    Do the following steps:
    1. See reply from “llbbl” (posted on 2005-09-27 22:25:00) and do steps 1, 2 and 3 (the explanatory paragraph at the end is useful also)
    2. See post from “chebolsk” (posted on 2006-02-24 03:11:06) and do step 2.

    That’s all that is required for this particular configuration.

    I found the following to be useful when configuring WordPress to work with Windows XP, IIS 5.0 and PHP 5.1.6. I assume that IIS already serves up PHP pages and you’re getting the “Your PHP installation appears to be missing the MySQL which is required for WordPress” error.

    1. Go to https://dev.mysql.com/downloads/ and select “MySQL Connector/PHP”

    2. Download both the mysqli and mysql extensions.

    3. Move the files that begin with “php_” to your extensions directory (usually c:\php\ext). Overwrite the existing files since these are NEWER and the LATEST from MySQL.

    4. Move libmysql.dll to your PHP directory (C:\php). Overwrite the existing file (the one you’ve downloaded is NEWER). Both ZIP files will have the same libmysql.dll since after PHP 5.0.2 both the mysql and mysqli extensions use the same file.

    5. Edit your php.ini file (in C:\php). Ensure the following lines exist and are NOT commented out:

    extension=php_mysql.dll
    extension=php_mysqli.dll

    6. Ensure your extensions directory is set as well in the php.ini file:

    extension_dir = “C:\php\ext”

    7. Configure Windows so it can find PHP, its DLLS, and the php.ini file (this was the CRITICAL step for me, especially the PHPRC variable I describe):

    Click Start -> Control Panel
    Double-click System
    Select the “Advanced” tab
    Click the “Environment Variables” button
    Under the “System variables” section, click the “Path” variable
    Click the “Edit” button
    Add “C:\php” to the path (no quotes). Note that each path is separated by a semicolon. Also, you should preferably add this EARLY in the path, since some of the MySQL DLLs may be included in other locations on your computer, and you’d like PHP to find the one installed in C:\php before it finds any other.
    Click “OK”
    Now, click the “New” button (again, in the “System variables” section)
    For variable name, supply “PHPRC”
    For variable value, supply “C:\php”
    Click “OK” repeatedly until you’ve got all the windows closed.

    8. Restart the computer so that these settings will be loaded and recognized by PHP. You can verify that your correct php.ini file is being loaded by testing a simple PHP page with the following:

    <?php

    phpinfo();

    ?>

    If your settings are correct, you should see that “Configuration File (php.ini) Path” is “C:\php\php.ini” on the resulting page.

    andhapp

    (@andhapp)

    Hello all,

    I had the same problem and it took me ages to identify the root cause of this issue. Here’s the solution on my blog:
    https://www.andhapp.com/blog

    PS: Check under PHP or WordPress section

    dmaher

    (@dmaher)

    All I had to do was install the PHP-MySQL+++++++.rpm file on the server and all was fine. I didn’t have to do any of the other stuff, it just worked after that.

    I don’t know if any of you is still facing that problem, but what worked for me is copying libmysql.dll from MySQL Server 5.0\bin to c:\Windows

    The command, apt-get install php4-mysql, will add the mysql module to php4 on Debian. Restart Apache. You should be good to go:)

Viewing 9 replies - 16 through 24 (of 24 total)
  • The topic ‘Your PHP installation appears to be missing the MySQL …’ is closed to new replies.