Overview of various MySQL customer environment variable programs [figure] all MySQL customers who use the mysqlclient client library to communicate with the server use the following environment variables:
Using MYSQL_PWD is insecure. See connection to MySQL server in MySQL 6.3.
"Mysql" uses the file named in the environment variable MYSQL_HISTFILE to save the command line history. The default value of the historical file is "$ HOME /. mysql_history ", here $ HOME is the value of the HOME environment variable.
All MySQL programs take many different options. However, each MySQL program provides a -- help option, which you can use to get a complete description of different options of the program. For example, try mysql -- help.
You can use an option file to override the default options of all standard customer programs. See 4.15.4 select a file.
The following table briefly describes the MySQL program:
Myisamchk
Describes, checks, optimizes, and fixes MySQL table applications. Because myisamchk has many features, it is described in its own chapter. See 13 maintain MySQL installation.
Make_binary_release
Compile a binary version of MySQL. This can be transmitted over FTP to "/pub/mysql/Incoming" on the ftp. tcx. se website to facilitate other MySQL users.
Msql2mysql
A shell script to convert the mSQL program to MySQL. It cannot handle all the situations, but it provides a good starting point for conversion.
Mysql
Mysql is a simple SQL shell (with GNU readline capability) that supports interactive and non-interactive use. When used in interactive locations, the query results are displayed in the ASCII table format. When used in non-interactive mode (for example, as a filter), the result is expressed in a format separated by positioning characters. (You can use the command line option to change the output format.) you can run the script as follows:
Shell> mysql database <script. SQL> output. tab
If you are experiencing problems due to insufficient memory, use the -- quick option! This forces mysql to use mysql_use_result () instead of mysql_store_result () to retrieve the result set.
Mysqlaccess
A script that checks the access permissions on the host, user, and database combinations.