How to Fix “PHP Missing MySQL Extension” Error in WordPress

Recently, a user encountered the ‘your PHP installation appears to be missing the MySQL extension which is required by WordPress’ error and asked us if there was a way to fix it.

When this error appears, it prevents users from viewing your website. If it occurs frequently, then it can be bad for your site’s user experience.

In this article, we will show you how to fix PHP missing MySQL extension error in WordPress.

How to fix PHP missing MySQL extension error

What Is the PHP Missing MySQL Extension Error?

When you’re working on building a WordPress website or visiting a web page, you may come across the ‘your PHP installation appears to be missing the MySQL extension which is required by WordPress’ error.

This error usually means that something went wrong with your site’s code and it’s preventing WordPress from connecting to its MySQL database.

The PHP missing MySQL extension error usually appears when you update or install WordPress, migrate a website, change server configurations, or switch operating systems that don’t have a MySQL extension (like Linux).

That said, let’s see the causes for this error.

What Causes the PHP Missing MySQL Extension Error?

There are multiple reasons why a PHP missing MySQL extension error may occur.

One of them is that you are using an outdated version of WordPress with the latest PHP version. If you’re using PHP 7.0 or higher, then you should know that it deprecated the MySQL extension.

So, if you have an older version of WordPress that’s working with PHP 7.0 or higher, then it won’t find the MySQL extension and cause this error.

Another reason why you might see this error is that the MySQL extension is either missing or not properly configured. Even if you’re using PHP 5.6 or lower, the PHP missing MySQL extension error can still occur due to an outdated MySQL extension.

Now, let’s see some of the ways you can fix the ‘your PHP installation appears to be missing the MySQL extension which is required by WordPress’ error.

You can use the links below to check out any of the tips you’d like:

Fixing the PHP Missing MySQL Extension Error in WordPress

Now that you know what causes this WordPress error, here are some of the ways to fix it.

1. Check The PHP Version You Are Using

The first thing you can do is check the PHP version of your website. A conflict between WordPress and PHP version usually results in the PHP missing MySQL extension error.

To start, you can head to the Tools » Site Health page from the WordPress dashboard. From here, simply switch to the ‘Info’ tab.

Opening Site Health Info in WordPress

After that, you can scroll down to the ‘Server’ section and click to expand it. Here, you’ll see the server information for your website.

Go ahead and view the PHP version in the details.

Check PHP version

If your site’s PHP version starts with 7 or lower, then it means you’ll need to update it. This can solve the PHP missing MySQL extension error as it would be compatible with the latest WordPress version.

We highly recommend using PHP 8.0 or the latest version because it will safeguard your site from security threats. Plus, it will also optimize your site’s performance and fix any security vulnerabilities and bugs.

You can learn more by following our guide on how to update your PHP version in WordPress.

2. Update WordPress to the Latest Version

After checking the PHP version, you can also see which WordPress version you’re using.

If it is an older version and you’re running the latest PHP version, then consider updating WordPress to resolve the PHP missing MySQL extension error.

A simple way to check the WordPress version is by going to Dashboard » Updates from the WordPress admin panel. Here, look for the ‘Current version’ information.

Check wordpress version

If the WordPress version is 3.9 or lower, then we recommend updating it to fix the missing MySQL extension error.

The best thing is that WordPress comes with a built-in update manager. You can update to the latest version with a click of a button.

WordPress updates

To learn more, please see our guide on how to safely update WordPress.

3. Ensure You Have MySQL Extension Installed

Now that you have updated the PHP version and WordPress on your website and are still facing the ‘PHP missing MySQL extension’ error, then you need to check if the MySQL extension is correctly installed on your site.

You can do that by going to the Tools » Site Health page from the WordPress dashboard. Next, you’ll need to switch to the ‘Info’ tab.

Opening Site Health Info in WordPress

After that, head to the ‘Database’ section and click to expand it.

In the Extension field, look for mysqli or mysql.

Look for extension info in database

If you see the field blank or not visible at all, then it means you’re missing the MySQL extension.

Now, the installation process for the extension will depend on your WordPress hosting provider. You can simply reach out to them for help or ask the support team to install it for you.

4. Check Your PHP Configuration

Another way to fix the PHP missing MySQL extension error is to check your site’s PHP settings.

At times, you might be uploading the wrong php.ini file or using the wrong file path. This leads to PHP configuration issues and missing MySQL extension errors.

The php.ini file is a default configuration file for PHP and impacts how your site functions. Uploading the incorrect file usually happens if you’re using a different operating system. For example, you might be uploading the php.ini file that’s intended for Windows on a Linux server.

To find the path of your php.ini file in the phpinfo.php file, you can enter the following web address in the browser:

www.example.com/phpinfo.php

Just make sure to replace www.example.com with your domain name.

Next, you will see details of your PHP installation.

View php installation details

From here, you can scroll down and look for the ‘Configuration File Path’ or ‘Loaded Configuration File’ fields.

Once you locate the php.ini file, simply connect to an FTP client, go to the file path, and delete it to see if it fixes the PHP missing MySQL extension error.

View path of php ini file

Before deleting, we recommend creating a backup of the existing file by downloading it onto your computer. This way, if anything goes wrong, you can restore the php.ini file and access your website.

Bonus Resources for Fixing WordPress Errors

Now that you know about PHP missing MySQL extension error, you can also check out our guides on resolving other WordPress errors:

We hope this article helped you learn how to fix the PHP missing MySQL extension error in WordPress. You may also want to see our tips to speed up WordPress performance or our complete WordPress troubleshooting guide.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post How to Fix “PHP Missing MySQL Extension” Error in WordPress first appeared on WPBeginner.

Where Is php.ini in WordPress? (& How to Edit This File)

Are you wondering where the php.ini file is located on your website?

Php.ini is a critical file in your WordPress installation. You’ll often need to edit it for better functionality and performance of your website. However, many website owners don’t know where it is located.

In this article, we’ll show you where is php.ini in WordPress and how to edit this file.

Where is php.ini in WordPress and how to edit it

To help you navigate the post, you can click the links below to jump to any section you’re interested in.

What is php.ini file in WordPress?

The php.ini file is a default configuration file for PHP on your WordPress site. PHP is a scripting and programming language on which WordPress is written.

It’s used on the server side of things, which means it runs on your web hosting server. Through PHP, WordPress is able to display your blog posts, products, media content, and more.

The php.ini file configures how PHP works and can have a huge impact on your website’s functionality. Whenever PHP runs on your site, it will look for this file.

That said, let’s see why and when you’ll need to edit the file on your website.

Why Do You Need to Edit php.ini File in WordPress?

The php.ini file is very important for your site’s performance and functionality. This means you can edit it to ensure your website works smoothly or resolve any errors.

For instance, editing the php.ini file allows you to increase the maximum file upload size and resource limits.

If you have a photography website or a site that requires a lot of videos and images, then you might encounter an error ‘uploaded file exceeds the upload_max_filesize’ message.

Increasing the upload size in the php.ini file will help resolve this error and allow you to easily upload larger media files. Plus, you can also increase the available memory to accommodate long blog posts with lots of images.

Check current file upload size limit

Similarly, the php.ini file lets you edit the file timeout settings. If a file takes longer to process, then your site can timeout and stop processing the request. To prevent this from happening, you can increase the number of seconds before timeout through the php.ini file.

Lastly, you’ll also be able to enable or disable file extensions in PHP by editing the file. This is really useful if you see a ‘Your PHP installation appears to be missing the MySQL extension’ error on your site. It helps fix this error and resolve issues when establishing a database connection.

Now, let’s look at where the php.ini file is located in WordPress.

Finding the php.ini File Location in WordPress

There are several ways you can locate and view the php.ini file.

You can use your hosting service’s cPanel, a plugin, or an FTP client to access your website files and folders.

1. Use cPanel to Locate the php.ini File

You can use the cPanel provided by your WordPress hosting provider and access the File Manager to locate the file. This method is pretty straightforward, and you don’t need to edit any code.

For this tutorial, we will use Bluehost to access the cPanel. If you’re using another hosting service, then the steps may vary.

First, you’ll need to log in to your Bluehost account. From here, simply click the ‘Advanced’ option in the left panel.

Open advanced settings in Bluehost

On the next screen, you’ll see the cPanel of your website.

Simply scroll down to the Files section and click the File Manager option.

Open file manager in cpanel

After that, you’ll see all the folders and files of your WordPress website.

From the left panel, you can navigate to the ‘public_html’ folder. Next, you should see files in the folder on your right. You can scroll down and locate the ‘php.ini’ file.

Locate php.ini file

To download the file for editing, you can simply right-click the php.ini file and save it on your computer.

2. Locate the php.ini File using a File Manager Plugin

Another way of finding out where is the php.ini file in WordPress is by using a plugin like WP File Manager.

It is a free WordPress plugin that lets you edit, download, delete, and organize your files and folders directly from the WordPress dashboard. You don’t have to use an FTP client or cPanel to access your site’s files.

First, you’ll need to install and activate the WP File Manager plugin. If you need help, then please see our guide on how to install a WordPress plugin.

Upon activation, you can head to WP File Manager from your WordPress admin panel.

Next, you’ll need to select the ‘public_html’ folder from the panel on the left. After that, you can scroll down and navigate to the ‘php.ini’ file.

View php.ini file in file manager plugin

Once you’ve located the file, simply right-click to download it onto your computer.

3. Finding php.ini Path in WordPress using the phpinfo.php File

You can also find the php.ini file by creating a phpinfo.php file and placing it in the root directory of your WordPress installation.

This is a slightly advanced method and is recommended for people who know how to use an FTP client and access the root directory of a website.

First, you’ll need to create a new text editor file. You can use Notepad, Bracket, Sublime Text, or any similar software to create one. In the file, ensure that you enter the following code:

<?PHP phpinfo(); ?>

Next, you’ll need to save the file and name it phpinfo.php. You can use any other name, but make sure that there is ‘.php’ at the end.

After that, you will need to use an FTP client to access the root directory of your website and upload the file. Simply drag the phpinfo.php file from the left panel and drop it into your site’s root directory.

Upload php info file

If you need help, then please see our guide on how to use FTP to upload files to WordPress.

Next, you will need to enter the following web address in your browser:

www.example.com/phpinfo.php

Just make sure that you replace the ‘example.com’ with your domain name.

From here, you’ll see details about PHP installation on your site and the path for locating the php.ini file.

View php installation details

To find the path of the file, you can look for the ‘Configuration File Path’ or ‘Loaded Configuration File’ fields.

You’ll see the path for the php.ini file in either one of the fields.

View path of php ini file

Once you know the path, you can access your site’s files using an FTP client.

From there, simply go to the path you just discovered and download the php.ini file.

Access path of php ini file and download it

Editing the php.ini File in WordPress

Now that you know the location of the php.ini file, the next step is to download and edit it.

Go ahead and open the file in Notepad or any other text editor.

Edit php ini file

Next, you can edit the file to improve your site’s performance. Here are a few common configurations you can make in the php.ini file:

  • max_execution_time – This is the time needed to run commands and execute scripts. You can increase the default time of 60 to a higher number if you’re uploading large files to the server.
  • memory_limit – It relates to the memory needed to upload files and execute commands. Editing the memory limit will help you accommodate long content and lots of images. By default, it is set to 256M, but you can increase the memory limit.
  • upload_max_filesize – Editing this option allows you to upload large media files and increase the limit.
  • post_max_size – If your blog posts contain a lot of images and videos, then the size of the post will increase. To avoid any errors, you can increase the post_max_size to accommodate more extensive articles.

Once you’ve made these changes to the php.ini file, you can simply upload it back to your server in the same location using the cPanel, an FTP client, or the file manager plugin.

We hope this article helped you learn where is php.ini in WordPress and how to edit it. You may also want to see our guide on the most common WordPress errors and the best WordPress plugins.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The post Where Is php.ini in WordPress? (& How to Edit This File) first appeared on WPBeginner.