Fix PHP Missing MySQL Extension Error in WordPress

If you’re seeing a PHP missing MySQL extension error in WordPress, it means your server isn’t configured to support MySQL functions needed by WordPress. This issue prevents your site from connecting to the database, causing it to crash or display error messages. Fixing this problem ensures your WordPress site runs smoothly, loads correctly, and remains accessible to visitors. Before starting, you’ll need access to your hosting control panel or server files, and the ability to modify PHP settings or install PHP extensions.

What You’ll Need

• Access to your hosting control panel (cPanel, Plesk, etc.) or server via SSH
• Permission to edit PHP configuration files (php.ini, .htaccess, or user.ini)
• Knowledge of your server’s PHP version
• Optional: Command line access for advanced users

Step-by-Step

1. Identify Your PHP Version:
   Log into your hosting control panel or connect via SSH. Find the PHP version your server is running, as the extension names and methods vary across versions. In cPanel, look for ‘Select PHP Version’ or ‘PHP Config’. In SSH, run php -v.
2. Check if the MySQL Extension is Installed:
   Create a PHP info file by adding a new file named phpinfo.php to your website root with the content:

   <?php phpinfo(); ?>

   Access this file via your browser (e.g., http://yourdomain.com/phpinfo.php). Search for ‘mysqli’ or ‘mysql’ sections. If they are missing, the extension isn’t installed or enabled.

3. Enable or Install the MySQL Extension:
   – For cPanel Users:
   – Navigate to ‘Select PHP Version’ or similar.
   – Check the box next to ‘mysqli’ and ‘mysqlnd’ extensions.
   – Save changes.
   – For server administrators using SSH:
   – Depending on PHP version, run commands like:

   sudo apt-get install php-mysqli

   or

   sudo yum install php-mysqli

   .
   – Restart your web server (e.g., sudo systemctl restart apache2 or sudo systemctl restart php-fpm).

4. Edit PHP Configuration Files Manually:
   – Locate your php.ini file (via phpinfo() or server documentation).
   – Ensure the following lines are present and uncommented:

   extension=mysqli
   extension=mysqlnd

   – Save and restart your web server.

5. Verify the Extension is Enabled:
   Reload your phpinfo.php page. Confirm that ‘mysqli’ and ‘mysqlnd’ are listed under ‘Loaded Extensions’.
6. Test Your WordPress Site:
   Visit your WordPress site to see if the error persists. If fixed, your database connection should now work correctly.

Common Mistakes

• Not restarting the web server after making changes to PHP configs.
• Editing the wrong PHP configuration file, especially if multiple PHP versions are installed.
• Forgetting to check the PHP version before installing extensions.
• Using the wrong extension name for your PHP version (e.g., ‘mysql’ instead of ‘mysqli’).
• Attempting to enable extensions on a shared hosting environment without proper permissions.

Tips

• Always back up your server or configuration files before making changes.
• If unsure about your PHP version, create a phpinfo.php file to check.
• Use the hosting provider’s documentation or support if you’re on shared hosting.
• Consider switching to PHP 7.4 or higher for better performance and security, but ensure extensions are compatible.
• Clear your server cache after making changes to ensure new settings take effect.

Troubleshooting

If after following the steps your WordPress site still shows the missing MySQL extension error, try the following:

• Double-check PHP version and extension installation: Ensure you’re editing the correct PHP version’s configuration. Multiple PHP versions on a server can cause confusion.
• Review error logs: Check your server’s error logs for specific messages related to PHP extensions or configuration issues.
• Disable and re-enable extensions: Sometimes toggling the extension off and on again in your control panel helps resolve conflicts.
• Contact your hosting provider: If you’re on shared hosting and can’t enable extensions yourself, reach out to support for assistance.
• Update WordPress and plugins: Ensure your WordPress core, themes, and plugins are up to date as outdated software can sometimes cause compatibility issues.
• Test with a default theme: Switch to a default WordPress theme (like Twenty Twenty-Three) to rule out theme conflicts.

If problems persist, consider migrating to a hosting environment that provides better control over PHP settings, or consult a developer for advanced troubleshooting.

Frequently Asked Questions

1. Why does WordPress need the MySQL extension?

WordPress relies on PHP extensions like mysqli to connect to the MySQL database. Without these, it cannot retrieve or store data, causing errors or blank pages.

2. How do I know which PHP extension my server needs?

Check your PHP info file. Most modern servers use mysqli and mysqlnd. If these are missing, you need to enable or install them.

3. Can I fix this error on a shared hosting plan?

Yes, typically via your hosting control panel by enabling the extensions. If not available, contact support for assistance.

4. What should I do if I don’t have access to the server files?

Contact your hosting provider’s support team and ask them to enable the MySQL extensions for your PHP version.

5. Is updating PHP risky?

Updating PHP can cause compatibility issues with some plugins or themes. Always back up your site before upgrading and test thoroughly afterward.

6. How do I prevent this error in the future?

Keep your PHP version updated and ensure your hosting environment supports the necessary PHP extensions for WordPress.

Related

• How to Fix MTP Not Working in Windows 11: Complete Guide
• How to Fix MSXML4 DLL Not Found Error on Windows 11
• How to Fix mss32.dll Is Missing on Windows 10, 8, 7