Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 07-29-2003, 04:53 PM   #1
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:

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?

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

Rep: Reputation: 56
Ok try this, make sure there is mysql user on your system, the entry in my /etc/passwd looks like this
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, 05:46 PM   #3
LQ Guru
Registered: Aug 2001
Location: Dublin, Ireland
Distribution: Slackware
Posts: 5,700

Rep: Reputation: 72
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.


Old 07-29-2003, 07:16 PM   #4
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


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

All times are GMT -5. The time now is 05:43 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
Open Source Consulting | Domain Registration