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
[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.
Instructs the server to use standard ANSI SQL syntax, rather than MySQL syntax.
Specifies the base directory for MySQL installation.
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.
Specifies the IP address upon which the server is to ...