(003) mysqld command line Options

Fundamentals of the ten-year OPS series-MySQL

Zeng Lin

Contact: [Email protected]

Website: www.jplatformx.com

Copyright: Please do not reprint the article without permission

First, Introduction

MYSQLD is the MySQL server. This section highlights the command-line options for mysqld. Before you introduce, you need to understand what command-line options are.

#mysqld--verbose--help

The table above is running the MYSQLD server program under the Linux shell, where verbose and help are command-line options. The following table command accomplishes the same functionality, but its command-line options are V and?.

#mysqld-V-?

There are two types of representations for command-line options. One is "-Full name", the other is "-short". The results of both representations run the same way.

Second, command-line options

--skip-grant-tables: This option causes the server to not use the permission system. This option is usually used because the user name or password is forgotten. This permission allows the user accessing the server unrestricted access to all databases.

(003) mysqld command line Options