----- Original Message -----
From: "Matt Hargraves" <[EMAIL PROTECTED]>
To: "Phil Dobbin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 8:39 PM
Subject: Re: Fw: Problem starting server
> Been there, done that. Didn't change a thing.
>
> [root@server mysql]# safe_mysqld
> Starting mysql daemon with databases from /var/lib/mysql
> 020527 02:26:27 mysql ended
>
> Both statements ('Starting...' and '0205...') pop up within a tenth
> of a second of each-other and when I check processes, there is
> nothing that starts with 'my' running.
>
> Does that help?
Been there, had that done to me too. :)
I had compiled MySQL with innodb support; but you specifically need to
confige that in your /etc/my.cnf before mysqld will run. When I ran
safe_mysqld the first time, it immediately exited too. So, I added,
"skip-innodb"
(without the quotes, of course), to my /etc/my.cnf, and it ran like a charm
ever since. :)
You have given us too little information about your setup (you may actually
wanna use innodb, for instance), but it is worth checking out.
P.S. As for your MySQL client saying,
error: 'Can't connect to MySQL server through the socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
You may wanna make sure the new compile actually places the sock in
/var/lib/mysql/, and not in /tmp/ (the latter is default, I believe). As you
were about to check your /etc/my.cnf anyway, you may look into that too.
- Mark
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
