Complete the MySQL command prompt procedure

The following articles mainly describe the MySQL Command Prompt program and constantly improve the actual operation process. If you do not understand the actual operation process of the MySQL Command Prompt program, you can understand it through our article. The following is the main content of the article.

MySQL server and server startup script:

MySQLd is a MySQL Server

For example, MySQLd -- skip-grant-tables is used to start MySQL in non-Security Authentication mode.

MySQLd -- verbose -- help MySQL Command Format help

MySQLd -- console MySQL server console

MySQLd_safe, MySQL. server, and MySQLd_multi are server startup scripts.

MySQL_install_db initialize the data directory and initial database

Client Program accessing the server:

MySQL is a command line client program used to execute SQL statements in interactive or batch processing mode.

MySQLadmin is a client program used for management.

MySQLcheck performs table maintenance.

MySQLdump and MySQLhotcopy are responsible for database backup.

MySQLimport imports data files.

MySQLshow displays information about databases and tables.

Tool programs independent of server operations:

Myisamchk performs table maintenance.

Myisampack generates compressed and read-only tables.

MySQLbinlog is a utility used to process binary log files.

Perror indicates the meaning of the error code.

The above content is an introduction to the MySQL Command Prompt program. I hope you will have some gains.

MySQL Command Prompt program, constantly improving ......