Avatar of Shaun Wingrin
Shaun Wingrin
Flag for South Africa asked on

Upgrade MySQL version 5.0.95 to Ver 5.5 on Centos

Say, Current system:

[root@a1 ~]# uname -a
Linux a1.a1telecoms.co.za 2.6.18-238.12.1.el5 #1 SMP Tue May 31 13:23:01 EDT 2011 i686 athlon i386 GNU/Linux
[root@a1 ~]# cat /etc/redhat-release
CentOS release 5.8 (Final)
MySQL version 5.0.95

Please give detailed steps to upgrade to MySQL 5.5
LinuxMySQL ServerLinux OS Dev

Avatar of undefined
Last Comment
arnold

8/22/2022 - Mon
arnold

You can download RPM from dev.mysql.com
Centos is built on RedHat whose update paths do not include major version transitions.
Are you looking to transition because of a specific feature you need, or because it is newer?

You could install the newer version and then have to update the elated components, for php, etc.
You have to make sure everything else you have is not affected by changes implemented in the newer version versus what was available in the old.
Shaun Wingrin

ASKER
I specifically need MYSQL 5.5 - and only interested in it a s MySQL server, the other components are not important. I need 5.5 for the latest ODBC driver to work.
Please give exact links and instructions.
Aside question: Does CentOS 6 include the MySQL 5.5 version?
Tx
arnold

No, centos 6.x has mysql5.1.
The server is not the only component your odbc needs, you need all the libraries as well.

Dev.mysql.com

http://dev.mysql.com/downloads/mysql/5.5.html#downloads
Select redhat 5. Which is part of the selection of oracle, redhat 4,5.

Download and install.  Are you absolutely certain that an ODBC connection requires mysql 5.5 or get http://dev.mysql.com/downloads/connector/odbc/#downloads
Your help has saved me hundreds of hours of internet surfing.
fblack61
Sandy

yum update
Shaun Wingrin

ASKER
Getting error with ODBC and suggestion is to upgrade to 5.5

yum update -  believe CentOS5 stops at MySql 5.1 - can you confirm please?
arnold

You could add a fedora repo from which you can install 5.5 but you would have to make sure to maintain it if security updates are neeeded.

http://www.tecmint.com/install-mysql-on-rhel-centos-6-5-fedora-17-12/

Which ODBC are you installing?  Are you installing a third party or one from Mysql.com?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Shaun Wingrin

ASKER
One from Mysql  -can you direct me to 3rd party to try pls
ASKER CERTIFIED SOLUTION
arnold

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.