How to Install MySQL 5.x?

[SupermanInNY]

Hi All,

My client wants me to install version 5.x as it is the GA version (4.1.x is also available but no longer off the main page).

Any pointers on how to go about this?

This is a clean server, just DA and no users as of yet.

Thanks,

-Alon.

 

[DamnSkippy]

We need to know what OS you are running.

Also 4.1.x is still available from the mysql web site. If your client wants V5 just because he thinks it is the latest so he should have it you may want to inform him otherwise.

 

[SupermanInNY]

We need to know what OS you are running.

Also 4.1.x is still available from the mysql web site. If your client wants V5 just because he thinks it is the latest so he should have it you may want to inform him otherwise.

CentOS 4.4 (final)

And yes.. I informed the client. I don't have direct connection to the techi in the client's company, but the msg that was relayed to me was that they are looking into the differences between the versions and version 5 has features that they will need to implement.
Hey.. it's their server,.. and their application. Who am I to say anything other than "YES,.. MASTER"

 

[DamnSkippy]

Well then just download the RPMs from the mysql site and install them using the upgrade option. As in rpm -uvh rpmfilename. This is the way I did it on a CentOS box about 2 weeks ago.

Don't forget to run the fix privileges script when you are done upgrading.

 

[SupermanInNY]

Well then just download the RPMs from the mysql site and install them using the upgrade option. As in rpm -uvh rpmfilename. This is the way I did it on a CentOS box about 2 weeks ago.

Don't forget to run the fix privileges script when you are done upgrading.

Thanks for the input.
However, that brings me to the next two questions:


1. What RPM did you choose for Centos?

Linux x86 generic RPM (dynamically linked) downloads?

OR

Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads

OR

Red Hat Enterprise Linux 4 RPM (x86) downloads

And, since I never installed mysql on my own before, do I need to d/l the server, client, shared libraries, headers... whatever they have there under the segment I'm d/l from?

Question 2:
How do I Undo - remove delete etc. the version of 4.1?
Will this be done automatically? or can I issue a remove command (if it is an RPM install, what command do I need to give it? Is it a single command for rpm --remove? will it know to remove all the additional headers/devel etc that was installed via the DA install?

Thanks,

-Alon.

 

[DamnSkippy]

You need the ones for red hat and you need the server, client, devel and shared ( installed in that order). The was one dependency that was needed and I used yum to install it. Somehting with perl I think.

using rpm -uvh rpmname will upgrade MySQL V4 to V5

Then you need to delete the files:
/etc/init.d/mysql
/etc/rc?.d/*mysql

You will notice if you look before and after that the RPMs install the same (relatively) files as above but if I remember correctly they have a d on the end of the name. You need to delete the old ones so the system does not try to start mysql twice.