Centos – How to upgrade MYSQL 5.0.82sp1 and Phptheadmin 2.8.2.4 in Centos 5

From the remi repo, you need mysql-server. Try yum install mysql-server; you'll then be able to chkconfig and service mysqld to your heart's content.

If your remi repo isn't enabled by default, it'll be yum --enablerepo=remi install mysql-server; try that if you get a bunch of unresolved dependency messages.

I installed IUS and RPM Forge Release and then removed old packages. with a dump from MySQL for sure. and then re-installed PHP54 and MySQL55.

assuming it's CentOS/RHL 5 and you have old PHP & MySQL installed

first find all packges related to php by:

rpm -qa | grep php

then remove matched packages:

yum remove [packages]

then search for mysql:

rpm -qa | grep mysql

again remove matched packages:

yum remove [packages]

now install IUS & RPMForge release for latest versions of PHP and MySQL:

wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/epel-release-5-4.noarch.rpm
wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/ius-release-1.0-10.ius.el5.noarch.rpm
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm

Install DAG's GPG key :

rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt

then install those rpms:

rpm -i epel-release-5-4.noarch.rpm
rpm -i ius-release-1.0-10.ius.el5.noarch.rpm
rpm -i rpmforge-release-0.5.2-2.el5.rf.*.rpm

now check for an update:

yum update

to install PHP54 & MySQL55:

yum install php54 mysql55-server

all dependencies will be installed

to install module for PHP applications that use MySQL databases:

yum install php54-mysql

restart apache:

service httpd restart

run mysql secure installation:

mysql_secure_installation

restart mysqld:

service mysqld restart

I think It's done.

and for exporting MySQL database:

mysqldump -u root -p --all-databases > all_databases.sql

to import that database I think this works:

mysql -u root -p < all_databases.sql

as you installed IUS release you can easily download latest versions of phpMyAdmin:

assuming you have installd phpMyAdmin package. remove it first:

yum remove phpMyAdmin

install phpMyAdmin3:

yum install phpMyAdmin3

then look for phpMyAdmin directory where files are stored:

whereis phpMyAdmin 

make a symbolic link of the directory that contains phpMyAdmin management interface where it is accessible from Apache

ln -s [phpMyAdmin Directory]

if you recive forbidden error while accessing phpMyAdmin from browser try this:

chown -h [user]:[group] [Path to phpMyAdmin  symbolic link]