📄 documentation.html
字号:
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]['history']</tt> </li> </ul> </dd> <dt id="designer_coords"> <span id="cfg_Servers_designer_coords">$cfg['Servers'][$i]['designer_coords']</span> string </dt> <dd>Since release 2.10.0 a Designer interface is available; it permits to visually manage the relations. <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 table name in <tt>$cfg['Servers'][$i]['designer_coords']</tt> </li> </ul> </dd> <dt><span id="cfg_Servers_verbose_check">$cfg['Servers'][$i]['verbose_check']</span> boolean </dt> <dd>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 <tt>TRUE</tt> (default) phpMyAdmin will check if you have the latest table structure available. If not, it will emit a warning to the superuser.<br /><br /> You can disable this checking behavior by setting the variable to false, which should offer a performance increase.<br /><br /> Recommended to set to FALSE, when you are sure, your table structure is up to date.</dd> <dt><span id="cfg_Servers_AllowRoot">$cfg['Servers'][$i]['AllowRoot']</span> boolean</dt> <dd>Whether to allow root access. This is just a shortcut for the AllowDeny rules below. </dd> <dt><span id="cfg_Servers_AllowNoPasswordRoot">$cfg['Servers'][$i]['AllowNoPasswordRoot']</span> boolean</dt> <dd>Whether to allow access to root user without password. The default value of <tt>false</tt> for this parameter prevents unintended access to a MySQL server with was left with an empty password for root. </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_MaxDbList">$cfg['MaxDbList'] integer</dt> <dd>The maximum number of database names to be displayed in the navigation frame and the database list.</dd> <dt id="cfg_MaxTableList">$cfg['MaxTableList'] integer</dt> <dd>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.</dd> <dt id="cfg_MaxCharactersInDisplayedSQL">$cfg['MaxCharactersInDisplayedSQL'] integer</dt> <dd>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.</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.<br /><br /> This is automatically diabled if you do not have configured <tt><a href="#cfg_blowfish_secret">$cfg['blowfish_secret']</a></tt>. </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_LeftFrameTable
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -