documentation.txt

来自「phpMyAdmin图形界面化操作,我已经配置好了,只要把解要压缩后的文件放到站」· 文本 代码 · 共 1,262 行 · 第 1/5 页

    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['MaxDbList'] integer
    The maximum number of database names to be displayed in the navigation
    frame and the database list.
$cfg['MaxTableList'] integer
    The maximum number of table names to be displayed in the main panel's list
    (except on the Export page). This limit is also enforced in the navigation
    panel when in Light mode.
$cfg['MaxCharactersInDisplayedSQL'] integer
    The maximum number of characters when a SQL query is displayed. The default
    limit of 1000 should be correct to avoid the display of tons of hexadecimal
    codes that represent BLOBs, but some users have real SQL queries that are
    longer than 1000 characters. Also, if a query's length exceeds this limit,
    this query is not saved in the history.
$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
    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 MySQL 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.
    Please note that this limitation of SQL queries is not as strict as when
    using MySQL privileges. This is due to nature of SQL queries which might be
    quite complicated. So this choice should be viewed as help to avoid
    accidental dropping rather than strict privilege limitation.
$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.

    This is automatically diabled if you do not have configured $cfg
    ['blowfish_secret'].
$cfg['LoginCookieValidity'] integer [number of seconds]
    Define how long is login cookie valid.
$cfg['LoginCookieStore'] integer [number of seconds]
    Define how long is login cookie should be stored in browser. Default 0
    means that it will be kept for existing session. This is recommended for
    not trusted environments.
$cfg['LoginCookieDeleteAll'] boolean
    If enabled (default), logout deletes cookies for all servers, otherwise
    only for current one. Setting this to false makes it easy to forget to log
    out from other server, when you are using more of them.
$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 log in to arbitrary servers using cookie auth.

    NOTE: Please use this carefully, as this may allow users access to MySQL
    servers behind the firewall where your HTTP server is placed.
$cfg['LeftFrameLight'] boolean
    Defines whether to use a 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 should not use this separator 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
    comment and the real name. That means that if you have a table called
    'user0001' and add the comment 'MyName' on it, you will see the name
    'MyName' used consequently in the left frame and the tool-tip shows the
    real name of the DB.
$cfg['ShowTooltipAliasTB'] boolean/string
    Same as $cfg['ShowTooltipAliasDB'], except this works for table names. When
    setting this to 'nested', the Alias of the Tablename is only used to split/
    nest the tables according to the $cfg['LeftFrameTableSeparator'] directive.
    So only the folder is called like the Alias, the tablename itself stays the
    real tablename.
$cfg['LeftDisplayLogo'] boolean
    Defines whether or not to display the phpMyAdmin logo at the top of the
    left frame. Defaults to TRUE.
$cfg['LeftLogoLink'] string
    Enter URL where logo in the navigation frame will point to. For use
    especially with self made theme which changes this. The default value for
    this is main.php.
$cfg['LeftLogoLinkWindow'] string
    Whether to open the linked page in the main window (main) or in a new one
    (new). Note: use new if you are linking to phpmyadmin.net.
$cfg['LeftDisplayServers'] boolean
    Defines whether or not to display a server choice at the top of the left
    frame. Defaults to FALSE.
$cfg['DisplayServersList'] boolean
    Defines whether to display this server choice as links instead of in a
    drop-down. Defaults to FALSE (drop-down).
$cfg['DisplayDatabasesList'] boolean or text
    Defines whether to display database choice in light navigation frame as
    links instead of in a drop-down. Defaults to 'auto' - on main page list is
    shown, when database is selected, only drop down is displayed.
$cfg['LeftDefaultTabTable'] string
    Defines the tab displayed by default when clicking the small icon next to
    each table name in the navigation panel. Possible values:
    "tbl_structure.php", "tbl_sql.php", "tbl_select.php", "tbl_change.php" or
    "sql.php".
$cfg['ShowStats'] boolean
    Defines whether or not to display space usage and statistics about
    databases and tables.
    Note that statistics requires at least MySQL 3.23.3 and that, at this date,
    MySQL doesn't return such information for Berkeley DB tables.
$cfg['ShowServerInfo'] boolean
    Defines whether to display detailed server information on main page. You
    can additionally hide more information by using $cfg['Servers'][$i]
    ['verbose'].
$cfg['ShowPhpInfo'] boolean
    $cfg['ShowChgPassword'] boolean
    $cfg['ShowCreateDb'] boolean
    Defines whether to display the "PHP information" and "Change password "
    links and form for creating database or not at the starting main (right)
    frame. This setting does not check MySQL commands entered directly.

    Please note that to block the usage of phpinfo() in scripts, you have to
    put this in your php.ini:

    disable_functions = phpinfo()

    Also note that enabling the "Change password " link has no effect with
    "config" authentication mode: because of the hard coded password value in
    the configuration file, end users can't be allowed to change their
    passwords.
$cfg['SuggestDBName'] boolean
    Defines whether to suggest a database name on the "Create Database" form or
    to keep the textfield empty.
$cfg['NavigationBarIconic'] string
    Defines whether navigation bar buttons and the right panel top menu contain
    text or symbols only. A value of TRUE displays icons, FALSE displays text
    and 'both' displays both icons and text.
$cfg['ShowAll'] boolean
    Defines whether a user should be displayed a "show all (records)" button in
    browse mode or not.
$cfg['MaxRows'] integer
    Number of rows displayed when browsing a result set. If the result set
    contains more rows, "Previous" and "Next" links will be shown.
$cfg['Order'] string [DESC|ASC|SMART]
    Defines whether fields are displayed in ascending (ASC) order, in
    descending (DESC) order or in a "smart" (SMART) order - I.E. descending
    order for fields of type TIME, DATE, DATETIME and TIMESTAMP, ascending
    order else- by default.
$cfg['ProtectBinary'] boolean or string
    Defines whether BLOB or BINARY fields are protected from editing when
    browsing a table's content. Valid values are:
      + FALSE to allow editing of all fields;
      + 'blob' to allow editing of all fields except BLOBS;
      + 'all' to disallow editing of all BINARY or BLOB fields.
$cfg['ShowFunctionFields'] boolean
    Defines whether or not MySQL functions fields should be initially displayed
    in edit/insert mode. Since version 2.10, the user can toggle this setting
    from the interface.
$cfg['CharEditing'] string
    Defines which type of editing controls should be used for CHAR and VARCHAR
    fields. Possible values are:
      + input - this allows to limit size of text to size of field in MySQL,
        but has problems with newlines in fields
      + textarea - no problems with newlines in fields, but also no length
        limitations
    Default is old behavior so input.
$cfg['InsertRows'] integer
    Defines the maximum number of concurrent entries for the Insert page.
$cfg['ForeignKeyMaxLimit'] integer
    If there are fewer items than this in the set of foreign keys, then a
    drop-down box of foreign keys is presented, in the style described by the
    $cfg['ForeignKeyDropdownOrder'] setting.
$cfg['ForeignKeyDropdownOrder'] array
    For the foreign key drop-down fields, there are several methods of display,
    offering both the key and value data. The contents of the array should be
    one or both of the following strings: 'content-id', 'id-content'.
$cfg['ZipDump'] boolean
    $cfg['GZipDump'] boolean
    $cfg['BZipDump'] boolean
    Defines whether to allow the use of zip/GZip/BZip2 compression when
    creating a dump file
$cfg['CompressOnFly'] boolean