Shulou(Shulou.com)06/01 Report--

/ etc/my.cnf file is the configuration file of mysql. The details are as follows:

[mysqld] / / Server-side configuration

Datadir=/data/mysql / / data directory

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

User=mysql / / launched by the mysql user

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

Symbolic-links=0 / / whether shortcuts are supported

Log-bin=mysql-bin / / enable 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 security startup configuration

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

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

Replicate-do-db = jfedu / / which library is allowed for slave to synchronize

Note:

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

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

Pid-file = filename # specifies a file for the mysqld program to store the process ID (for UNIX/Linux systems only)

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.