This section lists all the environment variables that are used
directly or indirectly by MySQL. Most of these can also be found
in other places in this manual.
Note that any options on the command line take precedence over
values specified in option files and environment variables, and
values in option files take precedence over values in environment
variables.
Warning: Debian Backports is currently (as of 30th of July 2006) offering version 5.0.22-Debian_2bpo1-log which has a severe problem with handling the MYSQL_HISTFILE.
The manual-page says:
---8<--- On Unix, the mysql client writes a record of executed statements to a history file. By default, the history file is named .mysql_history and is created in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable.
If you do not want to maintain a history file, first remove .mysql_history if it exists, and then use either of the following techniques:
o Set the MYSQL_HISTFILE variable to /dev/null. To cause this setting to take effect each time you log in, put the setting in one of your shell's startup files.
o Create .mysql_history as a symbolic link to /dev/null:
shell> ln -s /dev/null $HOME/.mysql_history You need do this only once. --->8---
BOTH POSSIBILITIES ARE BROKEN! THEY BOTH DELETE /dev/null !!! Be warned. I really mean it. A damaged /dev/null brakes your server.
User Comments
The table gives information about Variable & Description. Can we have another column "Possible Values" for each variable.
Also, if you can add the advantages of each of the variables, that might e of great help.
In cygwin, invoking mysql via a shell script disabled the mysql command line history.
Warning: Debian Backports is currently (as of 30th of July 2006) offering version 5.0.22-Debian_2bpo1-log which has a severe problem with handling the MYSQL_HISTFILE.
The manual-page says:
---8<---
On Unix, the mysql client writes a record of executed statements to a
history file. By default, the history file is named .mysql_history and
is created in your home directory. To specify a different file, set the
value of the MYSQL_HISTFILE environment variable.
If you do not want to maintain a history file, first remove
.mysql_history if it exists, and then use either of the following
techniques:
o Set the MYSQL_HISTFILE variable to /dev/null. To cause this setting
to take effect each time you log in, put the setting in one of your
shell's startup files.
o Create .mysql_history as a symbolic link to /dev/null:
shell> ln -s /dev/null $HOME/.mysql_history
You need do this only once.
--->8---
BOTH POSSIBILITIES ARE BROKEN! THEY BOTH DELETE /dev/null !!!
Be warned. I really mean it. A damaged /dev/null brakes your server.
Alex.
Resources:
http://www.bloglines.com/blog/ITnomad?id=125
Add your own comment.