Overview of various MySQL client environment variable programs

All MySQL customers using the Mysqlclient client library to communicate with the server use the following environment variables:

It is not safe to use MYSQL_PWD. See 6.3 Connection to the MySQL server.

The "MySQL" Customer uses the file named in the Mysql_histfile environment variable to hold the command line history, the default value of the history file is "$HOME/.mysql_history", where $home is the value of the home environment variable.

All MySQL programs take many different options, however, each MySQL program provides a--help option that you can use to get a complete description of the different options for the program. For example, try a MySQL--help.

You can override the default options for all standard client programs with an option file. See 4.15.4 Select File.

The following table briefly describes the MySQL program:

Myisamchk

Describes, examines, optimizes, and fixes the use of MySQL tables. Because Myisamchk has many functions, it is described in its own chapters. See 13 Maintenance MySQL installation.

Make_binary_release

Make a binary version of compiling MySQL. This can be sent to the "/pub/mysql/incoming" on the ftp.tcx.se website using FTP to facilitate other MySQL users.

Msql2mysql

A shell script that converts msql programs to MySQL. It cannot handle all situations, but when converting it gives a good starting point.

Mysql

MySQL is a simple SQL shell (with GNU readline capabilities) that supports both interactive and non-interactive use. When used interactively, the query results are represented in an ASCII table format. When used interactively (for example, as a filter), the result is represented in a format delimited by the locator character. (output format can be changed using command-line options) you can simply run the script like this:

shell> MySQL Database < script.sql > Output.tab

Use the--quick option if you are a problem in your account due to insufficient memory! This forces MySQL to retrieve the result collection using Mysql_use_result () rather than Mysql_store_result ().

Mysqlaccess

A script that examines access to the host, user, and database combinations.

Mysqladmin

Utilities that perform administrative actions, such as creating or discarding databases, loading authorization tables, cleaning tables to disk, and then opening log files. Mysqladmin can also be used to retrieve version, process, and status information from the server. See 12.2 Managing a MySQL server.

Mysqlbug

MySQL Error reporting script. When you fill out an error report to the MySQL mailing list, you should always use the script.

Mysqld

SQL Daemon. It should be running all the time.