Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - "mysqld" Command Line Options

By: FYIcenter.com

(Continued from previous topic...)

What Are the "mysqld" Command Line Options?

"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.

(Continued on next topic...)

1. What Is the MySQL Server Daemon - mysqld?
2. What Are the "mysqld" Command Line Options?
3. How To Start MySQL Server Daemon mysqld?
4. How To Properly Shutdown MySQL Server Daemon mysqld?
5. How Much Memory Does the Server Take?
6. How To Turn on Query Logs?
7. How To Turn on Error Logs?
8. What Is Binary Log File?
9. How To Turn on Binary Logs?
10. How To Use mysqlbinlog to View Binary Logs?
11. How To Run MySQL Server on a Different Port?
12. How To Connect to MySQL Server on a Different Port?