CentOS 5.4 – Fix Missing MySQL Extension for WordPress PHP Installation

centos5MySQL

I have just upgraded to PHP Version 5.3.3, on my CentOS Linux 5.4, when i tried to install wordpress it says

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

Here is my php.ini file

./configure' '–build=i686-redhat-linux-gnu' '–host=i686-redhat-linux-gnu' '–target=i386-redhat-linux-gnu' '–program-prefix=' '–prefix=/usr' '–exec-prefix=/usr' '–bindir=/usr/bin' '–sbindir=/usr/sbin' '–sysconfdir=/etc' '–datadir=/usr/share' '–includedir=/usr/include' '–libdir=/usr/lib' '–libexecdir=/usr/libexec' '–localstatedir=/var' '–sharedstatedir=/usr/com' '–mandir=/usr/share/man' '–infodir=/usr/share/info' '–cache-file=../config.cache' '–with-libdir=lib' '–with-config-file-path=/etc' '–with-config-file-scan-dir=/etc/php.d' '–disable-debug' '–with-pic' '–disable-rpath' '–without-pear' '–with-bz2' '–with-exec-dir=/usr/bin' '–with-freetype-dir=/usr' '–with-png-dir=/usr' '–with-xpm-dir=/usr' '–enable-gd-native-ttf' '–without-gdbm' '–with-gettext' '–with-gmp' '–with-iconv' '–with-jpeg-dir=/usr' '–with-openssl' '–with-pcre-regex=/usr' '–with-zlib' '–with-layout=GNU' '–enable-exif' '–enable-ftp' '–enable-magic-quotes' '–enable-sockets' '–enable-sysvsem' '–enable-sysvshm' '–enable-sysvmsg' '–with-kerberos' '–enable-ucd-snmp-hack' '–enable-shmop' '–enable-calendar' '–without-sqlite' '–with-libxml-dir=/usr' '–enable-xml' '–with-system-tzdata' '–with-apxs2=/usr/sbin/apxs' '–without-mysql' '–without-gd' '–disable-dom' '–disable-dba' '–without-unixODBC' '–disable-pdo' '–disable-xmlreader' '–disable-xmlwriter' '–without-sqlite3' '–disable-phar' '–disable-fileinfo' '–disable-json' '–without-pspell' '–disable-wddx' '–without-curl' '–disable-posix' '–disable-sysvmsg' '–disable-sysvshm' '–disable-sysvsem'
Server API Apache 2.0 Handler

How to solve this issue ?

Best Answer

Make sure that MySQL module for php (php-mysql) is installed:

rpm -qa | grep mysql

and you have following in /etc/php.d/mysql.ini or /etc/php.ini:

extension=mysql.so

Related Solutions

CentOS 5.5 – configuring thesql with php, missing thesql.so

Odd. On my RHEL box, mysql.so is provided by php-mysql. What does rpm -ql php-mysql | grep mysql.so give you?

It's possible you're running into versioning issues? The RHEL/CentOS repository is on version 5.1.6 of PHP. But you've compiled php5.3 from source, and it appears you've used the php-mysql package. I'm not sure if the latter will play nice with the former. You might be better off from an ease of administration standpoint just installing the php package from the repository. If you don't need any of the features provided solely in 5.3, it'll probably be a ton easier for you.

Also, did you compile PHP with the proper flags for mysql? (--with-mysql ?)

--Christopher Karel

Centos – Drupal7 doesn’t detect MySQL on CentOS, but WordPress3 does

See EDIT at the end FIRST!

The MySQL module has been enabled - but has it been installed:

su -c 'rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm'
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm
yum --enablerepo=remi install php-pdo

Also - to make sure all needed modules are installed:

yum --enablerepo=remi install php-mysql

This may also update other php dependencies.

EDIT:

I just had cause to do this on a 64-bit Centos server and got some dependency error messages and then mysql would not start due to this error:

Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 641 error messages.

With a bit of digging this turned out to be because I ended up with both the 64-bit AND 32-bit versions of mysql installed. I finally got round this by doing the following:

yum remove mysql-server*
yum remove mysql-*
yum install --enablerepo=remi mysql.x86_64 mysql-server.x86_64 php-mysql php-pdo

You may not run into this extra work if you yum remove mysql and mysql-server first.

Because of the extra hassle, I have to add: 'Follow my steps at your own risk'!!!

Best Answer

Related Solutions

CentOS 5.5 – configuring thesql with php, missing thesql.so

Centos – Drupal7 doesn’t detect MySQL on CentOS, but WordPress3 does

Related Topic