Server Command Options Default Value parent of mysqld installation directory The path to the MySQL installation directory. This option sets the  basedir  system variable. The server executable determines its own full path name at startup and uses the parent of the directory in which it is located as the default  basedir  value. This in turn enables the server to use that  basedir when searching for server-related information such as the  share  directory containing error messages. Do not ignore character set information sent by the client. To ignore client information and use the default server character set, use  --skip-character-set-client-handshake ; this makes MySQL behave like MySQL 4.0. • --character-set-client-handshake • --chroot= dir_name ,  -r  dir_name • --console • --core-file Write a core file if  mysqld  dies. The name and location of the core file is system dependent. On Linux, a core file named  core. pid  is written to the current working directory of the process, which for  mysqld is the data directory.  pid  represents the process ID of the server process. On macOS, a core file named (Windows only.) Cause the default error log destination to be the console. This affects log sinks that base their own output destination on the default destination. See Section 5.4.2, “The Error Log” .  mysqld does not close the console window if this option is used. --console  takes precedence over  --log-error  if both are given. Put the  mysqld  server in a closed environment during startup by using the  chroot()  system call. This is a recommended security measure. Use of this option somewhat limits  LOAD DATA  and  SELECT ... INTO OUTFILE . Command-Line Format --character-set-client- handshake[={OFF|ON}] Type Boolean Default Value ON Command-Line Format --chroot=dir_name Type Directory name Command-Line Format --console Platform Specific Windows Command-Line Format --core-file[={OFF|ON}] Type Boolean Default Value OFF 735