mysqld won't start if it can't create the socket, so if mysqld is
running, you've got a socket somewhere. Once you find out where, you
can fix your connection problem by setting the appropriate path in your
php script.
I don't think you need a fresh install.
Michael
[EMAIL PROTECTED] wrote:
Ok, thanks all.
I believe I need a fresh installation.
What I do get is why running 'mysqladmin -variables' reports the
location of mysql.sock and there seems to be no mysql.sock anywhere on
this machine! Not in /tmp not /var/mysql (where it says it is).
Gil
On May 29, 2005, at 1:59 PM, Philip George wrote:
one of the posts at the bottom of one of those pages mentions that
the permissions on the sock file might not be right.
mine is:
srwxrwxrwx 1 mysql wheel 0 29 May 06:41 mysql.sock
you probably already know all this, but just in case... to get those
permissions set up:
<stop mysqld>
chown mysql:wheel /tmp/mysql.sock
chmod 4777 /tmp/mysql.sock
<restart mysqld>
- philip
On May 29, 2005, at 12:33 PM, Philip George wrote:
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html
search them both for '2002' (multiple instances on one of the pages).
there a couple suggestions for things to try.
hth.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
