LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-13-2004, 03:29 AM   #1
Stryks
LQ Newbie
 
Registered: Oct 2004
Posts: 11

Rep: Reputation: 0
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.
 
Old 10-13-2004, 04:34 AM   #2
avirup dasgupta
Member
 
Registered: Aug 2003
Distribution: Redhat , Fedora Core4, DSL,Solaris
Posts: 49

Rep: Reputation: 15
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
 
Old 10-13-2004, 05:26 AM   #3
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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
 
Old 10-13-2004, 07:54 AM   #4
Stryks
LQ Newbie
 
Registered: Oct 2004
Posts: 11

Original Poster
Rep: Reputation: 0
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.


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.

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 ...
 
Old 10-13-2004, 08:49 AM   #5
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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
 
Old 10-13-2004, 09:16 AM   #6
Stryks
LQ Newbie
 
Registered: Oct 2004
Posts: 11

Original Poster
Rep: Reputation: 0
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.
 
Old 10-13-2004, 09:59 AM   #7
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
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.
 
Old 10-13-2004, 09:25 PM   #8
Stryks
LQ Newbie
 
Registered: Oct 2004
Posts: 11

Original Poster
Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL version 4 upgrade failed.... help gabriellai Linux - Enterprise 0 06-08-2005 10:50 AM
Upgrading MySQL version 3 to 4 RedHat / Fedora tommytomato Linux - Newbie 7 09-06-2004 07:37 AM
redhat fedora gcc version (compiled for 2.4.20) doesn't match kernel version 2.4.22 start1000 Linux - Software 0 03-16-2004 09:17 PM
Installing MySQL.4.0.17 and php support for Mysql on RedHat 9.0 Neha Linux - Software 13 12-29-2003 01:06 AM
problem between mysql and php ( new version 5) abd_bela Linux - Software 3 08-13-2003 06:32 PM


All times are GMT -5. The time now is 08:55 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration