(mysql.info.gz) Problems with mysql

Info Catalog

(mysql.info.gz) Temporary files

(mysql.info.gz) Administration Issues

(mysql.info.gz) Timezone problems

 
 A.4.5 How to Protect or Change the MySQL Socket File `/tmp/mysql.sock'
 ----------------------------------------------------------------------
 
 The default location for the Unix socket file that the server uses for
 communication with local clients is `/tmp/mysql.sock'.  This might
 cause problems, because on some versions of Unix, anyone can delete
 files in the `/tmp' directory.
 
 On most versions of Unix, you can protect your `/tmp' directory so that
 files can be deleted only by their owners or the superuser (`root').
 To do this, set the `sticky' bit on the `/tmp' directory by logging in
 as `root' and using the following command:
 
      shell> chmod +t /tmp
 
 You can check whether the `sticky' bit is set by executing `ls -ld
 /tmp'.  If the last permission character is `t', the bit is set.
 
 Another approach is to change the place where the server creates the
 Unix socket file. If you do this, you should also let client programs
 know the new location of the file.  You can specify the file location
 in several ways:
 
    * Specify the path in a global or local option file.  For example,
      put the following lines in `/etc/my.cnf':
 
           [mysqld]
           socket=/path/to/socket
 
           [client]
           socket=/path/to/socket
       Option files.
 
    * Specify a `--socket' option on the command line to `mysqld_safe'
      and when you run client programs.
 
    * Set the `MYSQL_UNIX_PORT' environment variable to the path of the
      Unix socket file.
 
    * Recompile MySQL from source to use a different default Unix socket
      file location.  Define the path to the file with the
      `--with-unix-socket-path'  option when you run `configure'.  
      `configure' options configure options.
 
 
 You can test whether the new socket location works by attempting to
 connect to the server with this command:
 
      shell> mysqladmin --socket=/path/to/socket version
 

Info Catalog

(mysql.info.gz) Temporary files

(mysql.info.gz) Administration Issues

(mysql.info.gz) Timezone problems