📄 config.default.php
字号:
<?php/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! *//* $Id: config.default.php,v 2.20.2.1 2005/11/23 10:34:32 nijel Exp $ */// vim: expandtab sw=4 ts=4 sts=4:/** * phpMyAdmin default configuration, you can copy values from here to your * config.inc.php * * All directives are explained in Documentation.html *//** * Your phpMyAdmin URL. * * Complete the variable below with the full url ie * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ * * It must contain characters that are valid for a URL, and the path is * case sensitive on some Web servers, for example Unix-based servers. * * In most cases you can leave this variable empty, as the correct value * will be detected automatically. However, we recommend that you do * test to see that the auto-detection code works in your system. A good * test is to browse a table, then edit a row and save it. There will be * an error message if phpMyAdmin cannot auto-detect the correct value. */$cfg['PmaAbsoluteUri'] = '';/** * Disable the default warning that is displayed on the DB Details Structure page if * any of the required Tables for the relationfeatures could not be found */$cfg['PmaNoRelation_DisableWarning'] = FALSE;/** * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If * at least one server configuration uses 'cookie' auth_type, enter here a * passphrase that will be used by blowfish. The maximum length seems to be 46 * characters. */$cfg['blowfish_secret'] = '';/** * Server(s) configuration */$i = 0;// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use// $cfg['Servers'][0]. You can disable a server config entry by setting host// to ''. If you want more than one server, just copy following section// (including $i incrementation) serveral times. There is no need to define// full server array, just define values you need to change.$i++;$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // (requires PHP >= 4.3.0)$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables). // The controluser is also // used for all relational // features (pmadb)$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?$cfg['Servers'][$i]['user'] = 'root'; // MySQL user$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type)$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only // this db is displayed in left frame // It may also be an array of db-names, where sorting order is relevant.$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features // (see scripts/create_tables.sql) // - leave blank for no support // DEFAULT: 'phpmyadmin'$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table // - leave blank for no bookmark support // DEFAULT: 'pma_bookmark'$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) // - leave blank for no relation-links support // DEFAULT: 'pma_relation'$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields // - leave blank for no display fields support // DEFAULT: 'pma_table_info'$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema // - leave blank for no PDF schema support // DEFAULT: 'pma_table_coords'$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf // - leave blank if you don't want to use this // DEFAULT: 'pma_pdf_pages'$cfg['Servers'][$i]['column_info'] = ''; // table to store column information // - leave blank for no column comments/mime types // DEFAULT: 'pma_column_info'$cfg['Servers'][$i]['history'] = ''; // table to store SQL history // - leave blank for no SQL query history // DEFAULT: 'pma_history'$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables // are up to date. This prevents compatibility // checks and thereby increases performance.$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use = '';$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults = array();// 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['ServerDefault'] = 1; // Default server (0 = no default server)/** * Other core phpMyAdmin settings */$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database$cfg['ForceSLL'] = FALSE; // whether to force using https$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)$cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show // locked tables (since MySQL 3.23.30)$cfg['ShowSQL'] = TRUE; // show SQL queries as run$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not$cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds)$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature // or not$cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries // even if one of the queries failed$cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on // multiple-statement queries. See the libraries/import.php file for // hardcoded defaults on how many queries a statement may contain!$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth// Left frame setup$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the // current tables in the left frame.$cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree$cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree$cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes // to split/nest tables into multiple categories$cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting // up tables by the above Separator$cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame$cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments$cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of // table/db names. Setting ShowTooltipAliasTB to 'nested' will only // use the Aliases for nested descriptors, not the table itself.$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame$cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame$cfg['DisplayServersList'] = FALSE; // server choice as links// In the main frame, at startup...$cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in // the pages about database details and table // properties$cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for$cfg['ShowChgPassword'] = FALSE; // simple users or not$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)// In browse mode...$cfg['ShowBlob'] = FALSE; // display blob field contents$cfg['NavigationBarIconic'] = 'both'; // Use icons instead of text for the navigation bar buttons // and on right panel top menu (server db table) (TRUE|FALSE|'both')$cfg['ShowAll'] = FALSE; // allows to display all the rows$cfg['MaxRows'] = 30; // maximum number of rows to display$cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid // values are 'ASC', 'DESC' or 'SMART' -ie // descending order for fields of type // TIME, DATE, DATETIME & TIMESTAMP, // ascending order else-)// In edit mode...$cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields // valid values are: // FALSE allow editing // 'blob' allow editing except for BLOB fields // 'all' disallow editing$cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode$cfg['CharEditing'] = 'input'; // Which editor should be used for CHAR/VARCHAR fields: // input - allows limiting of input length // textarea - allows newlines in fields$cfg['InsertRows'] = 2; // How many rows can be inserted at one time$cfg['ForeignKeyDropdownOrder'] = // Sort order for items in a foreign-key dropdown box. array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.$cfg['ForeignKeyMaxLimit'] = 100; // A dropdown will be used if fewer items are present// For the export features...$cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip$cfg['GZipDump'] = TRUE; // compression for$cfg['BZipDump'] = TRUE; // dump files$cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on // fly without need for much memory. // If you encounter problems with // created gzip/bzip2 files disable // this feature.// Tabs display settings$cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs$cfg['PropertiesIconic'] = TRUE; // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')$cfg['PropertiesNumColumns'] = 1; // How many columns should be used for table display of a database? // (a value larger than 1 results in some information being hidden)$cfg['DefaultTabServer'] = 'main.php'; // Possible values: // 'main.php' = the welcome page // (recommended for multiuser setups) // 'server_databases.php' = list of databases // 'server_status.php' = runtime information // 'server_variables.php' = MySQL server variables // 'server_privileges.php' = user management // 'server_processlist.php' = process list$cfg['DefaultTabDatabase'] = 'db_details_structure.php'; // Possible values: // 'db_details_structure.php' = tables list // 'db_details.php' = sql form // 'db_search.php' = search query // 'db_operations.php' = operations on database$cfg['DefaultTabTable'] = 'tbl_properties_structure.php'; // Possible values: // 'tbl_properties_structure.php' = fields list // 'tbl_properties.php' = sql form // 'tbl_select.php = select page // 'tbl_change.php = insert row page/** * Export defaults */$cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword$cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2$cfg['Export']['asfile'] = FALSE;$cfg['Export']['charset'] = '';$cfg['Export']['onserver'] = FALSE;$cfg['Export']['onserver_overwrite'] = FALSE;$cfg['Export']['remember_file_template'] = TRUE;$cfg['Export']['file_template_table'] = '__TABLE__';$cfg['Export']['file_template_database'] = '__DB__';$cfg['Export']['file_template_server'] = '__SERVER__';$cfg['Export']['htmlexcel_columns'] = FALSE;$cfg['Export']['htmlexcel_null'] = 'NULL';$cfg['Export']['htmlword_structure'] = TRUE;$cfg['Export']['htmlword_data'] = TRUE;$cfg['Export']['htmlword_columns'] = FALSE;$cfg['Export']['htmlword_null'] = 'NULL';$cfg['Export']['xls_columns'] = FALSE;$cfg['Export']['xls_null'] = 'NULL';$cfg['Export']['csv_columns'] = FALSE;$cfg['Export']['csv_null'] = 'NULL';$cfg['Export']['csv_separator'] = ';';$cfg['Export']['csv_enclosed'] = '"';$cfg['Export']['csv_escaped'] = '\\';$cfg['Export']['csv_terminated'] = 'AUTO';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -