So I've been trying to install MySQL 5 on Mac OS X 10.4.8 (using the
5.0 x686 installer) and everytime I exit out of the shell (or it might
be after I restart my computer), mysql.sock from /tmp keeps getting
deleted, which requires reinstalling mysql...How do I prevent this from
happening?

DC wrote:
> So I've been trying to install MySQL 5 on Mac OS X 10.4.8 (using the
> 5.0 x686 installer) and everytime I exit out of the shell (or it might
> be after I restart my computer), mysql.sock from /tmp keeps getting
> deleted, which requires reinstalling mysql...How do I prevent this from
> happening?

Edit the /etc/my.cnf file

[mysqld]
socket=/var/mysql/mysql.sock
[client]
socket=/var/mysql/mysql.sock

Cheers,
Mark Addinall.

addinall <EMAIL REMOVED> wrote:

> DC wrote:
> > So I've been trying to install MySQL 5 on Mac OS X 10.4.8 (using the
> > 5.0 x686 installer) and everytime I exit out of the shell (or it might
> > be after I restart my computer), mysql.sock from /tmp keeps getting
> > deleted, which requires reinstalling mysql...How do I prevent this from
> > happening?
>
> Edit the /etc/my.cnf file
>
> [mysqld]
> socket=/var/mysql/mysql.sock
> [client]
> socket=/var/mysql/mysql.sock

After all, files in /tmp are *SUPPOSED* to get deleted on restart. It is
called tmp for a reason - it is temporary. There have been operating
systems where /tmp wasn't even on physical disk, but was in ram.

--
Richard Maine | Good judgement comes from experience;
email: last name at domain . net | experience comes from bad judgement.
domain: summertriangle | -- Mark Twain

["Followup-To:" header set to comp.sys.mac.system.]
>> Edit the /etc/my.cnf file

No need to do this.


> After all, files in /tmp are *SUPPOSED* to get deleted on restart.

The OP's premiss is wrong: it's perfectly normal for mysql.sock to go
away, like any other unix socket. Its disappearance on reboot causes no
problems and for sure doesn't require reinstalling MySQL.

Richard Maine wrote:
> addinall <EMAIL REMOVED> wrote:
>
> > DC wrote:
> > > So I've been trying to install MySQL 5 on Mac OS X 10.4.8 (using the
> > > 5.0 x686 installer) and everytime I exit out of the shell (or it might
> > > be after I restart my computer), mysql.sock from /tmp keeps getting
> > > deleted, which requires reinstalling mysql...How do I prevent this from
> > > happening?
> >
> > Edit the /etc/my.cnf file
> >
> > [mysqld]
> > socket=/var/mysql/mysql.sock
> > [client]
> > socket=/var/mysql/mysql.sock
>
> After all, files in /tmp are *SUPPOSED* to get deleted on restart. It is
> called tmp for a reason - it is temporary.

NO SHIT! Hell, I must have missed that in the last 25 years
or so.

MySQL on BSD does some strange things, the socket is
one of them.

Mark Addinall.


> There have been operating
> systems where /tmp wasn't even on physical disk, but was in ram.
>
> --
> Richard Maine | Good judgement comes from experience;
> email: last name at domain . net | experience comes from bad judgement.
> domain: summertriangle | -- Mark Twain