MySQL command line tool function description

MySQL server-side Use tool program

1. mysqld-SQL Daemon (that is, the MySQL server process). The program must start running to connect to the server to access the database.
2. mysqld_safe-Server startup script, you can start the MYSQLD server through Mysqld_safe. Mysqld_safe adds some security features, such as restarting the server and writing run time information to the error day to the file when an error occurs.
3. mysql.server-Server startup script. The script is used to use a system that contains a running directory of scripts that run startup services for a specific level.
4. mysqld_multi-A server startup script that can start or stop multiple servers installed on the system.

MySQL Installation Related Programs

1. comp_err-Compile the MySQL error message file.
2. mysql_install_db-the script creates a MySQL authorization table with default permissions. This is usually done only once when MySQL is first installed on the system.
3. mysql_plugin-Configure the MySQL server plugin.
4. mysql_secure_installation-Improve the security of MySQL installation.
5. mysql_ssl_rsa_setup-Create a Ssl/rsa file.
6. mysql_tzinfo_to_sql-Load time zone table.
7. mysql_upgrade-Check and upgrade MySQL table.

MySQL Client Using tool program

1. mysql-MySQL command line tool.
2. mysqladmin-for managing MySQL server clients.
3. mysqlcheck-Table Maintenance Program.
4. mysqldump-Database Backup program.
5. mysqlimport-Data Import program.
6. mysqlpump-Database Backup program.
7. mysqlsh-Execute MySQL command under shell.
8. mysqlshow-Displays information about databases, tables, and columns.
9. mysqlslap-Load emulation client.

MySQL Program Development Tools

1. mysql_config-Compile the display options for the client.
2. my_print_defaults-Options for displaying options files.
3. resolve_stack_dump-Parse the digital stack trace dump to symbol.

MySQL Management Utility

1. innochecksum-Offline InnoDB file Verification tool.
2. myisam_ftdump-Displays full-text index information.
3. myisamchk-MyISAM Table Maintenance utility.
4. myisamlog-Displays the contents of the MyISAM log file.
5. myisampack-Generate compression, read-only MyISAM table.
6. mysql_config_editor-MySQL Configuration Utility.
7. mysqlbinlog-handles the utility of binary log files.
8. mysqldumpslow-Summarize slow query log files.

Miscellaneous procedures

1. lz4_decompress-Decompress mysqlpump lz4 compressed output.
2. perror-explains the error code.
3. replace-A string substitution tool.
4. resolveip-resolves host names to IP addresses or vice versa.
5. zlib_decompress-Decompress mysqlpump zlib compressed output.

Reference:

HTTPS://GITHUB.COM/JAYWCJLOVE/MYSQL-TUTORIAL/BLOB/MASTER/CHAPTER2/2.4.MD (the above content is transferred from this article)

MySQL command line tool function description (GO)