MY.CNF Database Parameters Detailed

The/etc/my.cnf file is a MySQL configuration file, which is detailed in the following sections:

[mysqld] //server-side configuration

Datadir=/data/mysql//Data Catalog

Socket=/var/lib/mysql/mysql.sock//socket Communication settings

User=mysql//start with MySQL user

# Disabling Symbolic-links is recommended to prevent assorted security risks

Symbolic-links=0//Whether shortcuts are supported

log-bin=mysql-bin //Turn on Bin-log log

Server-id = 1//mysql Service ID

Auto_increment_offset=1//Field growth

auto_increment_increment=2//Field growth

[Mysqld_safe] //mysql service Secure Boot Configuration

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

Replicate-do-db =jfedu//allow slave to sync which library

Note:

Basedir = path # uses the given directory as the root directory (the installation directory).

DataDir = path # reads the database file from the given directory.

Pid-file = filename # Specifies a file that holds the process ID for the MYSQLD program (only for Unix/linux systems);

Socket =/tmp/mysql.sock # Specifies a socket file for local communication between the MySQL client and server (the default is/var/lib/mysql/mysql.sock file under Linux)

MY.CNF Database Parameters Detailed