LinuxQuestions.org - phpMyAdmin - Cannot load mySQL extension

Hey all,
Having one long night trying to get phpMyAdmin working on my RHEL4 box. Got mysql install properly:

Code:

$rpm -qa | grep -i mysql

MySQL-devel-community-5.0.45-0.rhel4

MySQL-shared-community-5.0.45-0.rhel4

MySQL-client-community-5.0.45-0.rhel4

MySQL-server-community-5.0.45-0.rhel4

and have php installed:

Code:

$rpm -qa | grep -i php

php-ldap-4.3.9-3.15

php-4.3.9-3.15

php-pear-4.3.9-3.15

and have apache up and working.

When i try to open up phpMyAdmin i get:

Code:

Cannot load mysql extension. Please check your PHP configuration.

I have read many threads and from what I see I need to install php-mysql.
I downloaded the RPM and trying to install, and get the following:

Code:

$rpm -ivh php-mysql-4.3.9-3.22.9.i386.rpm

error: Failed dependencies:

        libmysqlclient.so.14 is needed by php-mysql-4.3.9-3.22.9.i386

        libmysqlclient.so.14(libmysqlclient_14) is needed by php-mysql-4.3.9-3.22.9.i386

        php = 4.3.9-3.22.9 is needed by php-mysql-4.3.9-3.22.9.i386

    Suggested resolutions:

        mysql-4.1.20-1.RHEL4.1.i386.rpm

As well i tried the php-mysql-4.3.9-3.15.i386.rpm package, maybe version needed to be the same as PHP. Guess not.

I would much prefer to keep mysql 5 and not have to backtrack.

my my.cnf as follows:

Code:

$cat /etc/my.cnf 

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

    

[mysql.server]

user=mysql

#basedir=/var/lib



[mysqld_safe]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

Any help would be awsome!
Thanks so much.