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

Question

How do I fix the error below      Your PHP installation appears to be missing the MySQL extension which is required by WordPress    I use my NAS with a telnet connection   I installed FFP 0 7  My php ini is in  ffp etc php ini and I uncommented everything I thought to be of use   Below is a portion of my php ini file    If you wish to have an extension loaded automatically  use the following   syntax        extension modulename extension     For example  on Windows    extension msql dll         or under UNIX    extension msql so         or with a path    extension  ffp lib extensions no-debug-non-zts-20100525 mysql so     extension php mysql dll extension php mysqli dll extension php pdo mssql dll extension php pdo mysql dll extension php pdo oci dll extension php pdo odbc dll extension php pdo pgsql dll extension php pdo sqlite dll extension php pgsql dll extension pdo so extension pdo sqlite so extension sqlite so extension pdo mysql so   The outstanding issue is that when I run in phpinfo    I see the module MySQLi activated but not MySQL   MySQL is working as expected just as PHP and Lighttpd web server   I equally have phpmyadmin working   It s on a Zyxel NSA310   Also  when mysqld is started  it creates a shortcut from my root to  ffp opt mysql   and every time I restart my NAS the shortcut is deleted   Does anyone might know a trick for this

User · Answer

in the end i found a solution First  make sure MySQL server is running  Type the following command at a shell prompt    etc init d mysql status  If MySQL is not running  enter    etc init d mysql start  If MySQL is not installed  type the following command to install MySQL server   apt-get install mysql-server  Make sure MySQL module for php5 is installed   dpkg --list   grep php5-mysql  To install php5-mysql module enter   apt-get install php5-mysql  Next  restart the Apache2 web server    etc init d apache2 restart

User · Answer

After nearly seven years this keeps getting different answers      Many are similar--but none identical--to what worked for me   Here s what worked for me  Ubuntu server    Moving a site to a new server  forgot to install the PHP MySQL module extension   I ran a quick  apt-get install php-mysql   and then  apachectl restart   Bada bing   No php5  php7  just plain php-mysql

User · Answer

As few people shared to tick mark the checkbox for mysqli and mysqlind  but Hostgator  webhosting site  now does not give that option to select extension via the cpanel as that option is removed select PHP and now it gives the option for php manager  You can just select the Php version you want and not the extension    Solution  - Called the hostgator   first time they said get in touch with your developer    i asked my brother and he downloaded the files locally and verified it was working fine on local system   lt -- this was not needed though  Again called the hostgator and their backend team installed the missing extension and it was solved   Below is the code which gives this error when it does not find the extension and you can find this line in load php via ftp    if     extension loaded   mysql     amp  amp    extension loaded   mysqli     amp  amp    extension loaded   mysqlnd     amp  amp    file exists  WP CONTENT DIR     db php            require once ABSPATH   WPINC     functions php       wp load translations early         args   array           exit    gt  false           code    gt   mysql not found              wp die               Your PHP installation appears to be missing the MySQL extension which is required by WordPress                   Requirements Not Met              args            exit  1

User · Answer

If you have Wordfence plugin installed I found commenting out the suPHP ConfigPath lines in the  htaccess file brought the website back to life     Wordfence WAF   lt IfModule mod suphp c gt      suPHP ConfigPath   home a1614947 public html    lt  IfModule gt    I ve reported this to Wordfence too

User · Answer

If people are using shared Linux hosting with cPanel  Godaddy  Reseller club  Hostgator or any Shared Hosting   try the following   Under Software and Services tab -  Select PHP Version -  PHP Selectors   Extentions   Tick all MySQL related extensions  save it and you are done  Please check the attached image

User · Answer

Check the  extension dir     remove it if it is there  that should fix the problem

User · Answer

When you upgarde your php version  make sure  apache2 follows  You can create a phpinfo   file which could show that apache is still using the old php version   In this case you should use the a2dismod php-old-version and a2enmon php-mod-version commands  Exemple    in ubuntu  your grab the old version from  etc apache2 mods-enabled  or from the version shown by the phpinfo file  and you grab the new one from  etc apache2 mods-available   gt  sudo a2dismod php5 6  gt  sudo a2enmod php7 1  gt  sudo service apache2 restart

User · Answer

This MySQL library worked for me   sudo apt-get install php5-mysqlnd-ms

User · Answer

In my case  using CPanel PHP selector and selecting the mysqli and mysqlnd worked  Ensure to save and recheck once

User · Answer

On Oracle Linux 7 x running PHP version 7 3 x you need to run sudo yum install php-mysqlnd in order to install the missing MySQL extension for PHP   Remember to restart PHP and or your server for the changes to take effect

User · Answer

For php 5 6  sudo apt-get install php5 6-mysqlnd-ms and restart your apache   etc init d apache2 restart

User · Answer

Just install apt-get install php5-mysqlnd Restart Apache service apache2 restart

User · Answer

This issue was due to lack of database  If it is a fresh installation  you need to manually create one and assign user with privileges    Please check in wp-config php for any bad configurations and make sure that database and tables are not missing or corrupted

User · Answer

The source of this message was unrelated to the solution in my case   My ip address of my server changed and i didn t change the  lt VirtualHost gt  directive in my httpd conf of the apache server   Once i changed it to the correct ip address the message disappeared and Wordpress is working again

User · Answer

Make sure you tick Mysqli and mysqlnd as shown in the screenshot

User · Answer

I just removed custom php ini  which I don t use at all  The problem gone  site is working fine

User · Answer

This Error is created by the WP core file  wp-includes load php and the function name is wp check php mysql versions     The older versions of the WP does not support MySqli  But the latest WP versions support both MySql and MySqli extensions without bothering installed PHP versions   Solved my problem 100   In my case  I just updated the Wordpress core files manually and solved the issue

User · Answer

It maybe the reason The php mysql api is deprecated  if your using below  lt  PHP5 5 just update in your server to 5 6 and above

User · Answer

For me  ubuntu 16 04  the winner was   sudo apt install php7 0-mysql

User · Answer

I had same issue as mentioned   Your PHP installation appears to be missing the MySQL extension which is required by WordPress  in resellerclub hosting    I went through this thread and came to know that php version should be greater than   5 6 so that wordpress will automatically gets converted to mysqli  Then logged into my cpanel searched for php in cpanel to check for the version  luckly was able to find that my version of php was 5 2 and changed that to 5 6  by making sure mysqli is tick marked in the option window and saved it is working fine now

User · Answer

The php mysql api is deprecated   It s kaput --- going away -- not to be used  finito   If you have a modern version of PHP    5 6  then Wordpress should automatically switch to make use of mysqli   That should be your first attempt   If you can not update your php  rather than attempting to resurrect something that php no longer supports  just patch your wordpress   http   wordpress org plugins mysqli

User · Answer

When I upgraded my website PHP from 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    First I created a full backup of my website  This is very important in case of mistake  I download the newest WordPress ZIP file from wordpress org  I unzipped the file into a local directory of my computer  I went to my website root directory and deleted your    wp-includes    and    wp-admin    directories  I used sFTP connection using Filezilla software  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  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   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  I compare wp-config-sample php which was distributed with WordPress but did not find anything to change so I just used the old one  I cleared my browser cache to ensure I can see all changes  I checked the site and there is no error now  The upgrade was completed

User · Answer

I m using Fedora 25  sudo dnf search php   grep mysql  php-mysqlnd x86 64   A module for PHP applications that use MySQL databases php-pear-MDB2-Driver-mysqli noarch   MySQL Improved MDB2 driver mysqli  sudo dnf install php-mysqlnd x86 64

User · Answer

I have resolved the issue just adding following code in  htaccess file  I hope this will work for you guys also   Step 1  Change the PHP version form the server   Step 2  Add the following code in your  htaccess file according to your PHP version  Selected from the server    To switch to PHP 4 4   AddHandler application x-httpd-php4  php   To switch to PHP 5 0   AddHandler application x-httpd-php5  php   To switch to PHP 5 1   AddHandler application x-httpd-php51  php   To switch to PHP 5 2   AddHandler application x-httpd-php52  php   To switch to PHP 5 3   AddHandler application x-httpd-php53  php   To switch to PHP 5 4   AddHandler application x-httpd-php54  php   To switch to PHP 5 5   AddHandler application x-httpd-php55  php   To switch to PHP 5 6   AddHandler application x-httpd-php56  php   To switch to PHP 7   AddHandler application x-httpd-php7  php   To switch to PHP 7 1   AddHandler application x-httpd-php71  php

User · Answer

Make sure msqli and mysqlnd are checked in your php selector  Then go over change the name of your  htaccess file to  htaccess old  See if your site can load now   If it works  then go to your dashboard and save your permalinks  it will create a new  htaccess file   This worked for me

[php] Php - Your PHP installation appears to be missing the MySQL extension which is required by WordPress

Examples related to php

Examples related to mysql

Examples related to wordpress

Examples related to nas