which version of mySQL (redhat 9)
 

Hi,

I have been at it for a while now but I think I have the system performing the way I want it to.

About the only task left is to install mySQL so that I can get my PHP based sites to have database access.

I went to the site and saw a whole array of options and types of download and I'm just wondering what the right file to download from the mySQL site is for red hat 9.

Thanks. :)

Hi,

The RedHat 9 CD includes necessary rpm's for mysql 3.23.54.
Can try that one out.


Avirup
www.coolgoose.com/sites/avirupdg

I would suggest the lastest 4.0.x version which is the current production release of mysql. The 3.23.x is outdated. You can d/l the binary from mysql.com (which is already compiled), or the rpm either from mysql.com or from RH/FC2

Thanks for the responses.

I guess the question is out of all of the choices, which one describes my system. I kind of have an idea but I'm not quite sure.

The options are basically:

Linux (x86, glibc-2.2, static, gcc) standard, max or debug

Linux (x86, glibc-2.3, dynamic, intel c++ compiler, requires intel icc shared libraries) standard, max or debug

Linux (S/390) standard and max

Linux (ia64, intel c++ compiler) standard max and debug

Linux (alpha) standard max and debug

Linux (IBM / Motorola, PowerPC, IBM / POWER) standard max and debug

Linux (AMD64, Intel EM64T, glibc-2.3, dynamic, gcc) standard max and debug

Linux x86 RPM downloads and Linux IA64 RPM (glib-2.3, dynamic, gcc) in server, max, and other various options including embedded server.:confused:

The ones that mention 64 (like the AMD64 and Intel EM64T) seem to imply that they are intended for 64 bit machines. My system is not so I guess that rules them out.

I'm running Red Hat 9, so I suspect that means I can rule out the alpha, S/390 and IBM/Motorola variants.

This basically leaves me with an x86 version, though some questions still remain.

Do I go for the binaries or the RPM, and what, when it all boils down, is the difference?

If I go the binaries, they have different versions of the glibc item, and the second requires intel libraries. They say the former will be faster than the second because it is static, though the stecond will be faster again because it users the intel compiler.

Elsewhere, it says that the RPMs are made to run with the most efficiency, but there is no mention of glibc or the intel compiler for that, though I think I read somewhere that they are built with the -static option, so I guess that goes towards the speed issue.

Yes ... I'm a confused newbie ... though I think I have reasoned out a fair bit of it. :scratch:

Can anyone clear any of this up ... I'd just like to know the meaning of the specs and how they relate to my system.

Thanks ...

Go for the latest binary from mysql.com. RPMs are also precompiled binaries but they use the RH package management system to keep track of what is installed, where, etc... so you can easily upgrade or remove the installed software. Since you have a modern distro you don't have to worry about the libraries used to compile the source code. Have a look here

Again, thanks for your reply.

I'm still a bit confused though. Sorry if I am being a bit thick here.

Are you saying I should download the RPM or the other option which is unlabelled but I believe is supposed to represent the normal binaries?

At this stage I am looking at going with the Linux x86 RPM, but maybe that is just because I dont quite get it yet.

Thanks for any other feedback you can give. :)

mysql-standard-4.0.21-pc-linux-i686.tar.gz contains all the necessary files for mysql client/server and support files.
If you go with rpms you must d/l and install several of the following packages:
MySQL-server-VERSION.i386.rpm or MySQL-Max-VERSION.i386.rpm
MySQL-client-VERSION.i386.rpm
MySQL-bench-VERSION.i386.rpm
MySQL-devel-VERSION.i386.rpm
MySQL-shared-VERSION.i386.rpm
MySQL-shared-compat-VERSION.i386.rpm
MySQL-embedded-VERSION.i386.rpm
It's up to you, if you are confident with rpms go for them.

Okay, I got the package you recommended, and I think I managed to follow the instructions to the point where it is running.

Now comes the part I am coming to dread about linux.

How do I get it to work with PHP? Php was pre-installed on my system as was apache, and I cant make heads or tails of the instructions to make PHP use mySQL.

Also, what would be the reason for me being unable to access the mySQL server from a machine other than the one it is running on. It is on 192.168.0.3 and I want to use a program (Navicat) to access the server from 192.168.0.4

Any help would be great. Thanks