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




MySQL in a Nutshell
MYSQL in a Nutshell (In a Nutshell (OReilly))
ISBN: 0596514336
EAN: 2147483647
Year: 2006
Pages: 134
Authors: Russell Dyer

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net