LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
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 07-29-2003, 05:53 PM   #1
IceGrill
LQ Newbie
 
Registered: Jan 2002
Distribution: Mandrake
Posts: 25

Rep: Reputation: 15
can't start mysql daemon


I'm running Red Hat 9

I downloaded the binaries for mysql 4.0.14 and installed them to /usr/local/mysql

The mysql client works fine, and at one point i had both the server and client running and actually working, however now i cannot start the mysql daemon.

When the current directory is set to /usr/local/mysql/bin i try typing:
./safe_mysqld

the console reponds with:
Starting mysqld daemon with databases from /var/lib/mysql
##### HH:MM:SS mysqld ended

the #'s are the pid and HMS is a time stamp.

can anyone tell my why my mysql server stops running as soon as i start it?

thx
 
Old 07-29-2003, 06:14 PM   #2
neo77777
LQ Addict
 
Registered: Dec 2001
Location: Brooklyn, NY
Distribution: *NIX
Posts: 3,704

Rep: Reputation: 55
Ok try this, make sure there is mysql user on your system, the entry in my /etc/passwd looks like this
mysql:x:27:27:MySQL:/var/lib/mysql:
check that /var/lib/mysql is owned by mysql user
and start it up as root with
cd /usr/local/mysql
./bin/safe_mysqld --user=mysql &
 
Old 07-29-2003, 06:46 PM   #3
finegan
Guru
 
Registered: Aug 2001
Location: Dublin, Ireland
Distribution: Slackware
Posts: 5,700

Rep: Reputation: 57
If the whole thing is installed in /usr/local, then check for the error log file in /usr/local/var/lib/mysql/$HOSTNAME.err

There's also a options you can add to my.cnf to crank up the chatiness of that error log.

Cheers,

Finegan
 
Old 07-29-2003, 08:16 PM   #4
IceGrill
LQ Newbie
 
Registered: Jan 2002
Distribution: Mandrake
Posts: 25

Original Poster
Rep: Reputation: 15
YES!!! Thanks for the help! I followed both your suggestions and using the error log file fixed the problem. There were mysqld process that were running and not responding.

Apparently, the mysqld daemon has decided to use a socket that the mysql client and mysqladmin aren't using...grr.

thx again
 
  


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
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 07:23 AM
MySQL Daemon doesn't run stedo Debian 1 11-23-2005 09:07 AM
"mysqld ended" when trying to start mysql daemon guarriman Linux - General 1 01-19-2005 08:35 AM
Mysql daemon error Drogo Linux - Software 5 10-22-2004 03:17 PM
Starting Up MySQL daemon tuka Linux - Software 2 08-06-2003 12:45 PM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration