What Are the "mysqld" Command Line Options? - MySQL FAQs - Server Daemon mysqld Administration

"mysqld" offers a big list of command line options. Here are some commonly used options:

• "--help" - Displays a short help message on how to use "mysqld".
• "--verbose --help" - Displays a long help messages on how to use "mysqld".
• "--console" - Specifies that the server to send error messages to launching window.
• "--datadir=dirName" - Specifies that server data goes to the specified director.
• "--init-file=fileName" - Specifies that server to execute all commands in the specified file at startup time.
• "--log=fileName" - Specifies that server to write query logs to the specified file.
• "--log-bin=fileBaseName" - Specifies that server to write binary logs to a file with the specified file base name.
• "--log-error=fileName" - Specifies that server to write error logs to the specified file.
• "--port=portNumber" - Specifies that server to listen client connections at the specified port number.
• "--version" - Returns the version information of the server.