Cannot Load Mysql Extension Please Check Your PHP Configuration

RegisterLogin
Cannot Load Mysql Extension Please Check Your PHP Configuration
Post Description: Cannot Load Mysql Extension Please Check Your PHP Configuration
Tags: Cannot, Load, Mysql, Extension, Please, Check, Your, PHP, Configuration
This Post Was Posted On Apr 24, 2008 By daocuong #1497
how come im getting this error now

for some reason im also getting it now

Cannot load mysql extension. Please check your PHP configuration. - Documentation
Leave Your Comments
Related Pages: [Add Your Website]
Post New Topic
meganjo
#3353 1
thanx for sharing

[url=lowcostserverhosting/]dedicated linux server hosting [/url]
Jan 29, 2010 Reply Report abuse
yakan
#3324 2
ошибка cannot load mysql extension
Jan 22, 2010 Reply Report abuse
Web Hosting Support
#1932 3
The other day I was trying to install myphpadmin for a customer. I did a fresh install on a linux box. I upload phpmyadmin when I tried to pull it up with my browser, i got this error:

phpMyAdmin New Install Error: Cannot Load mysql extension. Please check your PHP Configuration

This is how you troubleshoot and fix this error problem:

STEP1. UPLOAD PHPINFO.PHP FILE - Uploaded a phpinfo.php file to your site. This will help you determine if you have the mysql extension installed in your server. If you dont know what a phpinfo.php file is, click here to learn about it.

STEP2. VIEW PHPINFO.PHP FILE - Once you have uploaded your phpinfo.php file to your site, pull it up with your browser. Look for the MYSQL section at the bottom of the page, It should look something like the image below. If you dont see it, continue with the next step. If case you DO. then the problem is something else that I dont know how to advise you how to fix. But if you DONT, then continue with step 3.


STEP3: STOP YOUR MYSQL SERVER- Stop your mysql server with the following command:

/etc/init.d/mysqld stop


STEP4. HOW TO INSTALL THE MYSQL EXTENSION: To install it, I will be using yum to fetch the necessary files. If have your domain name hosted by a shared web hosting company, then you most likely dont have your own server. If you have your own server, login to your ssh connection or open your shell and execute the following comamnd

yum install mysql mysql-devel mysql-server



NOTE: you will need to have internet access on your server to be able to access the mirror site. Also, I executed this command on a Redhat/Fedora Linux Server. Not sure if it will also work for other distributions such as SUSE, Mandrake, Debian, Centos, etc..

STEP4 HOW TO UPDATE MY PHP - Once all the new update have been installed, It would be a good Idea to update your php. Execute the following command to update. Otherwise, dont update. But in my example, I updated it. (do at your own risk).

/etc/init.d/httpd stop


(Stops your web server)

yum install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel



(gets the latest PHP)

STEP5 RESTART APACHE AND MYSQL - Once your MYSQL and PHP have been updated start your web server and mysql server with the following comand.

/etc/init.d/httpd start


/etc/init.d/mysqld start


After I did this, i didn't get the error anymore

Done. Hope this helps

IMPORTANT:

after you have done this clear your cookies and your cache on your browser, then close all you browser windows, then open your phpmyadmin again, this time it should work. if you dont clear your cookies or cache, you will continue to see the error but the error is just your cache, you need to refresh your content.
Jan 02, 2010 Reply Report abuse
webune
#2895 4
then i tried the apache command:

yum install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel


Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: mirror.web-ster.com
 * base: mirrors.cat.pdx.edu
 * extras: mirrors.usc.edu
 * updates: mirrors.kernel.org
Setting up Install Process
Package php-5.1.6-23.2.el5_3.i386 already installed and latest version
Package php-ldap-5.1.6-23.2.el5_3.i386 already installed and latest version
Package curl-7.15.5-2.1.el5_3.5.i386 already installed and latest version
Package perl-libwww-perl-5.805-1.1.1.noarch already installed and latest version
Package libxml2-2.6.26-2.1.2.8.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package ImageMagick.i386 0:6.2.8.0-4.el5_1.1 set to be updated
--> Processing Dependency: liblcms.so.1 for package: ImageMagick
--> Processing Dependency: libwmflite-0.2.so.7 for package: ImageMagick
--> Processing Dependency: libgs.so.8 for package: ImageMagick
--> Processing Dependency: librsvg-2.so.2 for package: ImageMagick
---> Package curl-devel.i386 0:7.15.5-2.1.el5_3.5 set to be updated
--> Processing Dependency: libidn-devel for package: curl-devel
---> Package libxml2-devel.i386 0:2.6.26-2.1.2.8 set to be updated
---> Package php-devel.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: autoconf for package: php-devel
--> Processing Dependency: automake for package: php-devel
---> Package php-gd.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-imap.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: libc-client.so.1 for package: php-imap
---> Package php-mysql.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: php-pdo for package: php-mysql
---> Package php-odbc.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-pear.noarch 1:1.4.9-6.el5 set to be updated
---> Package php-xml.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-xmlrpc.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Running transaction check
---> Package autoconf.noarch 0:2.59-12 set to be updated
--> Processing Dependency: imake for package: autoconf
---> Package automake.noarch 0:1.9.6-2.1 set to be updated
---> Package ghostscript.i386 0:8.15.2-9.11.el5 set to be updated
--> Processing Dependency: ghostscript-fonts for package: ghostscript
---> Package lcms.i386 0:1.18-0.1.beta1.el5_3.2 set to be updated
---> Package libc-client.i386 0:2004g-2.2.1 set to be updated
---> Package libidn-devel.i386 0:0.6.5-1.1 set to be updated
---> Package librsvg2.i386 0:2.16.1-1.el5 set to be updated
--> Processing Dependency: libcroco >= 0.6.1 for package: librsvg2
--> Processing Dependency: libgsf >= 1.6.0 for package: librsvg2
--> Processing Dependency: libgsf-1.so.114 for package: librsvg2
--> Processing Dependency: libcroco-0.6.so.3 for package: librsvg2
---> Package libwmf.i386 0:0.2.8.4-10.2 set to be updated
---> Package php-pdo.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Running transaction check
---> Package ghostscript-fonts.noarch 0:5.50-13.1.1 set to be updated
---> Package imake.i386 0:1.0.2-3 set to be updated
---> Package libcroco.i386 0:0.6.1-2.1 set to be updated
---> Package libgsf.i386 0:1.14.1-6.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================
 Package                      Arch              Version                           Repository       Size
========================================================================================================
Installing:
 ImageMagick                  i386              6.2.8.0-4.el5_1.1                 base            3.3 M
 curl-devel                   i386              7.15.5-2.1.el5_3.5                base            307 k
 libxml2-devel                i386              2.6.26-2.1.2.8                    base            2.1 M
 php-devel                    i386              5.1.6-23.2.el5_3                  base            502 k
 php-gd                       i386              5.1.6-23.2.el5_3                  base            116 k
 php-imap                     i386              5.1.6-23.2.el5_3                  base             53 k
 php-mysql                    i386              5.1.6-23.2.el5_3                  base             85 k
 php-odbc                     i386              5.1.6-23.2.el5_3                  base             52 k
 php-pear                     noarch            1:1.4.9-6.el5                     base            344 k
 php-xml                      i386              5.1.6-23.2.el5_3                  base             95 k
 php-xmlrpc                   i386              5.1.6-23.2.el5_3                  base             56 k
Installing for dependencies:
 autoconf                     noarch            2.59-12                           base            647 k
 automake                     noarch            1.9.6-2.1                         base            484 k
 ghostscript                  i386              8.15.2-9.11.el5                   base            5.9 M
 ghostscript-fonts            noarch            5.50-13.1.1                       base            801 k
 imake                        i386              1.0.2-3                           base            319 k
 lcms                         i386              1.18-0.1.beta1.el5_3.2            base            176 k
 libc-client                  i386              2004g-2.2.1                       base            516 k
 libcroco                     i386              0.6.1-2.1                         base            127 k
 libgsf                       i386              1.14.1-6.1                        base            116 k
 libidn-devel                 i386              0.6.5-1.1                         base            239 k
 librsvg2                     i386              2.16.1-1.el5                      base            178 k
 libwmf                       i386              0.2.8.4-10.2                      base            834 k
 php-pdo                      i386              5.1.6-23.2.el5_3                  base             64 k

Transaction Summary
========================================================================================================
Install     24 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 17 M
Is this ok [y/N]: y
Downloading Packages:
(1/24): php-odbc-5.1.6-23.2.el5_3.i386.rpm                                       |  52 kB     00:00
(2/24): php-imap-5.1.6-23.2.el5_3.i386.rpm                                       |  53 kB     00:00
(3/24): php-xmlrpc-5.1.6-23.2.el5_3.i386.rpm                                     |  56 kB     00:00
(4/24): php-pdo-5.1.6-23.2.el5_3.i386.rpm                                        |  64 kB     00:00
(5/24): php-mysql-5.1.6-23.2.el5_3.i386.rpm                                      |  85 kB     00:00
(6/24): php-xml-5.1.6-23.2.el5_3.i386.rpm                                        |  95 kB     00:00
(7/24): libgsf-1.14.1-6.1.i386.rpm                                               | 116 kB     00:00
(8/24): php-gd-5.1.6-23.2.el5_3.i386.rpm                                         | 116 kB     00:00
(9/24): libcroco-0.6.1-2.1.i386.rpm                                              | 127 kB     00:00
(10/24): lcms-1.18-0.1.beta1.el5_3.2.i386.rpm                                    | 176 kB     00:02
(11/24): librsvg2-2.16.1-1.el5.i386.rpm                                          | 178 kB     00:00
(12/24): libidn-devel-0.6.5-1.1.i386.rpm                                         | 239 kB     00:00
(13/24): curl-devel-7.15.5-2.1.el5_3.5.i386.rpm                                  | 307 kB     00:00
(14/24): imake-1.0.2-3.i386.rpm                                                  | 319 kB     00:00
(15/24): php-pear-1.4.9-6.el5.noarch.rpm                                         | 344 kB     00:00
(16/24): automake-1.9.6-2.1.noarch.rpm                                           | 484 kB     00:00
(17/24): php-devel-5.1.6-23.2.el5_3.i386.rpm                                     | 502 kB     00:00
(18/24): libc-client-2004g-2.2.1.i386.rpm                                        | 516 kB     00:00
(19/24): autoconf-2.59-12.noarch.rpm                                             | 647 kB     00:00
(20/24): ghostscript-fonts-5.50-13.1.1.noarch.rpm                                | 801 kB     00:00
(21/24): libwmf-0.2.8.4-10.2.i386.rpm                                            | 834 kB     00:00
(22/24): libxml2-devel-2.6.26-2.1.2.8.i386.rpm                                   | 2.1 MB     00:02
(23/24): ImageMagick-6.2.8.0-4.el5_1.1.i386.rpm                                  | 3.3 MB     00:02
(24/24): ghostscript-8.15.2-9.11.el5.i386.rpm                                    | 5.9 MB     00:03
--------------------------------------------------------------------------------------------------------
Total                                                                   1.0 MB/s |  17 MB     00:16
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : php-pdo                                                                         1/24
  Installing     : libcroco                                                                        2/24
  Installing     : libgsf                                                                          3/24
  Installing     : librsvg2                                                                        4/24
  Installing     : libc-client                                                                     5/24
  Installing     : libwmf                                                                          6/24
  Installing     : lcms                                                                            7/24
  Installing     : imake                                                                           8/24
  Installing     : autoconf                                                                        9/24
  Installing     : automake                                                                       10/24
  Installing     : php-devel                                                                      11/24
  Installing     : libidn-devel                                                                   12/24
  Installing     : curl-devel                                                                     13/24
  Installing     : php-pear                                                                       14/24
  Installing     : libxml2-devel                                                                  15/24
  Installing     : php-imap                                                                       16/24
  Installing     : php-odbc                                                                       17/24
  Installing     : php-mysql                                                                      18/24
  Installing     : php-xml                                                                        19/24
  Installing     : php-gd                                                                         20/24
  Installing     : php-xmlrpc                                                                     21/24
  Installing     : ghostscript-fonts                                                              22/24
  Installing     : ghostscript                                                                    23/24
  Installing     : ImageMagick                                                                    24/24

Installed:
  ImageMagick.i386 0:6.2.8.0-4.el5_1.1               curl-devel.i386 0:7.15.5-2.1.el5_3.5
  libxml2-devel.i386 0:2.6.26-2.1.2.8                php-devel.i386 0:5.1.6-23.2.el5_3
  php-gd.i386 0:5.1.6-23.2.el5_3                     php-imap.i386 0:5.1.6-23.2.el5_3
  php-mysql.i386 0:5.1.6-23.2.el5_3                  php-odbc.i386 0:5.1.6-23.2.el5_3
  php-pear.noarch 1:1.4.9-6.el5                      php-xml.i386 0:5.1.6-23.2.el5_3
  php-xmlrpc.i386 0:5.1.6-23.2.el5_3

Dependency Installed:
  autoconf.noarch 0:2.59-12                        automake.noarch 0:1.9.6-2.1
  ghostscript.i386 0:8.15.2-9.11.el5               ghostscript-fonts.noarch 0:5.50-13.1.1
  imake.i386 0:1.0.2-3                             lcms.i386 0:1.18-0.1.beta1.el5_3.2
  libc-client.i386 0:2004g-2.2.1                   libcroco.i386 0:0.6.1-2.1
  libgsf.i386 0:1.14.1-6.1                         libidn-devel.i386 0:0.6.5-1.1
  librsvg2.i386 0:2.16.1-1.el5                     libwmf.i386 0:0.2.8.4-10.2
  php-pdo.i386 0:5.1.6-23.2.el5_3

Complete!
Nov 25, 2009 Reply Report abuse
webune
#2894 5
this is what i got when i tried it on centos:

SHELL COMMAND:
yum install mysql mysql-devel mysql-server


and this is the result:

 
Loaded plugins: fastestmirror
Determining fastest mirrors
 * addons: mirror.web-ster.com
 * base: mirrors.cat.pdx.edu
 * extras: mirrors.usc.edu
 * updates: mirrors.kernel.org
addons                                                                           |  951 B     00:00
addons/primary                                                                   |  201 B     00:00
base                                                                             | 2.1 kB     00:00
base/primary_db                                                                  | 1.6 MB     00:09
extras                                                                           | 1.1 kB     00:00
extras/primary                                                                   | 107 kB     00:00
extras                                                                                          325/325
updates                                                                          | 1.9 kB     00:00
updates/primary_db                                                               | 235 kB     00:00
Setting up Install Process
Package mysql-5.0.77-3.el5.i386 already installed and latest version
Package mysql-server-5.0.77-3.el5.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package mysql-devel.i386 0:5.0.77-3.el5 set to be updated
--> Processing Dependency: openssl-devel for package: mysql-devel
--> Running transaction check
---> Package openssl-devel.i386 0:0.9.8e-12.el5 set to be updated
--> Processing Dependency: zlib-devel for package: openssl-devel
--> Processing Dependency: krb5-devel for package: openssl-devel
--> Running transaction check
---> Package krb5-devel.i386 0:1.6.1-36.el5 set to be updated
--> Processing Dependency: libselinux-devel for package: krb5-devel
--> Processing Dependency: e2fsprogs-devel for package: krb5-devel
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel
---> Package zlib-devel.i386 0:1.2.3-3 set to be updated
--> Running transaction check
---> Package e2fsprogs-devel.i386 0:1.39-23.el5 set to be updated
---> Package keyutils-libs-devel.i386 0:1.2-1.el5 set to be updated
---> Package libselinux-devel.i386 0:1.33.4-5.5.el5 set to be updated
--> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-devel
--> Running transaction check
---> Package libsepol-devel.i386 0:1.15.2-2.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================
 Package                          Arch              Version                     Repository         Size
========================================================================================================
Installing:
 mysql-devel                      i386              5.0.77-3.el5                base              2.4 M
Installing for dependencies:
 e2fsprogs-devel                  i386              1.39-23.el5                 base              568 k
 keyutils-libs-devel              i386              1.2-1.el5                   base               27 k
 krb5-devel                       i386              1.6.1-36.el5                base              1.8 M
 libselinux-devel                 i386              1.33.4-5.5.el5              base              143 k
 libsepol-devel                   i386              1.15.2-2.el5                base              187 k
 openssl-devel                    i386              0.9.8e-12.el5               base              1.9 M
 zlib-devel                       i386              1.2.3-3                     base              101 k

Transaction Summary
========================================================================================================
Install      8 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 7.1 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): keyutils-libs-devel-1.2-1.el5.i386.rpm                                    |  27 kB     00:00
(2/8): zlib-devel-1.2.3-3.i386.rpm                                               | 101 kB     00:00
(3/8): libselinux-devel-1.33.4-5.5.el5.i386.rpm                                  | 143 kB     00:00
(4/8): libsepol-devel-1.15.2-2.el5.i386.rpm                                      | 187 kB     00:00
(5/8): e2fsprogs-devel-1.39-23.el5.i386.rpm                                      | 568 kB     00:03
(6/8): krb5-devel-1.6.1-36.el5.i386.rpm                                          | 1.8 MB     00:01
(7/8): openssl-devel-0.9.8e-12.el5.i386.rpm                                      | 1.9 MB     00:02
(8/8): mysql-devel-5.0.77-3.el5.i386.rpm                                         | 2.4 MB     00:01
--------------------------------------------------------------------------------------------------------
Total                                                                   760 kB/s | 7.1 MB     00:09
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID e8562897
base/gpgkey                                                                      | 1.5 kB     00:00
Importing GPG key 0xE8562897 "CentOS-5 Key (CentOS 5 Official Signing Key) <centos-5-key@centos.org>" from /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : libsepol-devel                                                                   1/8
  Installing     : libselinux-devel                                                                 2/8
  Installing     : zlib-devel                                                                       3/8
  Installing     : e2fsprogs-devel                                                                  4/8
  Installing     : keyutils-libs-devel                                                              5/8
  Installing     : krb5-devel                                                                       6/8
  Installing     : openssl-devel                                                                    7/8
  Installing     : mysql-devel                                                                      8/8

Installed:
  mysql-devel.i386 0:5.0.77-3.el5

Dependency Installed:
  e2fsprogs-devel.i386 0:1.39-23.el5               keyutils-libs-devel.i386 0:1.2-1.el5
  krb5-devel.i386 0:1.6.1-36.el5                   libselinux-devel.i386 0:1.33.4-5.5.el5
  libsepol-devel.i386 0:1.15.2-2.el5               openssl-devel.i386 0:0.9.8e-12.el5
  zlib-devel.i386 0:1.2.3-3

Complete!
 
Nov 25, 2009 Reply Report abuse
turboio90
#2479 6
the problem with your sugesstion is that if you have The mysql setup as mysqli or pgsql theres bound to be a oci8 interbase mssql or sqlite extension is necessary but i will try your suggestion first, ill update if i have any success
Oct 01, 2009 Reply Report abuse
mysql
#1934 7
phpmyadmin - error cannot load mysql extension. please check your php configuration. - documentation
Jul 18, 2009 Reply Report abuse
:) -()
#1933 8
oh thanks, but my questions was:

centos cannot load mysql extension. please check your php configuration. - documentation
Jul 12, 2009 Reply Report abuse
Leave Your Comments...
©2011 Webune Forums - Mon Dec 19, 2011 12:48 am
Powered by: Webune Forums V3