Its done I think :D
Okay, I sorted out it. I had to upgrade following RPM's by downloading those from any RPM providers from net.
[email protected] [~]# rpm -qa |grep -i mysql
MySQL-shared-5.0.84-0.glibc23
MySQL-bench-5.0.84-0.glibc23
MySQL-devel-5.0.84-0.glibc23
MySQL-server-5.0.84-0.glibc23
MySQL-client-5.0.84-0.glibc23
I got a lot of PERL module dependencies and none of them were installed through cpan or WHM>>Install Perl Module and /scripts/perlinstaller.
I had to install all of the perl module dependencies from RPM sources.
Like:
#wget
ftp://fr2.rpmfind.net/linux/epel/4/i386/perl-Net-Daemon-0.44-7.el4.noarch.rpm
--19:38:09--
ftp://fr2.rpmfind.net/linux/epel/4/i386/perl-Net-Daemon-0.44-7.el4.noarch.rpm
#rpm -Uvh perl-Net-Daemon-0.44-7.el4.noarch.rpm
#rpm -Uvh
ftp://ftp.freshrpms.net/pub/freshrp...ag/RPMS/perl-PlRPC-0.2020-1.el5.rf.noarch.rpm
and then I downloaded these RPM's and installed them by rpm -Uvh:
MySQL-bench-5.0.84-0.glibc23.x86_64.rpm
MySQL-client-5.0.84-0.glibc23.x86_64.rpm
MySQL-devel-5.0.84-0.glibc23.x86_64.rpm
MySQL-server-5.0.84-0.glibc23.x86_64.rpm
MySQL-shared-5.0.84-0.glibc23.x86_64.rpm
Don't use '--nodeps' option.
and now it is working fine
[email protected] [~]# mysql -V
mysql Ver 14.12 Distrib 5.0.84, for unknown-linux-gnu (x86_64) using readline 5.1
[email protected] [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3547
Server version: 5.0.84-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
----------------
How was it?