• Hi,
    we installed wordpress on a Windows IIS server running PHP & MySQL. I have created the database like I usually do for installing wordpress. But in this case, MySQL is on another domain. I changed the “localhost” to the domain where MySQL is located, in the wp-config file.

    However, I get the foll. error –
    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    Can someone please help?
    thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    www.remarpro.com Admin

    This error occurs when either:
    a) The MySQL extension is not loaded into PHP correctly (edit your PHP.INI file to be correct), or
    b) The wp-content/db.php file is missing (version 2.1 and up, may be differently named in older versions).

    So make sure that MySQL is loading correctly, and that all the WordPress files are present.

    In the PHP.INI (php folder on IIS server) file uncomment the php_mysqli.dll and php_mysql.dll (remove the semi-colon in front of them).

    Make a php info file (google it, just a few lines of code in a stand alone page) and go view it on a browser, it will tell you what is running or not. MySQL should be running now (WP will tell it what to connect to later)

    Load MySQL Administrator (from the main mysql site) on the machine with PHP and try to connect to the sql server. Whatever name it takes to resolve and connect is the name WP will use ok. 3306 is the default port for a TCP/IP connection… maybe security is on the server with sql, maybe sql is configured to not accept connections or something (not to sure… ours is all local and works so I didnt mess with it much).

    Hope that helps. I am running IIS6/PHP ISAPI, MySQL, and WP 2.1/K2 Theme if you need something let me know.
    -s

    @scotter:

    Have you experienced a php error that states
    “PHP has encountered an Access Violation at” and then some random numbers? I’ve got a similar setup and 2.1 keeps crashing my site.

    Sorry, I don’t get notified that new posts come up…

    I haven’t had that problem. How are you running PHP and what version? I am running it as ISAPI and not CGI, it is much quicker now, also its PHP512. At what point is it crashing with that error?

    I am planning on moving my setup to a dual Xeon setup (its on a piii rack server that by legal definitions can no longer be called a ‘server’). I hope to do it soon, maybe this week. I will document the process (at least some notes…) so I can recreate it if need be.
    s

    Copy in your file wp-config.php this code:

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

    I found this solution here:

    I got it working… my PHP version 4.3.2.

    My “/usr/lib/php4/mysql.so” seems to be corrupted or incompatible so I downloaded this file = php-mysql-4.3.2-1.i386.rpm.

    Note that they have different version, well that’s because I cannot find an exact package for my PHP. So naturally, it would complain about the dependencies so I force install it with nodeps.

    $rpm -ivh php-mysql-4.3.2-1.i386.rpm –nodeps

    I don’t recommend this however, what I’m saying is that it works for me.

    Cheers.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Your PHP installation appears to be missing the MySQL which is required’ is closed to new replies.