Search This Blog

2018/06/14

Missing the MySQL extension which is required by WordPress.

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

Install below will solve. MariaDB also need.
php-mysql
php-mysqlnd

CentOS:
yum install php-mysql
yum install php-mysqlnd
# php72
yum install php72-php-mysql
yum install php72-php-mysqlnd

Ubuntu:
apt-get install php-mysql
apt-get install php-mysqlnd

2 comments :

  1. I got the same problem but it might be different now because it is now 2019 but maybe the solution I presented below might help in case you encounter the same issue. PHP version 5.6 and below is no longer supported in PHP community so it was advised to upgrade to version 7.2 and up. In case of wordpress, old version are using mysql extension but PHP 7.2 version are no longer supported it, mysqli extention was now been used by PHP version 7.2. So older version of wordpress will encounter this problem if PHP versio is upgraded to 7.2.

    So this is what happened. When I upgraded my website http://fractioncalc.com from PHP version 5.6 to 7.2, I encountered this problem “Your PHP installation appears to be missing the MySQL extension which is required by WordPress”. It turns out that mysql extension is no longer supported in php version 7.2. It is now using mysqli extention. I am using old version of wordpress which still using mysql extension that is why the problem existed. So what I did is upgraded the wordpress to the core. This solve the problem.

    Here's the steps I followed when upgrading wordpress manually.
    1. First I created a full backup of my website. This is very important in case of mistake.
    2. I download the newest WordPress ZIP file from wordpress.org.
    3. I unzipped the file into a local directory of my computer.
    4. I went to my website root directory and deleted your ‘wp-includes’ and ‘wp-admin’ directories. I used sFTP connection using Filezilla software.
    5. I uploaded the new wp-includes and wp-admin directories from the new version of WordPress I unzipped to my website root directory and replaced the directories I just deleted.
    6. I did not delete the wp-content directory or any of the files in that directory. I just copied over the files from the wp-content directory in the new version of WordPress to my existing wp-content directory. All existing files with the same name have been overwritten.
    7. I copied all files from the root (‘/’) directory of the new version of WordPress that I unzipped into my website root directory (or the root directory of your WordPress installation). Existing files has been overwritten and new files has been copied across. wp-config.php file was not be affected because WordPress has never distributed with a wp-config.php file.
    8. I compare wp-config-sample.php which was\s distributed with WordPress but did not find anything to change so I just used the old one.
    9. I cleared my browser cache to ensure I can see all changes.
    10. I checked the site and there is no error now. Thanks God the upgrade was completed.

    ReplyDelete
  2. How to Fix “Your PHP Installation Appears to Be Missing the ... — What Does “Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress” Mean? ... Support for this extension was deprecated in versions of PHP 7.0 and beyond. This means that if you're seeing this message, your WordPress site's code isn't compatible with the version of PHP you're using.
    for more information click here: YOUR PHP INSTALLATION APPEARS TO BE MISSING THE MYSQL EXTENSION WHICH IS REQUIRED BY WORDPRESS

    ReplyDelete