📄 documentation.txt
字号:
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.$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).$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 Defines whether to display database choice in light navigation frame as links instead of in a drop-down. Defaults to FALSE (drop-down).$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['ShowBlob'] boolean Defines whether or not BLOB fields are shown when browsing a table's content.$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 Defines whether to allow on the fly compression for GZip/BZip2 compressed exports. This doesn't affect smaller dumps and allows users to create larger dumps that won't otherwise fit in memory due to php memory limit. Produced files contain more GZip/BZip2 headers, but all normal programs handle this correctly.$cfg['LightTabs'] boolean If set to TRUE, use less graphically intense tabs on the top of the mainframe.$cfg['PropertiesIconic'] string If set to TRUE, will display icons instead of text for db and table properties links (like 'Browse', 'Select', 'Insert', ...). Can be set to 'both' if you want icons AND text. When set to FALSE, will only show text.$cfg['PropertiesNumColumns'] integer How many columns will be utilized to display the tables on the database property view? Default is 1 column. When setting this to a value larger than 1, the type of the database will be omitted for more display space.$cfg['DefaultTabServer'] string Defines the tab displayed by default on server view. Possible values: "main.php" (recommended for multi-user setups), "server_databases.php", "server_status.php", "server_variables.php", "server_privileges.php" or "server_processlist.php".$cfg['DefaultTabDatabase'] string Defines the tab displayed by default on database view. Possible values: "db_structure.php", "db_sql.php" or "db_search.php".$cfg['DefaultTabTable'] string Defines the tab displayed by default on table view. Possible values: "tbl_structure.php", "tbl_sql.php", "tbl_select.php", "tbl_change.php" or "sql.php".$cfg['MySQLManualBase'] string If set to an URL which points to the MySQL documentation (type depends on $cfg['MySQLManualType']), appropriate help links are generated. See MySQL Documentation page for more information about MySQL manuals and their types.$cfg['MySQLManualType'] string Type of MySQL documentation: + viewable - "viewable online", current one used on MySQL website + searchable - "Searchable, with user comments" + chapters - "HTML, one page per chapter" + big - "HTML, all on one page" + none - do not show documentation links$cfg['DefaultLang'] string Defines the default language to use, if not browser-defined or user-defined. See the select_lang.lib.php script to know the valid values for this setting.$cfg['DefaultConnectionCollation'] string Defines the default connection collation to use, if not user-defined. See the MySQL documentation for list of possible values.$cfg['Lang'] string Force: always use this language (must be defined in the select_lang.lib.php script).$cfg['FilterLanguages'] string Limit list of available languages to those matching the given regular expression. For example if you want only Czech and English, you should set filter to '^(cs|en)'.$cfg['DefaultCharset'] string Default character set to use for recoding of MySQL queries. This must be enabled and it's described by $cfg['AllowAnywhereRecoding'] option. You can give here any character set which is in $cfg['AvailableCharsets'] array and this is just default choice, user can select any of them.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -