MySQL in a Nutshell

Appendix C. Environment Variables

The MySQL server, and many of its clients and utilities, use several environment variables provided by the operating system. For some programs, the user can override some of these variables by command-line options or values set in an option file (i.e., my.cnf or my.ini). Table C-1 lists the variables used.

Table C-1. Variables and their uses

Variable	Use
CC	C compiler
CXX	C++ compiler
CFLAGS	C compiler flags
CXXFLAGS	C++ compiler flags
DBI_USER	Default username for Perl DBI applications
DBI_TRACE	Perl DBI trace options
HOME	Default path for mysql client program history file
LD_RUN_PATH	Path for libmysqlclient.so file
MYSQL_DEBUG	Debug trace options
MYSQL_HISTFILE	Default path for mysql client program history file
MYSQL_HOST	Default host for mysql client program
MYSQL_PS1	Command-line prompt for first line of a statement for mysql client program
MYSQL_PWD	Default password for connecting to server
MYSQL_TCP_PORT	Default TCP/IP port number
MYSQL_UNIX_PORT	Default Unix socket filename
PATH	Path for the MySQL programs
TMPDIR	Path for temporary directory
TZ	Time zone of server
UMASK_DIR	Permissions settings for creating directories
UMASK	Permissions settings for creating files
USER	Default username for connecting to server running on MS Windows or Novell NetWare