documentation.txt

WEBGAME源码,有架设说明,只是非常简单

$cfg['Servers'][$i]['only_db'] string or array
    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 ("_" and "%"): if you want
    to use literal instances of these characters, escape them (I.E. use 'my\
    _db' and not 'my_db').
    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 it does not replace the privileges rules of the MySQL database server.
    If set, it just means only these databases will be displayed but not that
    all other databases can't be used.

    An example of using more that one database: $cfg['Servers'][$i]['only_db']
    = array('db1', 'db2');

    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.
    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: $cfg
    ['Servers'][$i]['only_db'] = array('db3', 'db4', '*'); instead to tell
    phpMyAdmin that it should display db3 and db4 on top, and the rest in
    alphabetic order.
$cfg['Servers'][$i]['hide_db'] string
    Regular expression for hiding some databases. This only hides them from
    listing, but a user is still able to access them (using, for example, the
    SQL query area). To limit access, use the MySQL privilege system.

    For example, to hide all databases starting with the letter "a", use

    $cfg['Servers'][$i]['hide_db'] = '^a';

    and to hide both "db1" and "db2" use

    $cfg['Servers'][$i]['hide_db'] = '(db1|db2)';

    More information on regular expressions can be found in the PCRE pattern
    syntax portion of the PHP reference manual.
$cfg['Servers'][$i]['verbose'] string
    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.
$cfg['Servers'][$i]['pmadb'] string
    The name of the database containing the linked-tables infrastructure.

    See the Linked-tables infrastructure section in this document to see the
    benefits of this infrastructure, and for a quick way of creating this
    database and the needed tables.

    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 users 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]['designer_coords'] string
    Since release 2.10.0 a Designer interface is available; it permits to
    visually manage the relations.

    To allow the usage of this functionality:
      + set up pmadb and the linked-tables infrastructure
      + put the table name in $cfg['Servers'][$i]['designer_coords']
$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.

    Please also see $cfg['TrustedProxies'] for detecting IP address behind
    proxies.
$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['Servers'][$i]['SignonSession'] string
    Name of session which will be used for signon authentication method.
$cfg['Servers'][$i]['SignonURL'] string
    URL where user will be redirected to log in for signon authentication
    method. Should be absolute including protocol.
$cfg['Servers'][$i]['LogoutURL'] string
    URL where user will be redirected after logout (doesn't affect config
    authentication method). Should be absolute including protocol.
$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 when having enabled buffering.
$cfg['PersistentConnections'] boolean