FRed writes:
> Hi Jani,
>
>
> Of course before ask to the mailling list I looked at manual (do you have a
> french version of it ?) ... and the only thing I found was
> "18.6 How to protect `/tmp/mysql.sock' from being deleted"
> Great but /tmp is a very special directory where all is deleted every night
> by ... ROOT ... with a rm -rf /tmp/* !!!!
> so I would like create the "/tmp/mysql.sock" in an another directory (I
> have changed the safe_mysqld) but when I did it this error occured :
> The error: Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (2) at ../bin/mysql_setpermission line 65, <STDIN>
> chunk 1.
>
> So my question should be : could I create the mysql.sock in a directory
> like /usr/local/mysql/tmp instead of /tmp ?
>
Hello Fred,
I'm very sorry, but we don't have a French version of the manual.
I hope that in the future someone skillful enough with French
could translate it.
You can start MySQL by mysqld --socket=/usr/local/mysql/tmp/mysql.sock
Then you'll have to give this option to your client
programs also. mysql --socket=/usr/local/mysql/tmp/mysql.sock and so on.
You can define some default variable values in .my.cnf in
your home directory, for example the socket file to be used.
You can find information about .my.cnf from the manual and
you have file named my-example.cnf in your MySQL distribution,
in 'support-files' -directory.
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
