Support » Installing WordPress » PHP installation appears to be missing MySQL…

  • I followed all of the instructions in the detailed installation in the WordPress Codex and I have searched these support boards but I can’t find a solution to this problem.

    I get the following message when trying to browse the install.php file: Your PHP installation appears to be missing the MySQL which is required for WordPress.

    I know MySQL is up and running but this tells me that something is not right with the PHP setup or the WordPress configurations. I’ve checked dozens of times to make sure that wp-config.php has the correct info.

    I’m running WordPress, PHP, and MySQL on the same Windows Server 2003 SP1 box (using IIS). Versions:
    Wordpress 1.5.1
    PHP 5.0.4
    MySQL 4.1.11-nt

    Details of wp-config.php:
    db: wordpress
    user: wordpressadmin
    pass: ***
    host: localhost

    I would really appreciate any help you could give! Thanks in advance.

Viewing 11 replies - 1 through 11 (of 11 total)
  • PHP must have the MySQL extentions installed to communicate with the server. Otherwise, you have 2 distinct pieces of software that are un-aware of each other.

    It would seem that PHP 4 for Windows had MySQL compiled in my default, but PHP 5 doesn’t. You’re going to have to enable it through your php.ini file.

    Please go to http://us4.php.net/mysql for more information.

    Regards

    Thread Starter gilmoro

    (@gilmoro)

    I went into the php.ini file and added the php_mysqli.dll in the list of extensions. Didn’t work. Tried removing the semicolons; didn’t work. I already added c:\php to the system paths in environment variables when I first installed PHP. Still having the same problems. Any further ideas?

    Thread Starter gilmoro

    (@gilmoro)

    Here’s a super question… will WordPress work on an older version of PHP that has MySQL support built-in. I can’t get the stupid thing to load the bloody extension no matter what I do.

    I ran into the same problem, error message and everything. I ended up tracking down the server location of MySQL and replacing “localhost” with the actual location. Then installation worked like a charm. I suspect that “99 percent” statement might need to be changed to 80 percent …

    I think some of the binaries that you can download from php.net do not come with precompiled support for MySQL.

    I have a similar problem with Windows 2003, MySQL 4.0.12 and PHP 5.05.

    I am going to try installing PHP 4.4.0 since it says on the downloads page that MySQL support is complied in.

    Here is a link to how I solved my problem.

    http://wordpress.org/support/topic/37800#post-253130

    When I have to do the whole Windows thing I find WAMP takes away all the pain. 🙂

    It doesn’t use IIS of course but who uses IIS these days unless they are writing ASP.NET or are forced to in a corporate environment?

    Mythmenot, when you inserted the “actual location”, do you mean the path to MySQL? I’m trying to set this up on my home server. Would I then put in something along the lines of “e:\MySQL\” instead of localhost, or do I refer it to mywebpage.com?

    Debian Linux solution:

    I have solved this problem in Debian. I started Kpackage and, after looking for php4-mysql package, I finally installed it. I had previously changed my wp-config.php by adding a piece of code proposed by Matt Mullenweg for the wp-config.php file (http://comox.textdrive.com/pipermail/wp-hackers/2005-April/000821.html).

    He resuelto este problema en una Debian. Arranqué Kpackage, busqué el paquete php4-mysql y, finalmente, lo instalé. Tengo que decir que, previamente, había modificado el archivo wp-config.php añadiéndole una pedazo de código propuesto por Matt Mullenweg (http://comox.textdrive.com/pipermail/wp-hackers/2005-April/000821.html).

    Saludos

    I had to remove “Internet Explorer Enhanced Security Configuration” from my Windows 2003 Server before I could get WordPress to work.

    Go to Control Panel > Add or Remove Programs > Add/Remove Windows Components > uncheck “Internet Explorer Enhanced Security 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 http://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.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘PHP installation appears to be missing MySQL…’ is closed to new replies.