Appendix C. Server and 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 options file (i.e., my.cnf or my.ini, depending on your system). Table C-1 lists the variables used.
Table C-1. Variables and their uses
Variable | Use |
---|---|
| C compiler |
| C++ compiler |
| C compiler flags |
| C++ compiler flags |
| Default username for Perl DBI applications |
| Perl DBI trace options |
| Default path for mysql client program history file |
| Path for libmysqlclient.so file |
| Debug trace options |
| Relates to the value given with the
|
| Default path for the mysql client program history file |
| Contains the path for the server’s options file (e.g., my.cnf); available as of version 5.0.3 of MySQL |
| Default host for mysql client program |
| Command-line prompt for the first line of a statement for the mysql client program |
| Default password for connecting to the server |
| Default TCP/IP port number |
| Default Unix socket filename |
| Path for the MySQL programs |
| Path for a temporary directory |
| Timezone of the server |
| Permissions settings for creating directories |
| Permissions settings for creating files |
| Default username for ... |
Get MySQL in a Nutshell, 2nd Edition 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.