LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-22-2004, 03:46 PM   #1
coolamit78
Member
 
Registered: Aug 2003
Location: New Delhi, India
Distribution: RHEL AS 3/4, Windows XP
Posts: 546

Rep: Reputation: 31
problem with mySQL install


Hi...

I'm following the LAMPS tutorial...I downloaded mySQL 3.23.58 and first of all
I am confused about the following command in the tutorial

/usr/sbin/useradd mysql -g mysql -s /bin/false -d /home/mysql
scripts/mysql_install_db

Now I am not sure if the characters in bold are in continuation or a separate directory?, but this is how it appears in the tutorial

anyways, I gave the command

groupadd mysql

useradd mysql -g mysql -s /bin/false -d /home/mysql

Now, when i give ./configure, it gives me a seg-fault......what is probably wrong with this procedure?

---------------------

[root@amitmahajan mysql-3.23.58]# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
040423 1:08:34 ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h amitmahajan.homelinux.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@amitmahajan mysql-3.23.58]# Starting mysqld daemon with databases from /usr/local/mysql-3.23.58/data
./bin/safe_mysqld: line 284: 1880 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1
040423 01:08:35 mysqld ended

----------------------------------------------------------

Looking for some assistance...

amit
 
Old 04-22-2004, 03:53 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
you have downloaded a compiled, binary, version of mysql. If you wish to com,pile it your self you will need to revisit the mysql download page and select the source tarball (right at the bottom IIRC).
 
Old 04-23-2004, 12:03 AM   #3
coolamit78
Member
 
Registered: Aug 2003
Location: New Delhi, India
Distribution: RHEL AS 3/4, Windows XP
Posts: 546

Original Poster
Rep: Reputation: 31
Thanx for that info David...but, there's another question left answered in my first post..

Take a look at this command

/usr/sbin/useradd mysql -g mysql -s /bin/false -d /home/mysql
scripts/mysql_install_db

What is the correct path ??

1. -d /home/mysqlscripts/mysql_install_db ??

or is it supposed to be

2. -d /home/mysql/scripts/mysql_install_db ??


Pls suggest...

Regards,

amit
 
Old 04-23-2004, 02:22 AM   #4
coolamit78
Member
 
Registered: Aug 2003
Location: New Delhi, India
Distribution: RHEL AS 3/4, Windows XP
Posts: 546

Original Poster
Rep: Reputation: 31
Ok...I got over this confusion..The correct command is

useradd mysql -g mysql -s /bin/false -d /home/mysql

./scripts/mysql_install_db

However, mysql ends without any reason now...I get the following message:

/usr/local/mysql/current/bin/mysqld_safe
Starting mysqld daemon with databases from /home/mysql/data
040423 11:45:57 mysqld ended

Now unless the daemon keeps running, the subsequent commands wont work..what to do now?

Regards,

amit
 
Old 04-23-2004, 01:23 PM   #5
coolamit78
Member
 
Registered: Aug 2003
Location: New Delhi, India
Distribution: RHEL AS 3/4, Windows XP
Posts: 546

Original Poster
Rep: Reputation: 31
bump
 
Old 04-23-2004, 01:30 PM   #6
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
Check the permissions on the mysql data directory and the files within it - thye must be readable and writable by the mysql user.
 
Old 04-23-2004, 01:55 PM   #7
sixth_sense
Member
 
Registered: Mar 2004
Distribution: RedHat
Posts: 99

Rep: Reputation: 15
Hi amit ,


scripts/mysql_install_db - actualy creates a test database for ur db server. As i know its located on the main installation directory under /scripts . e.g: mysql-3.23.58/scripts

I would suggest you to do a source installation. and have a look on :

"Installing MySQL on Other Unix-like Systems" - of mysql documentation. they really provides with amazing documentation i have seen ever before.

Happy install.
 
Old 04-23-2004, 03:00 PM   #8
coolamit78
Member
 
Registered: Aug 2003
Location: New Delhi, India
Distribution: RHEL AS 3/4, Windows XP
Posts: 546

Original Poster
Rep: Reputation: 31
Thanx david...that did it!!!....I had forgotten to change ownership of the data folder to mysql...(sometimes one does forget small small things! )

Thanx to all who chipped in .....I'll be back with some more issues soon ..lol

Regards,

amit
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
MYSQL Install Problem. Help!! brokenflea Slackware 9 11-06-2004 03:22 AM
MySql Install Problem BlackShadow Linux - Software 2 10-01-2004 04:51 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM
MySql install problem PatC Linux - Newbie 1 07-02-2002 05:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:10 AM.

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