Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "mysql client and server common utility functions", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what are the common utility functions of mysql client and server" this article.

1. MySQL server-side utility program:

1. Mysqld:SQL daemon (that is, MySQL server process), through which the client connects to the server to access the database.

2. Mysqld_safe: service startup script. Mysqld_safe adds some security features, such as restarting the server when an error occurs and writing log information to the error log.

3. Mysql.server: service startup script. Start the mysql server by calling mysqld_safe.

4. Mysql_multi: a service startup script that can start or stop multiple services installed on the system.

5. Myisamchk: a usage tool for describing, checking, optimizing, and maintaining MyISAM tables.

6. Mysqlbug: a defect report script that can be used to send defect reports to the mysql mail system.

7. Mysql_install_db: used to create MySQL authorization tables with default permissions, usually only once when MySQL is installed on the system for the first time.

2. MySQL client utility program:

1. Myisampack: used to compress MyISAM tables to produce smaller read-only tables.

2. Mysql: interactive SQL command line tool.

3. Mysqlaccess: a script used to check the host name, user name, and database combination permissions to access the host.

4. MySQLadmin: a client tool that performs administrative operations.

5. Mysqlbinlog: used to read operation records from binary logs. Read the executed statements contained in the binary log file to help the system recover from the crash.

6. Mysqlcheck: table maintenance client program for checking, repairing, analyzing and optimizing tables.

7. Mysqldump: a client tool that dumps an MySQL database to a file, such as an SQL statement or a tab-delimited text file.

8. Mysqlhotcopy: a tool to quickly back up MyISAM or ISAM tables while the server is running.

9. Mysql import: a client tool that uses LOAD DATA INFILE to import text files into related tables.

10. Mysqlshow: a client tool that displays information about databases, tables, columns, and indexes.

11. Perror: a tool that displays the meaning of a system or MySQL error code.

The above is all the contents of the article "what are the common utility functions of mysql client and server?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.