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 05-08-2004, 03:45 AM   #1
mairul
Member
 
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 failed..now I want some hint on mysql installation and configuration..at 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 option..so 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, 04:16 AM   #2
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,275

Rep: Reputation: 370Reputation: 370Reputation: 370Reputation: 370
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, 04:25 AM   #3
mairul
Member
 
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...

creating libmysqlclient.la
(cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la libmysqlclient.la)
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 mysql.cc
/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/libmysqlclient.la -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/libmysqlclient.so -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, 05:30 AM   #4
Demonbane
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, 06:09 AM   #5
Boby
Member
 
Registered: Feb 2004
Location: Sighisoara/Cluj-Napoca (Romania)
Distribution: CentOS 4, Fedora Core 6
Posts: 781

Rep: Reputation: 31
hello

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!

boby
 
Old 05-28-2004, 03:49 PM   #6
fleeingduck
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?

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

Original Poster
Rep: Reputation: 15
type "mysql -p -h 127.0.0.1"
 
Old 06-02-2004, 06:51 AM   #8
Looking_Lost
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

/usr/local/mysql/tmp

which user and group mysql owns.

Maybe help...
 
  


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


All times are GMT -5. The time now is 04:31 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