MySQL - Log And Status Files

The server creates several status files. Some of these are located in the data directory by default, but not all.

The default PID filename is host_name.pid in the data directory. The name and location may be changed with the —pid-file=file_name option.

The default socket file is /tmp/mysql.sock. A different filename can be specified by starting the server with the —socket option. If you change the location, client programs also need to be started with the same —socket option so that they know where the socket file is located.