<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="programs-overview">
      </a>
      6.1 Overview of MySQL Programs
     </h2>
    </div>
   </div>
  </div>
  <p>
   There are many different programs in a MySQL installation. This
      section provides a brief overview of them. Later sections provide
      a more detailed description of each one, with the exception of NDB
      Cluster programs. Each program's description indicates its
      invocation syntax and the options that it supports.
   <a class="xref" href="mysql-cluster-programs.html" title="25.5 NDB Cluster Programs">
    Section 25.5, “NDB Cluster Programs”
   </a>
   , describes programs
      specific to NDB Cluster.
  </p>
  <p>
   Most MySQL distributions include all of these programs, except for
      those programs that are platform-specific. (For example, the
      server startup scripts are not used on Windows.) The exception is
      that RPM distributions are more specialized. There is one RPM for
      the server, another for client programs, and so forth. If you
      appear to be missing one or more programs, see
   <a class="xref" href="installing.html" title="Chapter 2 Installing MySQL">
    Chapter 2,
    <i>
     Installing MySQL
    </i>
   </a>
   , for information on types of
      distributions and what they contain. It may be that you have a
      distribution that does not include all programs and you need to
      install an additional package.
  </p>
  <p>
   Each MySQL program takes many different options. Most programs
      provide a
   <code class="option">
    --help
   </code>
   option that you can use to get a
      description of the program's different options. For example, try
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql --help
     </strong>
    </span>
   </a>
   .
  </p>
  <p>
   You can override default option values for MySQL programs by
      specifying options on the command line or in an option file. See
   <a class="xref" href="programs-using.html" title="6.2 Using MySQL Programs">
    Section 6.2, “Using MySQL Programs”
   </a>
   , for general information on
      invoking programs and specifying program options.
  </p>
  <p>
   The MySQL server,
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   , is the main program
      that does most of the work in a MySQL installation. The server is
      accompanied by several related scripts that assist you in starting
      and stopping the server:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324479552">
      </a>
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
     </p>
     <p>
      The SQL daemon (that is, the MySQL server). To use client
          programs,
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      must be running, because
          clients gain access to databases by connecting to the server.
          See
      <a class="xref" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       Section 6.3.1, “mysqld — The MySQL Server”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324474016">
      </a>
      <a class="link" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
       <span class="command">
        <strong>
         mysqld_safe
        </strong>
       </span>
      </a>
     </p>
     <p>
      A server startup script.
      <a class="link" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
       <span class="command">
        <strong>
         mysqld_safe
        </strong>
       </span>
      </a>
      attempts to start
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      . See
      <a class="xref" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
       Section 6.3.2, “mysqld_safe — MySQL Server Startup Script”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324467392">
      </a>
      <a class="link" href="mysql-server.html" title="6.3.3 mysql.server — MySQL Server Startup Script">
       <span class="command">
        <strong>
         mysql.server
        </strong>
       </span>
      </a>
     </p>
     <p>
      A server startup script. This script is used on systems that
          use System V-style run directories containing scripts that
          start system services for particular run levels. It invokes
      <a class="link" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
       <span class="command">
        <strong>
         mysqld_safe
        </strong>
       </span>
      </a>
      to start the MySQL server. See
      <a class="xref" href="mysql-server.html" title="6.3.3 mysql.server — MySQL Server Startup Script">
       Section 6.3.3, “mysql.server — MySQL Server Startup Script”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324461792">
      </a>
      <a class="link" href="mysqld-multi.html" title="6.3.4 mysqld_multi — Manage Multiple MySQL Servers">
       <span class="command">
        <strong>
         mysqld_multi
        </strong>
       </span>
      </a>
     </p>
     <p>
      A server startup script that can start or stop multiple
          servers installed on the system. See
      <a class="xref" href="mysqld-multi.html" title="6.3.4 mysqld_multi — Manage Multiple MySQL Servers">
       Section 6.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   Several programs perform setup operations during MySQL
      installation or upgrading:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324456672">
      </a>
      <a class="link" href="comp-err.html" title="6.4.1 comp_err — Compile MySQL Error Message File">
       <span class="command">
        <strong>
         comp_err
        </strong>
       </span>
      </a>
     </p>
     <p>
      This program is used during the MySQL build/installation
          process. It compiles error message files from the error source
          files. See
      <a class="xref" href="comp-err.html" title="6.4.1 comp_err — Compile MySQL Error Message File">
       Section 6.4.1, “comp_err — Compile MySQL Error Message File”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324452224">
      </a>
      <a class="link" href="mysql-secure-installation.html" title="6.4.2 mysql_secure_installation — Improve MySQL Installation Security">
       <span class="command">
        <strong>
         mysql_secure_installation
        </strong>
       </span>
      </a>
     </p>
     <p>
      This program enables you to improve the security of your MySQL
          installation. See
      <a class="xref" href="mysql-secure-installation.html" title="6.4.2 mysql_secure_installation — Improve MySQL Installation Security">
       Section 6.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324447872">
      </a>
      <a class="link" href="mysql-tzinfo-to-sql.html" title="6.4.3 mysql_tzinfo_to_sql — Load the Time Zone Tables">
       <span class="command">
        <strong>
         mysql_tzinfo_to_sql
        </strong>
       </span>
      </a>
     </p>
     <p>
      This program loads the time zone tables in the
      <code class="literal">
       mysql
      </code>
      database using the contents of the
          host system
      <span class="firstterm">
       zoneinfo
      </span>
      database (the set of files describing time zones). See
      <a class="xref" href="mysql-tzinfo-to-sql.html" title="6.4.3 mysql_tzinfo_to_sql — Load the Time Zone Tables">
       Section 6.4.3, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   MySQL client programs that connect to the MySQL server:
  </p>
  <a class="indexterm" name="idm46045324441984">
  </a>
  <a class="indexterm" name="idm46045324440912">
  </a>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324438656">
      </a>
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
     </p>
     <p>
      The command-line tool for interactively entering SQL
          statements or executing them from a file in batch mode. See
      <a class="xref" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       Section 6.5.1, “mysql — The MySQL Command-Line Client”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324434400">
      </a>
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
     </p>
     <p>
      A client that performs administrative operations, such as
          creating or dropping databases, reloading the grant tables,
          flushing tables to disk, and reopening log files.
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin
        </strong>
       </span>
      </a>
      can also be used to retrieve
          version, process, and status information from the server. See
      <a class="xref" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324428752">
      </a>
      <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       <span class="command">
        <strong>
         mysqlcheck
        </strong>
       </span>
      </a>
     </p>
     <p>
      A table-maintenance client that checks, repairs, analyzes, and
          optimizes tables. See
      <a class="xref" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
       Section 6.5.3, “mysqlcheck — A Table Maintenance Program”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324424528">
      </a>
      <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
       <span class="command">
        <strong>
         mysqldump
        </strong>
       </span>
      </a>
     </p>
     <p>
      A client that dumps a MySQL database into a file as SQL, text,
          or XML. See
      <a class="xref" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
       Section 6.5.4, “mysqldump — A Database Backup Program”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324420320">
      </a>
      <a class="link" href="mysqlimport.html" title="6.5.5 mysqlimport — A Data Import Program">
       <span class="command">
        <strong>
         mysqlimport
        </strong>
       </span>
      </a>
     </p>
     <p>
      A client that imports text files into their respective tables
          using
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
       </code>
      </a>
      . See
      <a class="xref" href="mysqlimport.html" title="6.5.5 mysqlimport — A Data Import Program">
       Section 6.5.5, “mysqlimport — A Data Import Program”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324414880">
      </a>
      <span class="command">
       <strong>
        mysqlsh
       </strong>
      </span>
     </p>
     <p>
      MySQL Shell is an advanced client and code editor for MySQL
          Server. See
      <a class="ulink" href="/doc/mysql-shell/8.4/en/" target="_top">
       MySQL Shell 8.4
      </a>
      . In addition to the
          provided SQL functionality, similar to
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      , MySQL Shell provides scripting
          capabilities for JavaScript and Python and includes APIs for
          working with MySQL. X DevAPI enables you to work with both
          relational and document data, see
      <a class="xref" href="document-store.html" title="Chapter 22 Using MySQL as a Document Store">
       Chapter 22,
       <i>
        Using MySQL as a Document Store
       </i>
      </a>
      . AdminAPI enables you to
          work with InnoDB Cluster, see
      <a class="ulink" href="/doc/mysql-shell/8.4/en/admin-api-userguide.html" target="_top">
       MySQL AdminAPI
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324408096">
      </a>
      <a class="link" href="mysqlshow.html" title="6.5.6 mysqlshow — Display Database, Table, and Column Information">
       <span class="command">
        <strong>
         mysqlshow
        </strong>
       </span>
      </a>
     </p>
     <p>
      A client that displays information about databases, tables,
          columns, and indexes. See
      <a class="xref" href="mysqlshow.html" title="6.5.6 mysqlshow — Display Database, Table, and Column Information">
       Section 6.5.6, “mysqlshow — Display Database, Table, and Column Information”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324403872">
      </a>
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
     </p>
     <p>
      A client that is designed to emulate client load for a MySQL
          server and report the timing of each stage. It works as if
          multiple clients are accessing the server. See
      <a class="xref" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       Section 6.5.7, “mysqlslap — A Load Emulation Client”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   MySQL administrative and utility programs:
  </p>
  <a class="indexterm" name="idm46045324399312">
  </a>
  <a class="indexterm" name="idm46045324398240">
  </a>
  <a class="indexterm" name="idm46045324396752">
  </a>
  <a class="indexterm" name="idm46045324395680">
  </a>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324393424">
      </a>
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
     </p>
     <p>
      An offline
      <code class="literal">
       InnoDB
      </code>
      offline file checksum
          utility. See
      <a class="xref" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       Section 6.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324388416">
      </a>
      <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
       <span class="command">
        <strong>
         myisam_ftdump
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that displays information about full-text indexes in
      <code class="literal">
       MyISAM
      </code>
      tables. See
      <a class="xref" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
       Section 6.6.3, “myisam_ftdump — Display Full-Text Index information”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324383328">
      </a>
      <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
       <span class="command">
        <strong>
         myisamchk
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility to describe, check, optimize, and repair
      <code class="literal">
       MyISAM
      </code>
      tables. See
      <a class="xref" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
       Section 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324378416">
      </a>
      <a class="link" href="myisamlog.html" title="6.6.5 myisamlog — Display MyISAM Log File Contents">
       <span class="command">
        <strong>
         myisamlog
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that processes the contents of a
      <code class="literal">
       MyISAM
      </code>
      log file. See
      <a class="xref" href="myisamlog.html" title="6.6.5 myisamlog — Display MyISAM Log File Contents">
       Section 6.6.5, “myisamlog — Display MyISAM Log File Contents”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324373328">
      </a>
      <a class="link" href="myisampack.html" title="6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables">
       <span class="command">
        <strong>
         myisampack
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that compresses
      <code class="literal">
       MyISAM
      </code>
      tables to
          produce smaller read-only tables. See
      <a class="xref" href="myisampack.html" title="6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables">
       Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324368240">
      </a>
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that enables you to store authentication credentials
          in a secure, encrypted login path file named
      <code class="filename">
       .mylogin.cnf
      </code>
      . See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-migrate-keyring.html" title="6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility">
       <span class="command">
        <strong>
         mysql_migrate_keyring
        </strong>
       </span>
      </a>
     </p>
     <a class="indexterm" name="idm46045324361680">
     </a>
     <p>
      A utility for migrating keys between one keyring component and
          another. See
      <a class="xref" href="mysql-migrate-keyring.html" title="6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility">
       Section 6.6.8, “mysql_migrate_keyring — Keyring Key Migration Utility”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324358800">
      </a>
      <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
       <span class="command">
        <strong>
         mysqlbinlog
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility for reading statements from a binary log. The log of
          executed statements contained in the binary log files can be
          used to help recover from a crash. See
      <a class="xref" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
       Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324354304">
      </a>
      <a class="link" href="mysqldumpslow.html" title="6.6.10 mysqldumpslow — Summarize Slow Query Log Files">
       <span class="command">
        <strong>
         mysqldumpslow
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility to read and summarize the contents of a slow query
          log. See
      <a class="xref" href="mysqldumpslow.html" title="6.6.10 mysqldumpslow — Summarize Slow Query Log Files">
       Section 6.6.10, “mysqldumpslow — Summarize Slow Query Log Files”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   MySQL program-development utilities:
  </p>
  <a class="indexterm" name="idm46045324349856">
  </a>
  <a class="indexterm" name="idm46045324348768">
  </a>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="mysql-config.html" title="6.7.1 mysql_config — Display Options for Compiling Clients">
       <span class="command">
        <strong>
         mysql_config
        </strong>
       </span>
      </a>
     </p>
     <p>
      A shell script that produces the option values needed when
          compiling MySQL programs. See
      <a class="xref" href="mysql-config.html" title="6.7.1 mysql_config — Display Options for Compiling Clients">
       Section 6.7.1, “mysql_config — Display Options for Compiling Clients”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324343360">
      </a>
      <a class="link" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
       <span class="command">
        <strong>
         my_print_defaults
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that shows which options are present in option
          groups of option files. See
      <a class="xref" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
       Section 6.7.2, “my_print_defaults — Display Options from Option Files”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   Miscellaneous utilities:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045324338144">
      </a>
      <a class="link" href="perror.html" title="6.8.1 perror — Display MySQL Error Message Information">
       <span class="command">
        <strong>
         perror
        </strong>
       </span>
      </a>
     </p>
     <p>
      A utility that displays the meaning of system or MySQL error
          codes. See
      <a class="xref" href="perror.html" title="6.8.1 perror — Display MySQL Error Message Information">
       Section 6.8.1, “perror — Display MySQL Error Message Information”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   Oracle Corporation also provides the
   <a class="link" href="workbench.html" title="Chapter 33 MySQL Workbench">
    MySQL Workbench
   </a>
   GUI tool, which
      is used to administer MySQL servers and databases, to create,
      execute, and evaluate queries, and to migrate schemas and data
      from other relational database management systems for use with
      MySQL.
  </p>
  <a class="indexterm" name="idm46045324332640">
  </a>
  <a class="indexterm" name="idm46045324331568">
  </a>
  <p>
   MySQL client programs that communicate with the server using the
      MySQL client/server library use the following environment
      variables.
  </p>
  <a class="indexterm" name="idm46045324329520">
  </a>
  <a class="indexterm" name="idm46045324328432">
  </a>
  <a class="indexterm" name="idm46045324326944">
  </a>
  <a class="indexterm" name="idm46045324325856">
  </a>
  <a class="indexterm" name="idm46045324324368">
  </a>
  <a class="indexterm" name="idm46045324323280">
  </a>
  <a class="indexterm" name="idm46045324321792">
  </a>
  <a class="indexterm" name="idm46045324320704">
  </a>
  <div class="informaltable">
   <table summary="Environment variables used by MySQL client programs that communicate with the server using the MySQL client/server library.">
    <colgroup>
     <col style="width: 25%"/>
     <col style="width: 75%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       Environment Variable
      </th>
      <th>
       Meaning
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <code class="literal">
        MYSQL_UNIX_PORT
       </code>
      </td>
      <td>
       The default Unix socket file; used for connections to
       <code class="literal">
        localhost
       </code>
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        MYSQL_TCP_PORT
       </code>
      </td>
      <td>
       The default port number; used for TCP/IP connections
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        MYSQL_DEBUG
       </code>
      </td>
      <td>
       Debug trace options when debugging
      </td>
     </tr>
     <tr>
      <td>
       <code class="literal">
        TMPDIR
       </code>
      </td>
      <td>
       The directory where temporary tables and files are created
      </td>
     </tr>
    </tbody>
   </table>
  </div>
  <p>
   For a full list of environment variables used by MySQL programs,
      see
   <a class="xref" href="environment-variables.html" title="6.9 Environment Variables">
    Section 6.9, “Environment Variables”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
