Re: mysql.sock doesn't exist

[Sean Macmillan]

I posted to this thread yesterday indicating that I had the same 
problem.  After playing with it some more I realized that I was not 
starting MySQL with the appropriate user/group.  As mentioned below, 
the user has to have write permissions to this directory in order to 
create the unix domain socket...hence why just issuing the command 
'touch mysql.socket" failed, dumb idea now that I look back on it.

Hope this helps.

On Friday, June 27, 2003, at 07:17 AM, Brian Austin wrote:

OK.....

I sent to you once on the list, and to the original poster, but it was
returned from his email server (who knows).
Here it goes.

The most probable reason reason that file is not there is permissions. 
 When
mysqld starts (under user mysql or mysqld) it writes the file in the
directory specified by the my.cnf file.  If the my.cnf file says
path-to-unix-sock=/var/lib/mysql/mysql.sock, the user that is starting 
the
server has to have write permissions in that directory.  Otherwise it 
will
not create the file and die.  Make sure that the user who starts the 
server
has write permissions in the directory.  A simple ls -l will tell you. 
 I
hope this can fix your problem, it seems you've been stuck on this 
quite a
while.

Good Luck

Brian

-----Original Message-----
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 8:25 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything at all so 
this
*is* an odd predicament.  Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?

Kevin



John Nichel wrote:
It doesn't look as if you have any conflicting MySQL versions.  When 
the
server is running, have you looked for the socket (someone may have
already asked you this, but I'm running out of ideas)?

find / -name mysql.sock

mysql.sock isn't a 'file' in the normal sense of the word.  It's more
like a symbolic link to the socket which is bound to the the port MySQL
is listening on (so to speak).  It can't really be sent to you, as it
has to be generated when the server starts up.  Let me recap what we've
done here so that hopefully someone will reconize the problem for 
you...

MySQL is running (verified with a ps -ax)
mysql.sock does not exist
cannot shutdown server, even as root
What's the permissions on the /var/lib/mysql directory, and what
user/group is the mysql daemon set to run as in your my.cnf file?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]