<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    770 MySQL Technical Reference for Version 4.0.3 Appendix F  Environment Variables Here is a list of all the environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Note that any options on the command-line will take precedence over values speci ed in con- guration les and environment variables, and values in con guration les take precedence over values in environment variables. In  many  cases  it's  preferable  to  use  a  con gure   le  instead  of  environment  variables  to modify the behaviour of MySQL. See Section 4.1.2 [Option les], page 186. Variable Description CCX Set this to your C++ compiler when running con gure. CC Set this to your C compiler when running con gure. CFLAGS Flags for your C compiler when running con gure. CXXFLAGS Flags for your C++ compiler when running con gure. DBI_USER The default user name for Perl DBI. DBI_TRACE Used when tracing Perl DBI. HOME The    default    path    for    the mysql history     le    is `$HOME/.mysql_history'. LD_RUN_PATH Used to specify where your libmysqlclient.so is. MYSQL_DEBUG Debug-trace options when debugging. MYSQL_HISTFILE The path to the mysql history le. MYSQL_HOST Default host name used by the mysql command-line client. MYSQL_PS1 Command prompt to use in the mysql command-line client. See Section 4.8.2 [mysql], page 288. MYSQL_PWD The default password when connecting to mysqld.  Note that use of this is insecure! MYSQL_TCP_PORT The default TCP/IP port. MYSQL_UNIX_PORT The default socket; used for connections to localhost. PATH Used by the shell to nds the MySQL programs. TMPDIR The directory where temporary tables/ les are created. TZ This should be set to your local time zone.  See Section A.4.6 [Timezone problems], page 644. UMASK_DIR The  user-directory  creation  mask  when creating  directories. Note that this is ANDed with UMASK! UMASK The user- le creation mask when creating les. USER The  default  user  on  Windows  to  use  when  connecting  to mysqld.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide