O'Reilly logo

MySQL in a Nutshell by Russell J.T. Dyer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required