1. Home
  2. SQL
  3. MySQL

DBI Environment Variables

DBI consults several environment variables, listed in Table G.4. All of them, except DBI_TRACE, are used by the connect() method. DBI_DRIVER is used by the data_sources() method, and DBI_TRACE is used by trace().

Table G.4. DBI Environment Variables
Name Meaning
DBI_DRIVER DBD-level driver name ("mysql" for MySQL)
DBI_DSN Data source name
DBI_PASS Password
DBI_TRACE Trace level and/or trace output file
DBI_USER Username



    		Part I: General MySQL Use
    		Part II: Using MySQL Programming Interfaces
    		Part III: MySQL Administration
    		Part IV: Appendixes
    		Appendix A. Obtaining and Installing Software
    		Appendix B. Column Type Reference
    		Appendix C. Operator and Function Reference
    		Appendix D. SQL Syntax Reference
    		Appendix E. MySQL Program Reference
    		Appendix F. C API Reference
    		Appendix G. Perl DBI API Reference
    		Writing Scripts
    		DBI Methods
    		DBI Utility Functions
    		DBI Attributes
    		DBI Environment Variables
    		Appendix H. PHP API Reference
    		Appendix I. Internet Service Providers