All MySQL clients that communicate with the server using the
mysqlclient library use the following environment variables:
| The default socket; used for connections to |
|The default TCP/IP port|
|The default password|
|Debug-trace options when debugging|
|The directory where temporary tables/files are created|
MYSQL_PWD is insecure. See section 6.5 Connecting to the MySQL server.
The `mysql' client uses the file named in the
MYSQL_HISTFILE environment variable to save the command line history. The default value for the history file is `$HOME/.mysql_history', where
$HOME is the value of the
HOME environment variable. See section A Environment variables.
All MySQL programs take many different options. However, every MySQL program provides a
--help option that you can use to get a full description of the program's different options. For example, try
You can override default options for all standard client programs with an option file. section 4.15.4 Option files.
The list below briefly describes the MySQL programs:
myisamchkhas many functions, it is described in its own chapter. See section 15 Maintaining a MySQL installation.
ftp.tcx.sefor the convenience of other MySQL users.
mSQLprograms to MySQL. It doesn't handle all cases, but it gives a good start when converting.
mysqladmincan also be used to retrieve version, process and status information from the server. See section 14.3 Administering a MySQL server.
LOAD DATA INFILE. See section 14.5 Importing data from text files.
msql2mysql, but that has more general applicability as well.
replacechanges strings in place in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings. For example, this command swaps
bin the given files:
shell> replace a b b a -- file1 file2 ...
mysqlddaemon with some safety features, such as restarting the server when an error occurs and logging runtime information to a log file.