📄 config.default.php
字号:
$cfg['Export']['excel_columns'] = FALSE;$cfg['Export']['excel_null'] = 'NULL';$cfg['Export']['excel_edition'] = 'win'; // win/mac$cfg['Export']['latex_structure'] = TRUE;$cfg['Export']['latex_data'] = TRUE;$cfg['Export']['latex_columns'] = TRUE;$cfg['Export']['latex_relation'] = TRUE;$cfg['Export']['latex_comments'] = TRUE;$cfg['Export']['latex_mime'] = TRUE;$cfg['Export']['latex_null'] = '\textit{NULL}';$cfg['Export']['latex_caption'] = TRUE;$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';$cfg['Export']['sql_structure'] = TRUE;$cfg['Export']['sql_data'] = TRUE;$cfg['Export']['sql_compat'] = 'NONE';$cfg['Export']['sql_disable_fk'] = FALSE;$cfg['Export']['sql_use_transaction'] = FALSE;$cfg['Export']['sql_drop_database'] = FALSE;$cfg['Export']['sql_drop_table'] = FALSE;$cfg['Export']['sql_if_not_exists'] = FALSE;$cfg['Export']['sql_auto_increment'] = TRUE;$cfg['Export']['sql_backquotes'] = TRUE;$cfg['Export']['sql_dates'] = FALSE;$cfg['Export']['sql_relation'] = FALSE;$cfg['Export']['sql_columns'] = FALSE;$cfg['Export']['sql_delayed'] = FALSE;$cfg['Export']['sql_ignore'] = FALSE;$cfg['Export']['sql_hex_for_binary'] = TRUE;$cfg['Export']['sql_type'] = 'insert'; // insert/update/replace$cfg['Export']['sql_extended'] = FALSE;$cfg['Export']['sql_max_query_size'] = 50000;$cfg['Export']['sql_comments'] = FALSE;$cfg['Export']['sql_mime'] = FALSE;$cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line/** * Import defaults */$cfg['Import']['format'] = 'sql';$cfg['Import']['allow_interrupt'] = TRUE;$cfg['Import']['skip_queries'] = '0';$cfg['Import']['csv_replace'] = FALSE;$cfg['Import']['csv_terminated'] = ';';$cfg['Import']['csv_enclosed'] = '"';$cfg['Import']['csv_escaped'] = '\\';$cfg['Import']['csv_new_line'] = 'auto';$cfg['Import']['csv_columns'] = '';$cfg['Import']['ldi_replace'] = FALSE;$cfg['Import']['ldi_terminated'] = ';';$cfg['Import']['ldi_enclosed'] = '"';$cfg['Import']['ldi_escaped'] = '\\';$cfg['Import']['ldi_new_line'] = 'auto';$cfg['Import']['ldi_columns'] = '';$cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing/** * Link to the official MySQL documentation. * Be sure to include no trailing slash on the path. * See http://dev.mysql.com/doc/ for more information * about MySQL manuals and their types. */$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';/** * Type of MySQL documentation: * viewable - "viewable online", current one used on MySQL website * searchable - "Searchable, with user comments" * chapters - "HTML, one page per chapter" * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release * big - "HTML, all on one page" * old - old style used in phpMyAdmin 2.3.0 and sooner * none - do not show documentation links */$cfg['MySQLManualType'] = 'viewable';/** * PDF options */$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');$cfg['PDFDefaultPageSize'] = 'A4';/** * Language and charset conversion settings */// Default language to use, if not browser-defined or user-defined$cfg['DefaultLang'] = 'en-iso-8859-1';// Force: always use this language - must be defined in// libraries/select_lang.lib.php// $cfg['Lang'] = 'en-iso-8859-1';// Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and// English only$cfg['FilterLanguages'] = '';// Default charset to use for recoding of MySQL queries, does not take// any effect when charsets recoding is switched off by// $cfg['AllowAnywhereRecoding'] or in language file// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)$cfg['DefaultCharset'] = 'iso-8859-1';// Allow charset recoding of MySQL queries, must be also enabled in language// file to make harder using other language files than unicode.// Default value is FALSE to avoid problems on servers without the iconv// extension and where dl() is not supported$cfg['AllowAnywhereRecoding'] = FALSE;// You can select here which functions will be used for charset conversion.// Possible values are:// auto - automatically use available one (first is tested iconv, then// recode)// iconv - use iconv or libiconv functions// recode - use recode_string function$cfg['RecodingEngine'] = 'auto';// Specify some parameters for iconv used in charset conversion. See iconv// documentation for details:// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html$cfg['IconvExtraParams'] = '';// Available charsets for MySQL conversion. currently contains all which could// be found in lang/* files and few more.// Charsets will be shown in same order as here listed, so if you frequently// use some of these move them to the top.$cfg['AvailableCharsets'] = array( 'iso-8859-1', 'iso-8859-2', 'iso-8859-3', 'iso-8859-4', 'iso-8859-5', 'iso-8859-6', 'iso-8859-7', 'iso-8859-8', 'iso-8859-9', 'iso-8859-10', 'iso-8859-11', 'iso-8859-12', 'iso-8859-13', 'iso-8859-14', 'iso-8859-15', 'windows-1250', 'windows-1251', 'windows-1252', 'windows-1256', 'windows-1257', 'koi8-r', 'big5', 'gb2312', 'utf-16', 'utf-8', 'utf-7', 'x-user-defined', 'euc-jp', 'ks_c_5601-1987', 'tis-620', 'SHIFT_JIS');/** * Customization & design * * The graphical settings are now located in themes/themename/layout.inc.php */$cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer // (used when LeftFrameLight is FALSE) // see also LeftPointerColor // in layout.inc.php$cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer // see also BrowsePointerColor // in layout.inc.php$cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker // see also BrowseMarkerColor // in layout.inc.php$cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode // (this value will be emphasized (*2) for sql // query textareas and (*1.25) for query window)$cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode$cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields$cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox$cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR$cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR$cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing?$cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields$cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse // (or at the top with vertical browse)$cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse // (or at the bottom with vertical browse)$cfg['DefaultDisplay'] = 'horizontal'; // default display direction // (horizontal|vertical|horizontalflipped)$cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/ // creating columns (tbl_properties) // (horizontal|vertical)$cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake) // NOTE: CSS only works in IE browsers!$cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.$cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.$cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)$cfg['EditInWindow'] = TRUE; // Set to TRUE if Edit link should open the query to edit in the query window (assuming Javascript is enabled), and to FALSE if we should edit in the right panel $cfg['QueryWindowWidth'] = 550; // Width of Query window$cfg['QueryWindowHeight'] = 310; // Height of Query window$cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history. // If FALSE, this utilizes JS-routines to display // query history (lost by window close)$cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup // (sql|files|history|full)$cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries // should be kept?$cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for$cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for // table rows.$cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of // the PDF page editor. Requires an IE6/Mozilla based browser.$cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order//-----------------------------------------------------------------------------// custom-setup by mkkeck: 2004-05-04// some specials for new icons and scrollings// FIXME:// 2004-05-08 rabus: We need to rearrange these variables.$cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)?$cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server) // or an other string, wich should be shown in browsers window title. // If not set (or empty), the PMA will get your real Host-Adress.$cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)?$cfg['MainPageIconic'] = TRUE; // show icons in list on main page and on menu tabs (true|false)?$cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocu (true|false)?// theme manager$cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes' // else leave empty$cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty // set it to true, else set it to false (default is false);$cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty // you can set up here an valid path to themes or 'original' for // the original pma-theme$cfg['ThemePerServer'] = FALSE; // allow diferent theme for each configured server//-----------------------------------------------------------------------------/** * Default queries * %d will be replaced by the database name. * %t will be replaced by the table name. * %f will be replaced by a list of field names. * (%t and %f only applies to DefaultQueryTable) */$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';$cfg['DefaultQueryDatabase'] = '';/** * SQL Query box settings * These are the links display in all of the SQL Query boxes */$cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -