Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 05-08-2004, 02:45 AM   #1
Registered: Sep 2003
Location: In front of my LAN
Distribution: Redhat
Posts: 82

Rep: Reputation: 15
mysql installation

I am going to install mysql at my redhat 9. I have downloaded the "mysql-3.23.37.tar.gz" file. Now I know that I have to untar this file ..then have to run ./configure make and make install....but previously I have tried it and I want some hint on mysql installation and which directory I should untar the "mysql-3.23.37.tar.gz" file....cause I have seen some manual that I have to do something at /usr/local/src directory...please note that at the time of my redhat installation I omit the sql server there is no rpm file of mysql is installed...I will just install a fresh .tar.gz file...

Please someone give me some hints on mysql installtion and configuration...

Old 05-08-2004, 03:16 AM   #2
Senior Member
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,284

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
It doesn't really matter what directory you build the software in. Putting sources for things you install into /usr/local/src is just a convention on some systems. Why don't you just install MySQL via RPM? There are RPMs available for RH9 and I believe they have version 4.0. If you're going to install from source, you may as well get the latest version (I am using the 4.1 alpha series in a production environment and they are quite stable -- 4.1 is the first version I believe with subqueries).
Old 05-08-2004, 03:25 AM   #3
Registered: Sep 2003
Location: In front of my LAN
Distribution: Redhat
Posts: 82

Original Poster
Rep: Reputation: 15
I have put the "mysql-3.23.37.tar.gz" at /usr/src directory..then run...

[root@pc3 src]#gunzip mysql-3.23.37.tar.gz
[root@pc3 src]#tar -xvf mysql-3.23.37.tar
[root@pc3 src]#cd mysql-3.23.37
[root@pc3 src]#./configure --prefix=/usr/local/mysql
[root@pc3 src]#make

after that my "make" command stop with the following error...

(cd .libs && rm -f && ln -s ../
make[2]: Leaving directory `/usr/src/mysql-3.23.37/libmysql'
Making all in client
make[2]: Entering directory `/usr/src/mysql-3.23.37/client'
c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -fno-implicit-templates -c
/bin/sh ../libtool --mode=link c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/ -lz -lcrypt -lnsl -lm
c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/.libs/ -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib/mysql
mysql.o(.text+0x1858): In function `com_source(String*, char*)':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory `/usr/src/mysql-3.23.37/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/mysql-3.23.37'
make: *** [all-recursive-am] Error 2

please help..
Old 05-08-2004, 04:30 AM   #4
LQ Guru
Registered: Aug 2003
Location: Sydney, Australia
Distribution: Gentoo
Posts: 1,796

Rep: Reputation: 47
Save yourself the trouble and download the RPMs.
Old 05-08-2004, 05:09 AM   #5
Registered: Feb 2004
Posts: 781

Rep: Reputation: Disabled

this is what you have to do:

copy youre mysql-3.23.37.tar.gz file to /usr/local/
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /usr/local/mysql-3.23.37.tar.gz | tar xvf -
shell> ln -s /usr/local/<new created directory> mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

after you unpack youre tar.gz file, search in the new created directory for a install.txt file. there you find more info.

i hope this helps!

Old 05-28-2004, 02:49 PM   #6
LQ Newbie
Registered: May 2004
Distribution: Slackware
Posts: 4

Rep: Reputation: 0
I am using Slackware 9. kernel 2.4.22. I have selected the mysql package during the install. mysqld claims to successfully start, but then quickly ends. I have verified the existance of the mysql user and group, as illustrated above. Any hints?

Old 06-02-2004, 04:28 AM   #7
Registered: Sep 2003
Location: In front of my LAN
Distribution: Redhat
Posts: 82

Original Poster
Rep: Reputation: 15
type "mysql -p -h"
Old 06-02-2004, 05:51 AM   #8
Senior Member
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
If mysqld is starting then bombing out immediately leaving it not running again you could check that the mysql user has permissions to read/write to the directory that mysql.sock has been set to. You can get this location from /etc/my.cnf usually

I don't use the slackware packages but compiled from source and set my socket directory to


which user and group mysql owns.

Maybe help...


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-installation: Not enough space in /var/lib/mysql/ linus123 Linux - Software 8 11-10-2006 02:19 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
Mysql installation yussef Linux - Software 1 06-13-2005 11:49 AM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 12:46 AM
php4 mysql, installation, php-pages with mysql info stay empty dnla Linux - Software 2 03-14-2004 02:54 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:25 PM.

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