MySQL configuration file Basic parameters detailed

# The following options will be read by the MySQL client application.

# Note Only the client application included with MySQL guarantees that this content can be read.

# If you want your own MySQL application to get these values

# You need to specify these options when the MySQL client library is initialized

#

[Client]

#password = [Your_password]

Port = @MYSQL_TCP_PORT @

Socket = @MYSQL_UNIX_ADDR @

# MySQL Service Side

[Mysqld]

# General configuration Options

Port = @MYSQL_TCP_PORT @

Socket = @MYSQL_UNIX_ADDR @

# Back_log is the number of connections the operating system can hold in the listening queue.

# The queue holds the connection before the MySQL Connection Manager thread is processed.

# If you have a very high connection rate and ' connection refused ' error,

# You should add the value here.

# Check your operating system documentation to get the maximum value for this variable.

# If you set the Back_log to a higher value than your operating system, there will be no effect.

Back_log = 50

# Do not listen on TCP/IP ports.

# If all the processes are connected to the local mysqld on the same server,

# This setting will be the way to enhance security

# All MYSQLD connections are made through UNIX sockets or named pipes.

# Note that if you do not open the Named pipe option on Windows, you only use this item

# (through the "enable-named-pipe" option) will cause the MySQL service to have no effect!

#skip-networking

# The maximum number of simultaneous sessions allowed by the MySQL service

# One of the connections will be reserved by super privileges as an administrator.

# even if the number of connections has reached the upper limit.

max_connections = 100

# The maximum number of error allowed per client connection, if this limit is reached.

# This client will be blocked by the MySQL service until the "FLUSH HOSTS" or service reboot is performed.

# an illegal password and other errors at the time of the link increase this value.

# View the "aborted_connects" status to get the global counter.

Max_connect_errors = 10

# Number of tables opened by all threads.

# Increasing this value increases the number of file descriptors required for mysqld

# so you need to make sure that the "open-files-limit" variable set in [Mysqld_safe] has a minimum number of open files allowed at least 4096