documentation.html

一个用PHP编写的

    <dt><b><a name="cfg_Servers_connect_type"></a>$cfg['Servers'][$i]['connect_type']</b> string</dt>
    <dd>
        What type connection to use with the MySQL server. Your options are
        <tt>'socket'</tt> &amp; <tt>'tcp'</tt>. It defaults to 'tcp' as that
        is nearly guaranteed to be available on all MySQL servers, while
        sockets are not supported on some platforms.
        <br /><br />
        To use the socket mode, your MySQL server must be on the same machine
        as the Web server.
    </dd>

    <dt><b><a name="cfg_Servers_extension"></a>$cfg['Servers'][$i]['extension']</b> string</dt>
    <dd>
        What php MySQL extension to use for the connection. Valid options are:
        <br /><br />
        <tt><i>mysql</i></tt>&nbsp;:&nbsp;
        The classic MySQL extension. This is the recommended and default
        method at this time.
        <br /><br />
        <tt><i>mysqli</i></tt>&nbsp;:&nbsp;
        The improved MySQL extension. This extension became available
        with php 5.0.0 and is the recommended way to connect to a server
        running MySQL 4.1.x.
    </dd>

    <dt><b><a name="cfg_Servers_compress"></a>$cfg['Servers'][$i]['compress']</b> boolean</dt>
    <dd>
        Whether to use a compressed protocol for the MySQL server connection
        or not (experimental).<br />
        This feature requires PHP&nbsp;&gt;=&nbsp;4.3.0.
    </dd>

    <dt>
<a name="controluser"></a>
        <b><a name="cfg_Servers_controluser"></a>$cfg['Servers'][$i]['controluser']</b> string<br />
        <b><a name="cfg_Servers_controlpass"></a>$cfg['Servers'][$i]['controlpass']</b> string
    </dt>
    <dd>
        This special account is used for 2 distinct purposes: to make possible
        all relational features
        (see <a href="#pmadb">$cfg['Servers'][$i]['pmadb']</a>) and, for a
        MySQL server older than 4.1.2 or running with
        <tt>--skip-show-database</tt>, to enable a multi-user installation
        (http or cookie authentication mode).
        <br /><br />
        When using HTTP or cookie authentication modes (or 'config'
        authentication mode since phpMyAdmin 2.2.1), you need to supply the
        details of a MySQL account that has <tt>SELECT</tt> privilege on the
        <i>mysql.user (all columns except &quot;Password&quot;)</i>,
        <i>mysql.db (all columns)</i> &amp; <i>mysql.tables_priv (all columns
        except &quot;Grantor&quot; &amp; &quot;Timestamp&quot;) </i>tables.
        This account is used to check what databases the user will see at
        login.
        <br />
        Please see the <a href="#setup">install section</a> on
        &quot;Using authentication modes&quot; for more information.
        <br /><br />
        In phpMyAdmin versions before 2.2.5, those were called
        &quot;stduser/stdpass&quot;.
    </dd>

    <dt><b><a name="cfg_Servers_auth_type"></a>$cfg['Servers'][$i]['auth_type']</b> string
    <tt>['http'|'cookie'|'config']</tt></dt>
    <dd>
        Whether config or cookie or http authentication should be used for this
        server.
        <ul>
            <li>
                'config' authentication
                (<tt>$auth_type&nbsp;=&nbsp;'config'</tt>) is the plain old
                way: username and password are stored in
                <i>config.inc.php</i>.
            </li>
            <li>
                'cookie' authentication mode
                (<tt>$auth_type&nbsp;=&nbsp;'cookie'</tt>) as introduced in
                2.2.3 allows you to log in as any valid MySQL user with the
                help of cookies. Username and password are stored in
                cookies during the session and password is deleted when it
                ends. This can also allow you to login in arbitrary server if
                <tt><a href="#AllowArbitraryServer">$cfg['AllowArbitraryServer']</a></tt> enabled.
            </li>
            <li>
                'http' authentication (was called 'advanced' in older versions)
                (<tt>$auth_type&nbsp;=&nbsp;'http'</tt>) as introduced in 1.3.0
                allows you to log in as any valid MySQL user via HTTP-Auth.
            </li>
        </ul><br />

        Please see the <a href="#setup">install section</a> on &quot;Using authentication modes&quot;
        for more information.
    </dd>
    <dt>
<a name="servers_user"></a>
        <b><a name="cfg_Servers_user"></a>$cfg['Servers'][$i]['user']</b> string<br />
        <b><a name="cfg_Servers_password"></a>$cfg['Servers'][$i]['password']</b> string
    </dt>
    <dd>
        When using auth_type = 'config', this is the user/password-pair
        which phpMyAdmin will use to connect to the
        MySQL server. This user/password pair is not needed when HTTP or
        cookie authentication is used and should be empty.
    </dd>
    <dt>
<a name="servers_only_db"></a>
      <b><a name="cfg_Servers_only_db"></a>$cfg['Servers'][$i]['only_db']</b> string or array
    </dt>
    <dd>
        If set to a (an array of) database name(s), only this (these) database(s)
        will be shown to the user. Since phpMyAdmin 2.2.1, this/these
        database(s) name(s) may contain MySQL wildcards characters
        (&quot;_&quot; and &quot;%&quot;): if you want to use literal instances
        of these characters, escape them (I.E. use <tt>'my\_db'</tt> and not
        <tt>'my_db'</tt>).<br />
        This setting is an efficient way to lower the server load since the
        latter does not need to send MySQL requests to build the available
        database list. But <span class="important">it does not replace the
        privileges rules of the MySQL database server</span>. If set, it just
        means only these databases will be displayed but
        <span class="important">not that all other databases can't be used.</span>
        <br /><br />
        An example of using more that one database:
        <tt>$cfg['Servers'][$i]['only_db'] = array('db1', 'db2'); </tt>
        <br /><br />
        As of phpMyAdmin 2.5.5 the order inside the array is used for sorting the
        databases in the left frame, so that you can individually arrange your databases.<br />
        If you want to have certain databases at the top, but don't care about the others, you do not
        need to specify all other databases. Use:
        <tt>$cfg['Servers'][$i]['only_db'] = array('db3', 'db4', '*');</tt>
        instead to tell phpMyAdmin that it should display db3 and db4 on top, and the rest in alphabetic
        order.
    </dd>

    <dt>
      <b><a name="cfg_Servers_hide_db"></a>$cfg['Servers'][$i]['hide_db']</b> string
    </dt>
    <dd>
        Regular expression for hiding some databases. This only hides them
        from listing, but user is still able to access them.
    </dd>

    <dt><b><a name="cfg_Servers_verbose"></a>$cfg['Servers'][$i]['verbose']</b> string</dt>
    <dd>
        Only useful when using phpMyAdmin with multiple server entries. If set,
        this string will be displayed instead of the hostname in the pull-down
        menu on the main page. This can be useful if you want to show only
        certain databases on your system, for example.
    </dd>

    <dt>
        <a name="pmadb"></a>
        <b><a name="cfg_Servers_pmadb"></a>$cfg['Servers'][$i]['pmadb']</b> string
    </dt>
    <dd>
        The name of the database containing the linked-tables infrastructure.
        <br /><br />
        See the <a href="#linked-tables">Linked-tables infrastructure</a>
        section in this document to see the benefits of this infrastructure,
        and for a quick way of creating this database and the needed tables.
        <br /><br />
        If you are the only user of this phpMyAdmin installation, you can
        use your current database to store those special tables; in this
        case, just put your current database name in
        <tt>$cfg['Servers'][$i]['pmadb']</tt>. For a multi-user installation,
        set this parameter to the name of your central database containing
        the linked-tables infrastructure.
    </dd>

    <dt>
        <a name="bookmark"></a>
        <b><a name="cfg_Servers_bookmarktable"></a>$cfg['Servers'][$i]['bookmarktable']</b> string
    </dt>
    <dd>
        Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be
        useful for queries you often run.<br /><br />

        To allow the usage of this functionality:
        <ul>
            <li>set up <a href="#pmadb">pmadb</a> and the linked-tables infrastructure</li>
            <li>enter the table name in
                <tt>$cfg['Servers'][$i]['bookmarktable']</tt></li>
        </ul>
    </dd>

    <dt>
        <a name="relation"></a>
        <b><a name="cfg_Servers_relation"></a>$cfg['Servers'][$i]['relation']</b> string
    </dt>
    <dd>
        Since release 2.2.4 you can describe, in a special 'relation' table,
        which field is a key in another table (a foreign key). phpMyAdmin
        currently uses this to
        <ul>
           <li>
              make clickable, when you browse the master table, the data values
              that point to the foreign table;
           </li>
           <li>
              display in an optional tool-tip the &quot;display field&quot;
              when browsing the master table, if you move the mouse to a column
              containing a foreign key (use also the 'table_info' table);<br />
              (see <a href="#faqdisplay">FAQ 6.7</a>)
           </li>
           <li>
              in edit/insert mode, display a drop-down list of possible
              foreign keys (key value and &quot;display field&quot; are
              shown)<br />
              (see <a href="#faq6_21">FAQ 6.21</a>)
           </li>
           <li>
              display links on the table properties page, to check referential
              integrity (display missing foreign keys) for each described key;
           </li>
           <li>
              in query-by-example, create automatic joins (see <a href="#faq6_6">FAQ 6.6</a>)
           </li>
           <li>
              enable you to get a PDF schema of your database (also uses the
              table_coords table).
           </li>
        </ul>

        The keys can be numeric or character.
        <br /><br />

        To allow the usage of this functionality:
        <ul>
            <li>set up <a href="#pmadb">pmadb</a> and the linked-tables infrastructure</li>
            <li>
                put the relation table name in
                <tt>$cfg['Servers'][$i]['relation']</tt>
            </li>
            <li>
                now as normal user open phpMyAdmin and for each one of your
                tables where you want to use this feature, click
                &quot;Structure/Relation view/&quot; and choose foreign fields.
            </li>
        </ul>
        Please note that in the current version, <tt>master_db</tt>
        must be the same as <tt>foreign_db</tt>.  Those fields have been put in
        future development of the cross-db relations.
    </dd>

    <dt>
        <a name="table_info"></a>
        <b><a name="cfg_Servers_table_info"></a>$cfg['Servers'][$i]['table_info']</b> string
    </dt>
    <dd>
        Since release 2.3.0 you can describe, in a special 'table_info'
        table, which field is to be displayed as a tool-tip when moving the
        cursor over the corresponding key.
        <br />
        This configuration variable will hold the name of this special
        table.
        To allow the usage of this functionality:
        <ul>
            <li>set up <a href="#pmadb">pmadb</a> and the linked-tables infrastructure</li>
            <li>
                put the table name in
                <tt>$cfg['Servers'][$i]['table_info']</tt>
            </li>
            <li>
                then for each table where you want to use this feature,
                click &quot;Structure/Relation view/Choose field to display&quot;
                to choose the field.
            </li>
        </ul>
        Usage tip: <a href="#faqdisplay">Display field</a>.
    </dd>
    <dt>
        <a name="table_coords"></a>
        <b><a name="cfg_Servers_table_coords"></a>$cfg['Servers'][$i]['table_coords']</b> string<br />
        <b><a name="cfg_Servers_pdf_pages"></a>$cfg['Servers'][$i]['pdf_pages']</b> string
    </dt>
    <dd>
        Since release 2.3.0 you can have phpMyAdmin create PDF pages showing
        the relations between your tables. To do this it needs two tables
        &quot;pdf_pages&quot; (storing information about the available PDF
        pages) and &quot;table_coords&quot; (storing coordinates where each
        table will be placed on a PDF schema output).
        <br /><br />
        You must be using the &quot;relation&quot; feature.
        <br /><br />