Ben Kennish wrote:
>
> HOORAY! It's finally working.
>
> However, I'd prefer to have my mysql.sock socket file in /tmp/
>
> Anyone know how to change the settings for MySQL (and also PHP4 and
> phpMyAdmin) so that it looks in /tmp/ instead?
>
> Cheers.
>
> Ben
>
> Rick Emery wrote:
> >
> > I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have
> > permissions set to: drwxr-xr-x
> >
> > This cured the problem for me.
> >
> > rick
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 01, 2001 6:19 AM
> > To: Ben Kennish
> > Cc: [EMAIL PROTECTED]
> > Subject: Antwort: PHP and MySQL
> >
> > On 01.03.2001 11:55:40 Ben Kennish wrote:
> >
> > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > > through socket '/var/lib/mysql/mysql.sock' (111) in
> > > /var/www/html/index.php on line 5"
> >
> > Are you sure that your MySQL installation creates the socket right there?
> > If
> > I'm not mistaken, it may be created in /tmp.
> >
> > ---------------------------------------------------------------------
> > 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
> >
> > ---------------------------------------------------------------------
If you are running Red Hat Linux, you don't want the socket in /tmp.
The nightly cleanup daemon will delete it eventually.
You can tell mysqld and mysql wher the socket is by including entries in
/etc/my.cnf ( See the manual)
For PHP, you can probably put it in your connect routine.
> > 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
>
> --
> Ben Kennish
>
> Software Developer
> Fubra Limited
>
> web | www.fubra.net
> email | [EMAIL PROTECTED]
> phone | +44 (0)870 1222 600
> fax | +44 (0)870 1222 699
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
