Hi, I'm totally new to MySQL / PHPAdmin and have been dropped in at the deep end regarding getting MySQL and phpMyAdmin upgraded...

When I look at the RPM's I see:
php-mysql-4.2.2-17.2
php-4.2.2-17.2
php-imap-4.2.2-17.2
php-ldap-4.2.2-17.2

But when I go to the GUI I see:
Welcome to phpMyAdmin 2.5.7-pl1
MySQL 4.0.16-standard-log running on localhost as root@localhost

So to start with I'm not totally sure what version I'm running! I need to get these upgrades done due to PCI requirements so they are saying to upgrade to at least 4.0.25 I'm currently running RedHat9 so ideally need to know the easiest way to upgrade to a later 4.0 or 4.1 version.

Then how to upgrade... (I have already tried but couldnt get things to work - daemon wouldn't start, etc...!)

Thanks for any assistance,
Wayne

is this production machine?

FYI redhat 9 no longer supported
my suggestion to you is backup your file include database
and port to new installation of centos

or test it with another machine first

What does this show you:

?

[root@odworksdb02 root]# cat /etc/issue
Red Hat Linux release 9 (Shrike)
Kernel \r on an \m

Like routers said, that version of RH is totally obsolete & hasn't been updated in yrs.
http://en.wikipedia.org/wiki/Red_Hat_Linux
Either get RHEL 5.4 (paid support) http://en.wikipedia.org/wiki/Red_Hat_Enterprise_Linux or go for the free (no support) version Centos 5.4 http://en.wikipedia.org/wiki/CentOS, depending on your requirements.

chrism01, would I have to reinstall Centos 5.4 from scratch or there is a way to upgrade my current RH9?

Thanks,

RH9 not upgradable
get centos5.4 install only what you need to the new machine

backup database and port to it and test make it work
if not work then ask back here