"mysqld" Command Line Options in MySQL

Q

What Are the "mysqld" Command Line Options in MySQL?

✍: FYIcenter.com

A

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

 

Ways to Start MySQL Server in MySQL

What Is MySQL Server Daemon - mysqld in MySQL

Server Daemon mysqld Administration in MySQL

⇑⇑ MySQL Database Tutorials

2017-12-04, 1543🔥, 0💬