4 Ways to Fix “Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress.”

Sometimes, when loading your WordPress website, the “your PHP installation appears to be missing the MySQL extension which is required by WordPress” error might pop up.

This error is typically caused by a nonexistent MySQL extension, outdated WordPress software, or an old PHP version.

Luckily, the missing MySQL extension error is easy to solve. In this article, we’ll explore its causes and walk you through the four methods to fix the error.

Error codeYour PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress
Error typeServer-side error
Error causesMissing MySQL extension Outdated WordPress version Using PHP 5.6 or lower

What Causes the “Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress.” Error

This error occurs when your server’s PHP can’t connect your WordPress site to the MySQL database. As a result, you get an error message instead.

There are several possible causes of the said problem, namely:

Missing MySQL Extension

Not having the correct WordPress MySQL extension is one of the most common causes of this error.

The MySQL extension was deprecated from PHP 7.0 and above in favor of MySQLi extensions and PDO_MySQL. Therefore, if you’re using a modern PHP version, you may have an outdated MySQL extension.

You can find out your PHP version in your control panel. For Hostinger users, open hPanel, and check your PHP configuration information there.

Outdated WordPress Version

You may also face this error if you’re using an outdated version of WordPress with PHP 7.0 and above. Since the modern PHP version deprecated the MySQL extension, WordPress will not find the extension it’s looking for.

Using PHP 5.6 or Lower

The 5.6 and lower PHP versions may not have deprecated the MySQL extension yet, but rather, your current PHP version may not be configured properly. As a result, WordPress is unable to connect to the necessary extension.

How to Fix “Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress.”

After figuring out the cause of this issue, the next step is to fix it.

In this section, we’ll explore the four ways to repair the problem.

1. Check If the MySQL Extension Is Enabled

If you’re using PHP 5.6 or lower, you need to check whether the MySQL extension has been installed. Do this by uploading a phpinfo.php file into your browser.

To do so, follow the steps below:

  1. Sign in to your hosting account via File Transfer Protocol (FTP) like FileZilla or access Hostinger’s File Manager from hPanel.
File Manager menu on hPanel
  1. Open the public_html folder to access the root directory of your WordPress site.
The public_html folder on Hostinger File Manager
  1. Create a new file and name it phpinfo.php.
New file button on Hostinger File Manager
  1. Edit the file by adding the following code snippet:

<?php

phpinfo();

?>

Edit the file and input the code
  1. To load this file into a browser, add /phpinfo.php after your website’s URL. For instance, example.com/phpinfo.php. Once it loads, the page will show you a list of your website’s PHP settings.
The phpinfo.php page when displayed on a broswer

For this issue, look for the row named the Client API version.

Client API version information on the phpinfo.php fie

If you can’t find it, that means the extension is not installed.

To fix that, contact your hosting provider and ask them to install the extension for you. Hostinger users can easily manage their PHP extensions via hPanel.

Alternatively, update your PHP version so that the extension is unnecessary.

2. Make Sure the PHP Extension Is Properly Configured

Once you’re sure that the PHP extension is installed, the next step is to check whether it’s properly configured.

One of the main causes of PHP configuration problems is that you’re uploading the wrong php.ini file or it has an incorrect file path. This can happen when you’re uploading a file that’s intended for Windows when you’re using a Linux server or vice versa.

You can find this information in the Loaded Configuration File row in the phpinfo.php file you have uploaded before.

Loaded Configuration File row in the phpinfo.php file.

First, don’t forget to create a backup of this file by downloading it to your computer. After, delete the php.ini file and check whether this fixes the problem.

3. Check the PHP Version You’re Using

To change your PHP version, go to the Tools → Site Health menu on your WordPress dashboard.

Choose the Info tab. Scroll down and expand the Server option. You can see the PHP version you’re currently using under this section.

Server information section on WordPress dashboard

Another option is to use the phpinfo.php file you uploaded earlier. Scroll to the Core section and look for the PHP Version row.

PHP Version information on the phpinfo.php file

If your PHP version starts with the number 7, you might need to update the WordPress software. However, if the version starts with 5, you may be missing the MySQL extension instead.

4. Update the WordPress Core Software

If your current version of PHP is already above 7, this problem might be caused by an outdated WordPress installation instead. Version 3.9 or lower can prompt this error.

We recommend updating the WordPress software to the most recent version. Aside from fixing this problem, doing so also comes with other benefits for your WordPress sites, such as security and performance improvements.

Important! Make sure to back up your website before proceeding with the WordPress software update.

To update the core software manually, go to WordPress.org and download the latest WordPress installation version.

Download the latest version of WordPress from WordPress.org

Then, extract the zip file into your computer. Open the folder that contains all the WordPress files and delete the following ones:

  • wp-config-sample.php file
  • wp-content folder
  • wp-config.php file

If you can’t find some of these among your existing files, proceed to delete the ones you see in the installation folder.

After that, upload the rest of the files and folders to your server via FTP. In case you see an error message about duplicate files, choose the Overwrite option.

Once everything is uploaded, your WordPress website should work properly.

Conclusion

In this article, we have figured out the causes for the “your PHP installation appears to be missing the MySQL extension which is required by WordPress” error, which are a missing MySQL extension, an outdated WordPress version, or an older version of PHP.

We’ve also covered the four ways you can fix this issue, namely:

  • Checking if the MySQL extension is enabled
  • Making sure that the PHP extension is properly configured
  • Checking the current version of PHP you’re using
  • Updating the WordPress core software

If you still have any questions about the PHP or MySQL extension error, feel free to drop them in the comments section. Don’t forget to check out our other tutorials to improve your WordPress site.

Author
The author

Mulan G.

Mulan is a Digital Marketing enthusiast experienced in creating social media content. She is eager to help people learn in the simplest way possible. During her free time, Mulan likes to cook and watch sci-fi or documentaries.