MySQL in a Nutshell

Name

mysqld

Synopsis

mysqld [options]

When mysqld is started, you can use various options. Although these options may be given on the command line, it’s common practice to enter them into a configuration file. On Unix-based systems, the main configuration file typically is /etc/my.cnf. For Windows systems, the main file is usually either c:\systems\my.ini or c:\my.conf. Options are entered on separate lines and follow a variable=value format. They are grouped under headings contained within square brackets. The mysqld daemon reads options from the configuration file under the headings of [mysqld] and [server] as it’s started. The following is an alphabetical list of options that apply to the mysqld daemon and an explanation of each. The options are shown as you would enter them from the command line. If an option is used in a configuration file, you should use the long form (not the dash with a single letter) and omit the double-dash prefix. For example, you could enter --basedir=/data/mysql from the command line. In a configuration file, though, you would enter basedir=/data/mysql on its own line.

--ansi

Instructs the server to use standard ANSI SQL syntax, rather than MySQL syntax.

--basedir= path , -b path

Specifies the base directory for MySQL installation.

--big-tables

Instructs the server to save temporary results sets to a file to solve errors where results are large and tables are said to be full.

--bind-address= address

Specifies the IP address upon which the server is to ...