documentation.txt

一个用PHP编写的

    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 $cfg['Servers'][$i]['pmadb']. For a multi-user
    installation, set this parameter to the name of your central database
    containing the linked-tables infrastructure.
$cfg['Servers'][$i]['bookmarktable'] string
    Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be
    useful for queries you often run.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + enter the table name in $cfg['Servers'][$i]['bookmarktable']
$cfg['Servers'][$i]['relation'] string
    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
      + make clickable, when you browse the master table, the data values that
        point to the foreign table;
      + display in an optional tool-tip the "display field" when browsing the
        master table, if you move the mouse to a column containing a foreign
        key (use also the 'table_info' table);
        (see FAQ 6.7)
      + in edit/insert mode, display a drop-down list of possible foreign keys
        (key value and "display field" are shown)
        (see FAQ 6.21)
      + display links on the table properties page, to check referential
        integrity (display missing foreign keys) for each described key;
      + in query-by-example, create automatic joins (see FAQ 6.6)
      + enable you to get a PDF schema of your database (also uses the
        table_coords table).
    The keys can be numeric or character.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the relation table name in $cfg['Servers'][$i]['relation']
      + now as normal user open phpMyAdmin and for each one of your tables
        where you want to use this feature, click "Structure/Relation view/"
        and choose foreign fields.
    Please note that in the current version, master_db must be the same as
    foreign_db. Those fields have been put in future development of the
    cross-db relations.
$cfg['Servers'][$i]['table_info'] string
    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.
    This configuration variable will hold the name of this special table. To
    allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the table name in $cfg['Servers'][$i]['table_info']
      + then for each table where you want to use this feature, click
        "Structure/Relation view/Choose field to display" to choose the field.
    Usage tip: Display field.
$cfg['Servers'][$i]['table_coords'] string
    $cfg['Servers'][$i]['pdf_pages'] string
    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 "pdf_pages"
    (storing information about the available PDF pages) and "table_coords"
    (storing coordinates where each table will be placed on a PDF schema
    output).

    You must be using the "relation" feature.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the correct table names in $cfg['Servers'][$i]['table_coords'] and
        $cfg['Servers'][$i]['pdf_pages']
    Usage tips: PDF output.
$cfg['Servers'][$i]['column_info'] string
    Since release 2.3.0 you can store comments to describe each column for each
    table. These will then be shown on the "printview".

    Starting with release 2.5.0, comments are consequently used on the table
    property pages and table browse view, showing up as tool-tips above the
    column name (properties page) or embedded within the header of table in
    browse view. They can also be shown in a table dump. Please see the
    relevant configuration directives later on.

    Also new in release 2.5.0 is a MIME-transformation system which is also
    based on the following table structure. See Transformations for further
    information. To use the MIME-transformation system, your column_info table
    has to have the three new fields 'mimetype', 'transformation',
    'transformation_options'.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the table name in $cfg['Servers'][$i]['column_info']
      + to update your PRE-2.5.0 Column_comments Table use this:
             ALTER TABLE `pma_column_comments`
               ADD `mimetype` VARCHAR( 255 ) NOT NULL ,
               ADD `transformation` VARCHAR( 255 ) NOT NULL ,
               ADD `transformation_options` VARCHAR( 255 ) NOT NULL ;
        and remember that the Variable in config.inc.php has been renamed from
        $cfg['Servers'][$i]['column_comments'] to $cfg['Servers'][$i]
        ['column_info']
$cfg['Servers'][$i]['history'] string
    Since release 2.5.0 you can store your SQL history, which means all queries
    you entered manually into the phpMyAdmin interface. If you don't want to
    use a table- based history, you can use the JavaScript-based history. Using
    that, all your history items are deleted when closing the window.

    Using $cfg[QueryHistoryMax] you can specify an amount of history items you
    want to have on hold. On every login, this list gets cut to the maximum
    amount.

    The query history is only available if JavaScript is enabled in your
    browser.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the table name in $cfg['Servers'][$i]['history']
$cfg['Servers'][$i]['verbose_check'] boolean
    Because release 2.5.0 introduced the new MIME-transformation support, the
    column_info table got enhanced with three new fields. If the above variable
    is set to TRUE (default) phpMyAdmin will check if you have the latest table
    structure available. If not, it will emit a warning to the superuser.

    You can disable this checking behavior by setting the variable to false,
    which should offer a performance increase.

    Recommended to set to FALSE, when you are sure, your table structure is up
    to date.
$cfg['Servers'][$i]['AllowRoot'] boolean
    Whether to allow root access, This is just simplification of rules below.
$cfg['Servers'][$i]['AllowDeny']['order'] string
    If your rule order is empty, then IP authentication is disabled.

    If your rule order is set to 'deny,allow' then the system applies all deny
    rules followed by allow rules. Access is allowed by default. Any client
    which does not match a Deny command or does match an Allow command will be
    allowed access to the server.

    If your rule order is set to 'allow,deny' then the system applies all allow
    rules followed by deny rules. Access is denied by default. Any client which
    does not match an Allow directive or does match a Deny directive will be
    denied access to the server.

    If your rule order is set to 'explicit', the authentication is performed in
    a similar fashion to rule order 'deny,allow', with the added restriction
    that your host/username combination must be listed in the allow rules, and
    not listed in the deny rules. This is the most secure means of using Allow/
    Deny rules, and was available in Apache by specifying allow and deny rules
    without setting any order.
$cfg['Servers'][$i]['AllowDeny']['rules'] array of strings
    The general format for the rules is as such:
          <'allow' | 'deny'> <username> [from] <ipmask>

    If you wish to match all users, it is possible to use a '%' as a wildcard
    in the username field.
    There are a few shortcuts you can use in the ipmask field as well (please
    note that those containing SERVER_ADDRESS might not be available on all
    webservers):

         'all' -> 0.0.0.0/0
         'localhost' -> 127.0.0.1/8
         'localnetA' -> SERVER_ADDRESS/8
         'localnetB' -> SERVER_ADDRESS/16
         'localnetC' -> SERVER_ADDRESS/24

    Having an empty rule list is equivalent to either using 'allow % from all'
    if your rule order is set to 'deny,allow' or 'deny % from all' if your rule
    order is set to 'allow,deny' or 'explicit'.

    For the IP matching system, the following work:
    xxx.xxx.xxx.xxx (an exact IP address)
    xxx.xxx.xxx.[yyy-zzz] (an IP address range)
    xxx.xxx.xxx.xxx/nn (CIDR, Classless Inter-Domain Routing type IP addresses)
    But the following does not work:
    xxx.xxx.xxx.xx[yyy-zzz] (partial IP address range)
$cfg[ServerDefault] integer
    If you have more than one server configured, you can set $cfg
    ['ServerDefault'] to any one of them to autoconnect to that server when
    phpMyAdmin is started, or set it to 0 to be given a list of servers without
    logging in.
    If you have only one server configured, $cfg['ServerDefault'] MUST be set
    to that server.
$cfg[OBGzip] string/boolean
    Defines whether to use GZip output buffering for increased speed in HTTP
    transfers.
    Set to true/false for enabling/disabling. When set to 'auto' (string),
    phpMyAdmin tries to enable output buffering and will automatically disable
    it, if your browser has some problems with buffering. IE6 with a certain
    patch is known to cause data corruption having enabled buffering.
$cfg[PersistentConnections] boolean
    Whether persistent connections should be used or not (mysql_connect or
    mysql_pconnect).
$cfg[ForceSSL] boolean
    Whether to force using https while accessing phpMyAdmin.
$cfg[ExecTimeLimit] integer [number of seconds]
    Set the number of seconds a script is allowed to run. If seconds is set to
    zero, no time limit is imposed.
    This setting is used while importing/exporting dump files but has no effect
    when PHP is running in safe mode.
$cfg[MemoryLimit] integer [number of bytes]
    Set the number of bytes a script is allowed to allocate. If number set to
    zero, no limit is imposed.
    This setting is used while importing/exporting dump files but has no effect
    when PHP is running in safe mode.
    You can also use any string as in php.ini, eg. '16M'.
$cfg[SkipLockedTables] boolean
    Mark used tables and make it possible to show databases with locked tables
    (since 3.23.30).
$cfg[ShowSQL] boolean
    Defines whether SQL-queries generated by phpMyAdmin should be displayed or
    not.
$cfg[AllowUserDropDatabase] boolean
    Defines whether normal users (non-administrator) are allowed to delete
    their own database or not. If set as FALSE, the link "Drop Database" will
    not be shown, and even a "DROP DATABASE mydatabase" will be rejected. Quite
    practical for ISP's with many customers.
$cfg[Confirm] boolean
    Whether a warning ("Are your really sure...") should be displayed when
    you're about to lose data.
$cfg[LoginCookieRecall] boolean
    Define whether the previous login should be recalled or not in cookie
    authentication mode.
$cfg[UseDbSearch] boolean
    Define whether the "search string inside database" is enabled or not.
$cfg[IgnoreMultiSubmitErrors] boolean
    Define whether phpMyAdmin will continue executing a multi-query statement
    if one of the queries fails. Default is to abort execution.
$cfg[VerboseMultiSubmit] boolean
    Define whether phpMyAdmin will output the results of each query of a
    multi-query statement embedded into the SQL output as inline comments.
    Defaults to TRUE.
$cfg[AllowArbitraryServer] boolean
    If enabled allows you to login to arbitrary server using cookie auth.

    NOTE: Please use this carefully, as this may allow to access MySQL servers
    behind firewall where your http server is placed.

$cfg[LeftFrameLight] boolean
    Defines whether to use select-based menu and display only the current
    tables in the left frame (smaller page). Only in Non-Lightmode you can use
    the feature to display nested folders using $cfg['LeftFrameTableSeparator']
$cfg[LeftFrameDBTree] boolean
    In light mode, defines whether to display the names of databases (in the
    selector) using a tree, see also $cfg['LeftFrameDBSeparator'].
$cfg[LeftFrameDBSeparator] string
    The string used to separate the parts of the database name when showing
    them in a tree.
$cfg[LeftFrameTableSeparator] string
    Defines a string to be used to nest table spaces. Defaults to '__'. This
    means if you have tables like 'first__second__third' this will be shown as
    a three-level hierarchy like: first > second > third. If set to FALSE or
    empty, the feature is disabled. NOTE: You shall not use this Separator in a
    table name at the beginning or end of a table name, or multiple times after
    another without any other characters in between.
$cfg[LeftFrameTableLevel] string
    Defines how many sublevels should be displayed when splitting up tables by
    the above Separator.
$cfg[ShowTooltip] boolean
    Defines whether to display table comment as tool-tip in left frame or not.
$cfg[ShowTooltipAliasDB] boolean
    If tool-tips are enabled and a DB comment is set, this will flip the