Description
This section includes an overview of the various MySQL Programs.
The following table lists some of the server related programs for MySQL:
| Program | Description |
|---|---|
| mysqld | This is the MySQL server, which is the main program for MySQL |
| mysqld_safe | A server startup script which attempts to start
mysqld. This is the recommended method for starting the MySQL server on Unix as it provides restart and logging mechanisms
|
| mysql.server | A server startup script used on systems that use System V-style run directories that contain scripts that start system services for particular run levels. This script evenually calls
mysqld_safe to start the server
|
| mysqld_multi | This program is used to manage multiple mysqld processes. It can be used to start or stop servers, or report their current status |
The following table lists some of the installation related programs for MySQL:
| Program | Description |
|---|---|
| comp_err | This program creates the errmsg.sys file for mysqld and is used to determine the error message to display for different error codes
|
| mysq_install_db | This program is used to initialize the MySQL data directory and creates the necessary system tables |
| mysql_secure_ installation |
Improves the security of MySQL by:
|
| mysql_tzinfo_ to_sql |
Allows the loading of time zone tables in the MySQL database |
| mysql_upgrade | Allows checking of tables in all databases for incompatibilities with the current version |
The following table lists some of the client related programs for MySQL:
| Program | Description |
|---|---|
| mysql | This is the MySQL command-line tool |
| mysqladmin | This program is a client used to perform administrative operations. It can be used to check the server's status, configuration, manage tables, etc |
| mysqlcheck | This program is a client that can be used to perform table maintenance by analyzing, optimizing, or repairing them |
| mysqldump | Used to dump a MySQL database for backup or transfer to another server |
| mysqlimport | Used to import data into the MySQL database |
| mysqlshow | A client program that can be used to show databases, tables, table columns, or indiexes. |
The following table lists some of the administrative / utilty related programs for MySQL:
| Program | Description |
|---|---|
| mysqlaccess | This program is a diagnostic tool that checks the access privileges for a host name, user name, and database combination |
| mysqlbinlog | This program is used to display the contents of the binary log files contents in text format |
| mysqlbinlog | This program is used to display the contents of the binary log files contents in hex dump format |