📄 documentation.html
字号:
</dd> <dt id="servers_allowdeny_order"> <span id="cfg_Servers_AllowDeny_order">$cfg['Servers'][$i]['AllowDeny']['order']</span> string </dt> <dd>If your rule order is empty, then <abbr title="Internet Protocol">IP</abbr> authentication is disabled.<br /><br /> If your rule order is set to <tt>'deny,allow'</tt> 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. <br /><br /> If your rule order is set to <tt>'allow,deny'</tt> 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.<br /><br /> 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 <b>must</b> be listed in the <i>allow</i> rules, and not listed in the <i>deny</i> rules. This is the <b>most</b> secure means of using Allow/Deny rules, and was available in Apache by specifying allow and deny rules without setting any order.<br /><br /> Please also see <a href="#cfg_TrustedProxies">$cfg['TrustedProxies']</a> for detecting IP address behind proxies. </dd> <dt id="servers_allowdeny_rules"> <span id="cfg_Servers_AllowDeny_rules">$cfg['Servers'][$i]['AllowDeny']['rules']</span> array of strings </dt> <dd>The general format for the rules is as such: <pre><'allow' | 'deny'> <username> [from] <ipmask></pre> If you wish to match all users, it is possible to use a <tt>'%'</tt> as a wildcard in the <i>username</i> field.<br /> There are a few shortcuts you can use in the <i>ipmask</i> field as well (please note that those containing SERVER_ADDRESS might not be available on all webservers): <pre>'all' -> 0.0.0.0/0'localhost' -> 127.0.0.1/8'localnetA' -> SERVER_ADDRESS/8'localnetB' -> SERVER_ADDRESS/16'localnetC' -> SERVER_ADDRESS/24</pre> Having an empty rule list is equivalent to either using <tt>'allow % from all'</tt> if your rule order is set to <tt>'deny,allow'</tt> or <tt>'deny % from all'</tt> if your rule order is set to <tt>'allow,deny'</tt> or <tt>'explicit'</tt>.<br /><br /> For the <abbr title="Internet Protocol">IP</abbr> matching system, the following work:<br /> <tt>xxx.xxx.xxx.xxx</tt> (an exact <abbr title="Internet Protocol">IP</abbr> address)<br /> <tt>xxx.xxx.xxx.[yyy-zzz]</tt> (an <abbr title="Internet Protocol">IP</abbr> address range)<br /> <tt>xxx.xxx.xxx.xxx/nn</tt> (CIDR, Classless Inter-Domain Routing type <abbr title="Internet Protocol">IP</abbr> addresses)<br /> But the following does not work:<br /> <tt>xxx.xxx.xxx.xx[yyy-zzz]</tt> (partial <abbr title="Internet Protocol">IP</abbr> address range) </dd> <dt><span id="cfg_Servers_SignonSession">$cfg['Servers'][$i]['SignonSession']</span> string</dt> <dd>Name of session which will be used for signon authentication method. </dd> <dt><span id="cfg_Servers_SignonURL">$cfg['Servers'][$i]['SignonURL']</span> string</dt> <dd>URL where user will be redirected to log in for signon authentication method. Should be absolute including protocol. </dd> <dt><span id="cfg_Servers_LogoutURL">$cfg['Servers'][$i]['LogoutURL']</span> string</dt> <dd>URL where user will be redirected after logout (doesn't affect config authentication method). Should be absolute including protocol. </dd> <dt id="cfg_ServerDefault">$cfg['ServerDefault'] integer</dt> <dd>If you have more than one server configured, you can set <tt>$cfg['ServerDefault']</tt> 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.<br /> If you have only one server configured, <tt>$cfg['ServerDefault']</tt> MUST be set to that server.</dd> <dt id="cfg_OBGzip">$cfg['OBGzip'] string/boolean</dt> <dd>Defines whether to use GZip output buffering for increased speed in <abbr title="HyperText Transfer Protocol">HTTP</abbr> transfers.<br /> 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.</dd> <dt id="cfg_PersistentConnections">$cfg['PersistentConnections'] boolean</dt> <dd>Whether persistent connections should be used or not (mysql_connect or mysql_pconnect).</dd> <dt id="cfg_ForceSSL">$cfg['ForceSSL'] boolean</dt> <dd>Whether to force using https while accessing phpMyAdmin.</dd> <dt id="cfg_ExecTimeLimit">$cfg['ExecTimeLimit'] integer [number of seconds]</dt> <dd>Set the number of seconds a script is allowed to run. If seconds is set to zero, no time limit is imposed.<br /> This setting is used while importing/exporting dump files but has no effect when PHP is running in safe mode.</dd> <dt id="cfg_MemoryLimit">$cfg['MemoryLimit'] integer [number of bytes]</dt> <dd>Set the number of bytes a script is allowed to allocate. If number set to zero, no limit is imposed.<br /> This setting is used while importing/exporting dump files but has no effect when PHP is running in safe mode.<br /> You can also use any string as in php.ini, eg. '16M'.</dd> <dt id="cfg_SkipLockedTables">$cfg['SkipLockedTables'] boolean</dt> <dd>Mark used tables and make it possible to show databases with locked tables (since MySQL 3.23.30).</dd> <dt id="cfg_ShowSQL">$cfg['ShowSQL'] boolean</dt> <dd>Defines whether <abbr title="structured query language">SQL</abbr> queries generated by phpMyAdmin should be displayed or not.</dd> <dt id="cfg_AllowUserDropDatabase">$cfg['AllowUserDropDatabase'] boolean</dt> <dd>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 <abbr title="Internet service provider">ISP</abbr>'s with many customers.<br /> 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.</dd> <dt id="cfg_Confirm">$cfg['Confirm'] boolean</dt> <dd>Whether a warning ("Are your really sure...") should be displayed when you're about to lose data.</dd> <dt id="cfg_LoginCookieRecall">$cfg['LoginCookieRecall'] boolean</dt> <dd>Define whether the previous login should be recalled or not in cookie authentication mode.</dd> <dt id="cfg_LoginCookieValidity">$cfg['LoginCookieValidity'] integer [number of seconds]</dt> <dd>Define how long is login cookie valid.</dd> <dt id="cfg_LoginCookieStore">$cfg['LoginCookieStore'] integer [number of seconds]</dt> <dd>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.</dd> <dt id="cfg_LoginCookieDeleteAll">$cfg['LoginCookieDeleteAll'] boolean</dt> <dd>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.</dd> <dt id="cfg_UseDbSearch">$cfg['UseDbSearch'] boolean</dt> <dd>Define whether the "search string inside database" is enabled or not.</dd> <dt id="cfg_IgnoreMultiSubmitErrors">$cfg['IgnoreMultiSubmitErrors'] boolean</dt> <dd>Define whether phpMyAdmin will continue executing a multi-query statement if one of the queries fails. Default is to abort execution.</dd> <dt id="cfg_VerboseMultiSubmit">$cfg['VerboseMultiSubmit'] boolean</dt> <dd>Define whether phpMyAdmin will output the results of each query of a multi-query statement embedded into the <abbr title="structured query language">SQL</abbr> output as inline comments. Defaults to <tt>TRUE</tt>.</dd> <dt id="AllowArbitraryServer"> <span id="cfg_AllowArbitraryServer">$cfg['AllowArbitraryServer']</span> boolean</dt> <dd>If enabled allows you to log in to arbitrary servers using cookie auth. <br /><br /> <b>NOTE:</b> Please use this carefully, as this may allow users access to MySQL servers behind the firewall where your <abbr title="HyperText Transfer Protocol">HTTP</abbr> server is placed. </dd> <dt id="cfg_LeftFrameLight">$cfg['LeftFrameLight'] boolean</dt> <dd>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 <a href="#cfg_LeftFrameTableSeparator" class="configrule">$cfg['LeftFrameTableSeparator']</a> </dd> <dt id="cfg_LeftFrameDBTree">$cfg['LeftFrameDBTree'] boolean</dt> <dd>In light mode, defines whether to display the names of databases (in the selector) using a tree, see also <a href="#cfg_LeftFrameDBSeparator" class="configrule">$cfg['LeftFrameDBSeparator']</a>. </dd> <dt id="cfg_LeftFrameDBSeparator">$cfg['LeftFrameDBSeparator'] string</dt> <dd>The string used to separate the parts of the database name when showing them in a tree.</dd> <dt id="cfg_LeftFrameTableSeparator">$cfg['LeftFrameTableSeparator'] string</dt> <dd>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.</dd> <dt id="cfg_LeftFrameTableLevel">$cfg['LeftFrameTableLevel'] string</dt> <dd>Defines how many sublevels should be displayed when splitting up tables by the above separator.</dd> <dt id="cfg_ShowTooltip">$cfg['ShowTooltip'] boolean</dt> <dd>Defines whether to display table comment as tool-tip in left frame or not.</dd> <dt id="cfg_ShowTooltipAliasDB">$cfg['ShowTooltipAliasDB'] boolean</dt> <dd>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.</dd> <dt id="cfg_ShowTooltipAliasTB">$cfg['ShowTooltipAliasTB'] boolean/string</dt> <dd>Same as <a href="#cfg_ShowTooltipAliasDB" class="configrule">$cfg['ShowTooltipAliasDB']</a>, 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 <a href="#cfg_LeftFrameTableSeparator" class="configrule">$cfg['LeftFrameTableSeparator']</a> directive. So only the folder is called like the Alias, the tablename itself stays the real tablename.</dd> <dt id="cfg_LeftDisplayLogo">$cfg['LeftDisplayLogo'] boolean</dt> <dd>Defines whether or not to display the phpMyAdmin logo at the top of the left frame. Defaults to <tt>TRUE</tt>.</dd> <dt id="cfg_LeftLogoLink">$cfg['LeftLogoLink'] string</dt> <dd>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 <tt>main.php</tt>.</dd> <dt id="cfg_LeftLogoLinkWindow">$cfg['LeftLogoLinkWindow'] string</dt> <dd>Whether to open the linked page in the main window (<tt>main</tt>) or in a new one (<tt>new</tt>).</dd> <dt id="cfg_LeftDisplayServers">$cfg['LeftDisplayServers'] boolean</dt> <dd>Defines whether or not to display a server choice at the top of the left frame. Defaults to FALSE.</dd> <dt id="cfg_DisplayServersList">$cfg['DisplayServersList'] boolean</dt> <dd>Defines whether to display this server choice as links instead of in a drop-down. Defaults to FALSE (drop-down).</dd> <dt id="cfg_DisplayDatabasesList">$cfg['DisplayDatabasesList'] boolean</dt> <dd>Defines whether to display database choice in light navigation frame as links instead of in a drop-down. Defaults to FALSE (drop-down).</dd> <
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -