phpMyAdmin配置文件config 详解.doc

phpMyAdmin配置文件config.inc.php详解= 4.3.0)-是否使用压缩协议，PHP版本须= 4.3.0$cfgServers$icontroluser = ; / MySQL control user settings / (this user must have read-only$cfgServers$icontrolpass = ; / access to the mysql/user / and mysql/db tables)-MySQL控制用户设定，该用户只对mysql数据库下的user和db表有完全权限color=red$cfgServers$iauth_type = config; / Authentication method (config, http or cookie based)?-如果PHP安装模式为Apache，可以使用http和cookie；如果PHP安装模式为CGI，可以使用cookie；默认为config，是不安全的，不推荐。$cfgServers$iuser = root; / MySQL user-MySQL连接用户$cfgServers$ipassword = ; / MySQL password (only needed with config auth_type)-MySQL连接密码，建议在安装好PHP和MySQL后，先用phpmyadmin设定root密码，然后在这里填写$cfgServers$ionly_db = ; / If set to a db-name, only / this db is displayed / at left frame / It may also be an array / of db-names-如果在这里设定一个数据库的名字，那么登陆后框架左边将只显示这个数据库/color$cfgServers$iverbose = ; / Verbose name for this host - leave blank to show the hostname$cfgServers$ipmadb = ; / Database used for Relation, Bookmark and PDF Features / (see scripts/create_tables.sql) / - leave blank for no support / DEFAULT: phpmyadmin$cfgServers$ibookmarktable = ; / Bookmark table / - leave blank for no bookmark support / DEFAULT: pma_bookmark$cfgServers$irelation = ; / table to describe the relation between links (see doc) / - leave blank for no relation-links support / DEFAULT: pma_relation$cfgServers$itable_info = ; / table to describe the display fields / - leave blank for no display fields support / DEFAULT: pma_table_info$cfgServers$itable_coords = ; / table to describe the tables position for the PDF schema / - leave blank for no PDF schema support / DEFAULT: pma_table_coords$cfgServers$ipdf_pages = ; / table to describe pages of relationpdf / - leave blank if you dont want to use this / DEFAULT: pma_pdf_pages$cfgServers$icolumn_info = ; / table to store column information / - leave blank for no column comments/mime types / DEFAULT: pma_column_info$cfgServers$ihistory = ; / table to store SQL history / - leave blank for no SQL query history / DEFAULT: pma_history$cfgServers$iverbose_check = TRUE; / set to FALSE if you know that your pma_* tables / are up to date. This prevents compatibility / checks and thereby increases performance.$cfgServers$iAllowDenyorder / Host authentication order, leave blank to not use = ;$cfgServers$iAllowDenyrules / Host authentication rules, leave blank for defaults = array();$i+;$cfgServers$ihost = ;$cfgServers$iport = ;$cfgServers$isocket = ;$cfgServers$iconnect_type = tcp;$cfgServers$icompress = FALSE;$cfgServers$icontroluser = ;$cfgServers$icontrolpass = ;$cfgServers$iauth_type = config;$cfgServers$iuser = root;$cfgServers$ipassword = ;$cfgServers$ionly_db = ;$cfgServers$iverbose = ;$cfgServers$ipmadb = ; / phpmyadmin - see scripts/create_tables.sql$cfgServers$ibookmarktable = ; / pma_bookmark$cfgServers$irelation = ; / pma_relation$cfgServers$itable_info = ; / pma_table_info$cfgServers$itable_coords = ; / pma_table_coords$cfgServers$ipdf_pages = ; / pma_pdf_pages$cfgServers$icolumn_info = ; / pma_column_info$cfgServers$ihistory = ; / pma_history$cfgServers$iverbose_check = TRUE;$cfgServers$iAllowDenyorder = ;$cfgServers$iAllowDenyrules = array();$i+;$cfgServers$ihost = ;$cfgServers$iport = ;$cfgServers$isocket = ;$cfgServers$iconnect_type = tcp;$cfgServers$icompress = FALSE;$cfgServers$icontroluser = ;$cfgServers$icontrolpass = ;$cfgServers$iauth_type = config;$cfgServers$iuser = root;$cfgServers$ipassword = ;$cfgServers$ionly_db = ;$cfgServers$iverbose = ;$cfgServers$ipmadb = ; / phpmyadmin - see scripts/create_tables.sql$cfgServers$ibookmarktable = ; / pma_bookmark$cfgServers$irelation = ; / pma_relation$cfgServers$itable_info = ; / pma_table_info$cfgServers$itable_coords = ; / pma_table_coords$cfgServers$ipdf_pages = ; / pma_pdf_pages$cfgServers$icolumn_info = ; / pma_column_info$cfgServers$ihistory = ; / pma_history$cfgServers$iverbose_check = TRUE;$cfgServers$iAllowDenyorder = ;$cfgServers$iAllowDenyrules = array();/ If you have more than one server configured, you can set $cfgServerDefault/ 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, $cfgServerDefault *MUST* be/ set to that server.color=red-是否显示所有的MySQL服务器$cfgServerDefault = 1; / Default server (0 = no default server)$cfgServer = ;unset($cfgServers0);/* Other core phpMyAdmin settings*/color=red$cfgOBGzip = auto; / use GZIP output buffering if possible (TRUE|FALSE|auto)-有必要的话是否使用GZIP输出缓冲$cfgPersistentConnections = FALSE; / use persistent connections to MySQL database-是否使用MySQL持久连接，即pconnect$cfgExecTimeLimit = 300; / maximum execution time in seconds (0 for no limit)-最大脚本执行时间，单位：秒/color$cfgSkipLockedTables = FALSE; / mark used tables, make possible to show / locked tables (since MySQL 3.23.30)color=red$cfgShowSQL = TRUE; / show SQL queries as run-运行查询时显示SQL查询语句$cfgAllowUserDropDatabase = FALSE; / show a Drop database link to normal users-是否对普通用户显示“删除数据库”连接$cfgConfirm = TRUE; / confirm DROP TABLE & DROP DATABASE-删除数据表/库前是否出现确认提示框$cfgLoginCookieRecall = TRUE; / recall previous login in cookie auth. mode or not-是否收回先前cookie认证模式的cookie/color$cfgUseDbSearch = TRUE; / whether to enable the database search feature / or not$cfgIgnoreMultiSubmitErrors = FALSE; / if set to true, PMA continues computing multiple-statement queries / even if one of the queries failed$cfgVerboseMultiSubmit = TRUE; / if set to true, PMA will show the affected rows of EACH statement on / multiple-statement queries. See the read_dump.php file for hardcoded / defaults on how many queries a statement may contain!$cfgAllowArbitraryServer = FALSE; / allow login to any user entered server in cookie based auth/ Left frame setup-左侧框架设置$cfgLeftFrameLight = TRUE; .-是否使用下拉框显示当前数据库/ use a select-based menu and display only the / current tables in the left frame$cfgLeftFrameTableSeparator= _; / Which string will be used to generate table prefixes / to split tables into multiple categories$cfgLeftFrameTableLevel = 1; / How many sublevels should be displayed when splitting / up tables by the above Separator$cfgShowTooltip = TRUE; / display table comment as tooltip in left frame-是否在框架左侧显示数据表内容提示$cfgShowTooltipAliasDB = FALSE; / if ShowToolTip is enabled, this defines that table/db comments$cfgShowTooltipAliasTB = FALSE; / are shown (in the left menu and db_details_structure) instead of / table/db names$cfgLeftDisplayLogo = TRUE; / display logo at top of left frame-是否在框架左侧显示phpmyadmin的logo$cfgLeftDisplayServers = FALSE; / display server choice at top of left frame-是否显示MySQL服务器选择选项color=red/ In the main frame, at startup.-右侧主框架设置(刚进入时)$cfgShowStats = TRUE; / allow to display statistics and space usage in / the pages about database details and table / properties$cfgShowMysqlInfo = FALSE; -是否显示MySQL运行时间/ whether to display the MySQL runtime$cfgShowMysqlVars = FALSE; -是否显示MySQL系统变量/ information, MySQL system variables, PHP$cfgShowPhpInfo = FALSE; -是否显示PHP信息/ information and change password links for$cfgShowChgPassword = FALSE; -修改密码选项/ simple users or not$cfgSuggestDBName = TRUE; -是否显示要建立的数据库默认名字/ suggest a new DB name if possible (false = keep empty)/ In browse mode.$cfgShowBlob = FALSE; / display blob field contents$cfgNavigationBarIconic = TRUE; / do not display text inside navigation bar buttons$cfgShowAll = FALSE; / allows to display all the rows-是否显示所有数据表行$cfgMaxRows = 30; / maximum number of rows to display-数据表行每页显示的数量/color$cfgOrder = 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.$cfgPro