(mysql.info.gz) Environment variable options
Info Catalog
(mysql.info.gz) Option files
(mysql.info.gz) Program Options
(mysql.info.gz) Program variables
4.3.3 Using Environment Variables to Specify Options
----------------------------------------------------
To specify an option using an environment variable, set the variable
using the syntax appropriate for your comment processor. For example,
on Windows or NetWare, you can set the `USER' variable to specify your
MySQL account name. To do so, use this syntax:
SET USER=YOUR_NAME
The syntax on Unix depends on your shell. Suppose that you want to
specify the TCP/IP port number using the `MYSQL_TCP_PORT' variable. The
syntax for Bourne shell and variants (`sh', `bash', `zsh', etc.) is:
MYSQL_TCP_PORT=3306
For `csh' and `tcsh', use this syntax:
setenv MYSQL_TCP_PORT 3306
The commands to set environment variables can be executed at your
command prompt to take effect immediately. These settings persist until
you log out. To have the settings take effect each time you log in,
place the appropriate command or commands in a startup file that your
command interpreter reads each time it starts. Typical startup files are
`AUTOEXEC.BAT' for Windows, `.bash_profile' for `bash', or `.tcshrc'
for `tcsh'. Consult the documentation for your command interpreter for
specific details.
Environment variables lists all environment variables that
affect MySQL program operation.
Info Catalog
(mysql.info.gz) Option files
(mysql.info.gz) Program Options
(mysql.info.gz) Program variables
automatically generated byinfo2html