My. cnf configuration option for MySQL database 5.0

This section describes the configuration options of MySQL database 5.0, And the configuration options of my. cnf.

MySQL database 5.0 my. cnf configuration options Overview:

Mysqld Program-directory and file

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

Character-sets-dir = path indicates the directory where the character set is stored.

Datadir = path reads database files from a given directory.

Pid-file = filename specifies a file for the mysqld program to store the process ID (only applicable to UNIX/Linux systems). The Init-V script needs to end the mysqld process using the process ID in the file.

Socket = filename: Specifies a socket file for local communication between the MySQL client program and the server (only applicable to UNIX/Linux systems). The default setting is usually/var/lib/mysql. sock file ).

In Windows, if the MySQL client communicates with the server through the named pipe, the -- sock option gives the name of the named pipe (the default value is MySQL ).

Lower_case_table_name = 1/0 whether only lowercase letters are allowed for the new directory and data table names; this option is set to 1 by default in Windows (only lowercase letters are allowed ).

Mysqld Program-language settings

Character-sets-server = name default character Set of the new database or data table. To be compatible with earlier MySQL versions, you can use the -- default-character-set option for this character set. However, this option is outdated.

Collation-server = name default sorting method for new databases or data tables.

Lanuage = name: displays error information in the specified language.

Mysqld Program-communication, network, and information security

Enable-named-pipes allows customers and servers in Windows 2000/XP to communicate with each other using a named pipe (named pipe. The default name of this named pipeline is MySQL, but it can be changed using the -- socket option.

Local-infile [= 0] allows/disables the use of the load data local statement to process local files.

Myisam-recover [= opt1, opt2,...] automatically fixes all damaged MyISAM data tables at startup. There are four optional values for this option: DEFAULT, BACKUP, QUICK, and FORCE; they are the same as those of the myisamchk program.

Old-passwords uses the old algorithms in MySQL 3.23 and 4.0 to encrypt passwords in the mysql database (the new encryption algorithm introduced since MySQL 4.1 is used by default ).

Port = n specifies a TCP/IP communication port (usually port 3306) for the MySQL program ).

Safe-user-create is only available in mysql. only users with the INSERT permission on the user database table can use the GRANT command. This is a double-insurance mechanism (this user must also have the GRANT permission to execute the GRANT command ).

Shared-memory allows the use of memory (shared memory) for Communication (only applicable to Windows ).

Shared-memory-base-name = name indicates the name of the shared memory block (the default name is MySQL ).

Skip-grant-tables does not use the information in the mysql database for access control (warning: This will allow any user to modify any database ).

Skip-host-cache does not use the high-speed cache area to store the ing between host names and IP addresses.

Skip-name-resovle does not resolve the IP address to the host name. All checks related to access control (mysql. user data table) are performed through the IP address.

Skip-networking only allows a local connection through a socket file (Unix/Linux system) or a named pipe (Windows system), and does not allow an ICP/IP connection. This improves security, however, it blocks external connections from the network and all Java client programs (Java clients use TCP/IP even in local connections ).

User = name mysqld will be executed under a given UNIX/Linux account after the program is started; mysqld must be started from the root account before it can be switched to another account after the program is started; the mysqld_safe script uses the -- user = mysql option by default to start the mysqld program.

• 5 pages in total:
• Previous Page
• 1
• 2
• 3
• 4
• 5
• Next Page