Compiled PHP 7 missing mysql extension in WordPress

1 Views

I have built PHP 7 with a configuration that worked for a previous version of PHP.
Now my WordPress websites get the message:

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

Read More

Other websites using mysqli do work. What am I missing?

I’ve also included all .so files with mysql in the name: 

extension=dba.so
extension=mysql.so
extension=mysqli.so
extension=mysqlnd_mysql.so
extension=mysqlnd_mysqli.so
extension=mysqlnd.so
extension=pdo.so
extension=pdo_mysql.so
extension=pdo_odbc.so
extension=odbc.so
Post Views: 1

Related posts

6 comments

  1. PHP 7 has removed mysql_* completely.

    You need to use PDO or mysqli. WordPress seems not to support this.

  2. mysql_* functions got deleted in PHP 7.0 update your code to mysqli or PDO

    Also take a look at prepared statements if you are handling user input. To reduce the chance of SQL injections

    An example of mysqli connection string:

    <?php
$mysqli = new mysqli("localhost", "user", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
?>

    An example of pdo connection string:

    <?php
    $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
?>

    Note:

    That mysqli example handles a connection error

  3. As has been mentioned elsewhere, the ext/mysql functions have been removed. We’ve been talking about this for some time.

    ext/mysql was built for MySQL 3.23 and only got very few additions since then while mostly keeping compatibility with this old version which makes the code a bit harder to maintain.

    If you’re hell-bent on putting them back in, you can add them back to PHP 7 by using the ext/mysql PECL Library

    It’s important to note that WordPress 3.9 or later supports mysqli

    In WordPress 3.9, we added an extra layer to WPDB, causing it to switch to using the mysqli PHP library, when using PHP 5.5 or higher.

  5. This issue is caused by php 7.1.0-dev.

    I built another one with the same configuration version 7.0.0 and the issue was resolved.

    This has nothing to do with WordPress since it will automatically try to use MySQLi when MySQL is not found. At least in WP 4.4.

  6. On Ubuntu, I fixed this error by running

    sudo apt-get install php-mysql

    And then restarting my server (caddy, but you might be using apache or nginx).

    source

Comments are closed.