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.
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 |
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 |
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.