Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

在线求助!!Cookies 必须启用才能登入!!

[复制链接]
kj861 发表于 2007-10-14 11:13:39 | 显示全部楼层 |阅读模式
我是特级菜鸟,昨晚折腾通宵了,在网上查找了很多资料,还是没能解决问题,今天红着双眼向高手们求救,帮帮我呀!
因为我的商店系统(http://shop.kj86.com/)数据库出错,需要修复数据库,空间商不肯帮助修复,所以得安装phpMyAdmin自己摸索着修复。

现在http://www.kj86.com/phpMyAdmin/提示“Cookies 必须启用才能登入!!”,不知道是什么原因。我的config.inc.php配置如下,请大家都我看看是不是配置上的问题。

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* <code>
* N   N  OOO  !!   DDDD   OOO    N   N  OOO  TTTTT   EEEE DDDD  I TTTTT !!
* NN  N O   O !!   D   D O   O   NN  N O   O   T     E    D   D I   T   !!
* N N N O   O !!   D   D O   O   N N N O   O   T     EEEE D   D I   T   !!
* N  NN O   O      D   D O   O   N  NN O   O   T     E    D   D I   T
* N   N  OOO  !!   DDDD   OOO    N   N  OOO    T     EEEE DDDD  I   T   !!
* </code>
*
* DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
*
* phpMyAdmin default configuration, you can copy values from here to your
* config.inc.php
*
* All directives are explained in Documentation.html
*
* @version $Id: config.default.php 10556 2007-08-11 13:11:31Z lem9 $
*/
/**
* 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.
*
* @global string $cfg['PmaAbsoluteUri']
*/
$cfg['PmaAbsoluteUri'] = 'http://www.kj86.com/phpMyAdmin/';
/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relation features could not be found
*
* @global boolean $cfg['PmaNoRelation_DisableWarning']
*/
$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
* pass phrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*
* @global string $cfg['blowfish_secret']
*/
$cfg['blowfish_secret'] = 'www.kj86.com';

/*******************************************************************************
* Server(s) configuration
*
* The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
* $cfg['Servers'][0]. You can disable a server configuration entry by setting host
* to ''. If you want more than one server, just copy following section
* (including $i incrementation) several times. There is no need to define
* full server array, just define values you need to change.
*
* @global array $cfg['Servers']
*/
$cfg['Servers'] = array();
$i = 1;
/**
* MySQL hostname or IP address
*
* @global string $cfg['Servers'][$i]['host']
*/
$cfg['Servers'][$i]['host'] = 'localhost';
/**
* MySQL port - leave blank for default port
*
* @global string $cfg['Servers'][$i]['port']
*/
$cfg['Servers'][$i]['port'] = '';
/**
* Path to the socket - leave blank for default socket
*
* @global string $cfg['Servers'][$i]['socket']
*/
$cfg['Servers'][$i]['socket'] = '';
/**
* Use SSL for connecting to MySQL server?
*
* @global boolean $cfg['Servers'][$i]['ssl']
*/
$cfg['Servers'][$i]['ssl'] = false;
/**
* How to connect to MySQL server ('tcp' or 'socket')
*
* @global string $cfg['Servers'][$i]['connect_type']
*/
$cfg['Servers'][$i]['connect_type'] = 'tcp';
/**
* The PHP MySQL extension to use ('mysql' or 'mysqli')
*
* @global string $cfg['Servers'][$i]['extension']
*/
$cfg['Servers'][$i]['extension'] = 'mysql';
/**
* Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
*
* @global boolean $cfg['Servers'][$i]['compress']
*/
$cfg['Servers'][$i]['compress'] = false;
/**
* MySQL control user settings (this user must have read-only
*
* @global string $cfg['Servers'][$i]['controluser']
*/
$cfg['Servers'][$i]['controluser'] = '';
/**
* access to the "mysql/user" and "mysql/db" tables). The controluser is also
* used for all relational features (pmadb)
*
* @global string $cfg['Servers'][$i]['controlpass']
*/
$cfg['Servers'][$i]['controlpass'] = '';
/**
* Authentication method (valid choices: config, http, signon or cookie)
*
* @global string $cfg['Servers'][$i]['auth_type']
*/
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/**
* MySQL user
*
* @global string $cfg['Servers'][$i]['user']
*/
$cfg['Servers'][$i]['user'] = '这里我填的是数据库名称';
/**
* MySQL password (only needed with 'config' auth_type)
*
* @global string $cfg['Servers'][$i]['password']
*/
$cfg['Servers'][$i]['password'] = '这里填数据库密码';
/**
* Session to use for 'signon' authentication method
*
* @global string $cfg['Servers'][$i]['SignonSession']
*/
$cfg['Servers'][$i]['SignonSession'] = '';
/**
* URL where to redirect user to login for 'signon' authentication method
*
* @global string $cfg['Servers'][$i]['SignonURL']
*/
$cfg['Servers'][$i]['SignonURL'] = '';
/**
* URL where to redirect user after logout
*
* @global string $cfg['Servers'][$i]['LogoutURL']
*/
$cfg['Servers'][$i]['LogoutURL'] = '';
/**
* Whether to try to connect without password
*
* @global boolean $cfg['Servers'][$i]['nopassword']
*/
$cfg['Servers'][$i]['nopassword'] = false;
/**
* 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.
*
* @global string $cfg['Servers'][$i]['only_db']
*/
$cfg['Servers'][$i]['only_db'] = '';
/**
* Database name to be hidden from listings
*
* @global string $cfg['Servers'][$i]['hide_db']
*/
$cfg['Servers'][$i]['hide_db'] = '';
/**
* Verbose name for this host - leave blank to show the hostname
* (for HTTP authentication, all non-US-ASCII characters will be stripped)
*
* @global string $cfg['Servers'][$i]['verbose']
*/
$cfg['Servers'][$i]['verbose'] = '';
/**
* Database used for Relation, Bookmark and PDF Features
* (see scripts/create_tables.sql)
*   - leave blank for no support
*     DEFAULT: 'phpmyadmin'
*
* @global string $cfg['Servers'][$i]['pmadb']
*/
$cfg['Servers'][$i]['pmadb'] = '';
/**
* Bookmark table
*   - leave blank for no bookmark support
*     DEFAULT: 'pma_bookmark'
*
* @global string $cfg['Servers'][$i]['bookmarktable']
*/
$cfg['Servers'][$i]['bookmarktable'] = '';
/**
* table to describe the relation between links (see doc)
*   - leave blank for no relation-links support
*     DEFAULT: 'pma_relation'
*
* @global string $cfg['Servers'][$i]['relation']
*/
$cfg['Servers'][$i]['relation'] = '';
/**
* table to describe the display fields
*   - leave blank for no display fields support
*     DEFAULT: 'pma_table_info'
*
* @global string $cfg['Servers'][$i]['table_info']
*/
$cfg['Servers'][$i]['table_info'] = '';
/**
* table to describe the tables position for the PDF schema
*   - leave blank for no PDF schema support
*     DEFAULT: 'pma_table_coords'
*
* @global string $cfg['Servers'][$i]['table_coords']
*/
$cfg['Servers'][$i]['table_coords'] = '';
/**
* table to describe pages of relationpdf
*   - leave blank if you don't want to use this
*     DEFAULT: 'pma_pdf_pages'
*
* @global string $cfg['Servers'][$i]['pdf_pages']
*/
$cfg['Servers'][$i]['pdf_pages'] = '';
/**
* table to store column information
*   - leave blank for no column comments/mime types
*     DEFAULT: 'pma_column_info'
*
* @global string $cfg['Servers'][$i]['column_info']
*/
$cfg['Servers'][$i]['column_info'] = '';
/**
* table to store SQL history
*   - leave blank for no SQL query history
*     DEFAULT: 'pma_history'
*
* @global string $cfg['Servers'][$i]['history']
*/
$cfg['Servers'][$i]['history'] = '';
/**
* table to store the coordinates for Designer
*   - leave blank for no Designer feature
*     DEFAULT: 'pma_designer_coords'
*
* @global string $cfg['Servers'][$i]['designer_coords']
*/
$cfg['Servers'][$i]['designer_coords'] = '';
/**
* set to false if you know that your pma_* tables are up to date.
* This prevents compatibility checks and thereby increases performance.
*
* @global boolean $cfg['Servers'][$i]['verbose_check']
*/
$cfg['Servers'][$i]['verbose_check'] = true;
/**
* whether to allow root login
*
* @global boolean $cfg['Servers'][$i]['AllowRoot']
*/
$cfg['Servers'][$i]['AllowRoot'] = true;
/**
* Host authentication order, leave blank to not use
*
* @global string $cfg['Servers'][$i]['AllowDeny']['order']
*/
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
/**
* Host authentication rules, leave blank for defaults
*
* @global array $cfg['Servers'][$i]['AllowDeny']['rules']
*/
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();
/**
* Default server (0 = no default server)
*
* If you have more than one server configured, you can set $cfg['ServerDefault']
* to any one of them to auto-connect 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.
*
* @global integer $cfg['ServerDefault']
*/
$cfg['ServerDefault'] = 1;
/*
* Other core phpMyAdmin settings
*/
/**
* maximum number of db's displayed in left frame and database list
*
* @global integer $cfg['MaxDbList']
*/
$cfg['MaxDbList'] = 100;
/**
* maximum number of tables displayed in table list
*
* @global integer $cfg['MaxTableList']
*/
$cfg['MaxTableList'] = 250;
/**
* maximum number of characters when a SQL query is displayed
*
* @global integer $cfg['MaxCharactersInDisplayedSQL']
*/
$cfg['MaxCharactersInDisplayedSQL'] = 1000;
/**
* use GZIP output buffering if possible (true|false|'auto')
*
* @global string $cfg['OBGzip']
*/
$cfg['OBGzip'] = 'auto';
/**
* use persistent connections to MySQL database
*
* @global boolean $cfg['PersistentConnections']
*/
$cfg['PersistentConnections'] = false;
/**
* whether to force using HTTPS
*
* @global boolean $cfg['ForceSSL']
*/
$cfg['ForceSSL'] = false;
/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 300;
/**
* maximum allocated bytes (0 for no limit)
*
* @global integer $cfg['MemoryLimit']
*/
$cfg['MemoryLimit'] = 0;
/**
* mark used tables, make possible to show locked tables (since MySQL 3.23.30)
*
* @global boolean $cfg['SkipLockedTables']
*/
$cfg['SkipLockedTables'] = false;
/**
* show SQL queries as run
*
* @global boolean $cfg['ShowSQL']
*/
$cfg['ShowSQL'] = true;
/**
* show a 'Drop database' link to normal users
*
* @global boolean $cfg['AllowUserDropDatabase']
*/
$cfg['AllowUserDropDatabase'] = false;
/**
* confirm 'DROP TABLE' & 'DROP DATABASE'
*
* @global boolean $cfg['Confirm']
*/
$cfg['Confirm'] = true;
/**
* recall previous login in cookie authentication mode or not
*
* @global boolean $cfg['LoginCookieRecall']
*/
$cfg['LoginCookieRecall'] = true;
/**
* validity of cookie login (in seconds)
*
* @global integer $cfg['LoginCookieValidity']
*/
$cfg['LoginCookieValidity'] = 1800;
/**
* how long login cookie should be stored (in seconds)
*
* @global integer $cfg['LoginCookieStore']
*/
$cfg['LoginCookieStore'] = 0;
/**
* whether to delete all login cookies on logout
*
* @global boolean $cfg['LoginCookieDeleteAll']
*/
$cfg['LoginCookieDeleteAll'] = true;
/**
* whether to enable the "database search" feature or not
*
* @global boolean $cfg['UseDbSearch']
*/
$cfg['UseDbSearch'] = true;
/**
* if set to true, PMA continues computing multiple-statement queries
* even if one of the queries failed
*
* @global boolean $cfg['IgnoreMultiSubmitErrors']
*/
$cfg['IgnoreMultiSubmitErrors'] = false;
/**
* if set to true, PMA will show the affected rows of EACH statement on
* multiple-statement queries. See the libraries/import.php file for
* hard coded defaults on how many queries a statement may contain!
*
* @global boolean $cfg['VerboseMultiSubmit']
*/
$cfg['VerboseMultiSubmit'] = true;
/**
* allow login to any user entered server in cookie based authentication
*
* @global boolean $cfg['AllowArbitraryServer']
*/
$cfg['AllowArbitraryServer'] = false;

/*******************************************************************************
* Left frame setup
*/
/**
* use a select-based menu and display only the current tables in the left frame.
*
* @global boolean $cfg['LeftFrameLight']
*/
$cfg['LeftFrameLight'] = true;
/**
* turn the select-based light menu into a tree
*
* @global boolean $cfg['LeftFrameDBTree']
*/
$cfg['LeftFrameDBTree'] = true;
/**
* the separator to sub-tree the select-based light menu tree
*
* @global string $cfg['LeftFrameDBSeparator']
*/
$cfg['LeftFrameDBSeparator'] = '_';
/**
* Which string will be used to generate table prefixes
* to split/nest tables into multiple categories
*
* @global string $cfg['LeftFrameTableSeparator']
*/
$cfg['LeftFrameTableSeparator']= '__';
/**
* How many sublevels should be displayed when splitting up tables by the above Separator
*
* @global integer $cfg['LeftFrameTableLevel']
*/
$cfg['LeftFrameTableLevel'] = '1';
/**
* display table comment as tooltip in left frame
*
* @global boolean $cfg['ShowTooltip']
*/
$cfg['ShowTooltip'] = true;
/**
* if ShowToolTip is enabled, this defines that table/db comments
*
* @global boolean $cfg['ShowTooltipAliasDB']
*/
$cfg['ShowTooltipAliasDB'] = false;
/**
* are shown (in the left menu and db_structure) instead of table/db names.
* Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested
* descriptors, not the table itself.
*
* @global boolean $cfg['ShowTooltipAliasTB']
*/
$cfg['ShowTooltipAliasTB'] = false;
/**
* display logo at top of left frame
*
* @global boolean $cfg['LeftDisplayLogo']
*/
$cfg['LeftDisplayLogo'] = true;
/**
* where should logo link point to (can also contain an external URL)
*
* @global string $cfg['LeftLogoLink']
*/
$cfg['LeftLogoLink'] = 'main.php';
/**
* whether to open the linked page in the main window ('main') or
* in a new window ('new')
*
* @global string $cfg['LeftLogoLinkWindow']
*/
$cfg['LeftLogoLinkWindow'] = 'main';
/**
* display server choice at top of left frame
*
* @global boolean $cfg['LeftDisplayServers']
*/
$cfg['LeftDisplayServers'] = false;
/**
* server choice as links
*
* @global boolean $cfg['DisplayServersList']
*/
$cfg['DisplayServersList'] = false;
/**
* database choice in light as links
*
* @global boolean $cfg['DisplayDatabasesList']
*/
$cfg['DisplayDatabasesList'] = 'auto';

/*******************************************************************************
* In the main frame, at startup...
*/
/**
* allow to display statistics and space usage in the pages about database
* details and table properties
*
* @global boolean $cfg['ShowStats']
*/
$cfg['ShowStats'] = true;
/**
* show PHP info link
*
* @global boolean $cfg['ShowPhpInfo']
*/
$cfg['ShowPhpInfo'] = false;
/**
* show MySQL server information
*
* @global boolean $cfg['ShowServerInfo']
*/
$cfg['ShowServerInfo'] = true;
/**
* show change password link
*
* @global boolean $cfg['ShowChgPassword']
*/
$cfg['ShowChgPassword'] = false;
/**
* show create database form
*
* @global boolean $cfg['ShowCreateDb']
*/
$cfg['ShowCreateDb'] = true;
/**
* suggest a new DB name if possible (false = keep empty)
*
* @global boolean $cfg['SuggestDBName']
*/
$cfg['SuggestDBName'] = true;

/*******************************************************************************
* In browse mode...
*/
/**
* display blob field contents
*
* @global boolean $cfg['ShowBlob']
*/
$cfg['ShowBlob'] = false;
/**
* Use icons instead of text for the navigation bar buttons
* and on right panel top menu (server db table) (true|false|'both')
*
* @global string $cfg['NavigationBarIconic']
*/
$cfg['NavigationBarIconic'] = 'both';
/**
* allows to display all the rows
*
* @global boolean $cfg['ShowAll']
*/
$cfg['ShowAll'] = false;
/**
* maximum number of rows to display
*
* @global integer $cfg['MaxRows']
*/
$cfg['MaxRows'] = 30;
/**
* 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-)
*
* @global string $cfg['Order']
*/
$cfg['Order'] = 'ASC';

/*******************************************************************************
* In edit mode...
*/
/**
* disallow editing of binary fields
* valid values are:
*   false  allow editing
*   'blob' allow editing except for BLOB fields
*   'all'  disallow editing
*
* @global string $cfg['ProtectBinary']
*/
$cfg['ProtectBinary'] = 'blob';
/**
* Display the function fields in edit/insert mode
*
* @global boolean $cfg['ShowFunctionFields']
*/
$cfg['ShowFunctionFields'] = true;
/**
* Which editor should be used for CHAR/VARCHAR fields:
*  input - allows limiting of input length
*  textarea - allows newlines in fields
*
* @global string $cfg['CharEditing']
*/
$cfg['CharEditing'] = 'input';
/**
* How many rows can be inserted at one time
*
* @global integer $cfg['InsertRows']
*/
$cfg['InsertRows'] = 2;
/**
* Sort order for items in a foreign-key drop-down list.
* 'content' is the referenced data, 'id' is the key value.
*
* @global array $cfg['ForeignKeyDropdownOrder']
*/
$cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
/**
* A drop-down list will be used if fewer items are present
*
* @global integer $cfg['ForeignKeyMaxLimit']
*/
$cfg['ForeignKeyMaxLimit'] = 100;

/*******************************************************************************
* For the export features...
*/
/**
* Allow the use of zip/gzip/bzip
*
* @global boolean $cfg['ZipDump']
*/
$cfg['ZipDump'] = true;
/**
* compression for
*
* @global boolean $cfg['GZipDump']
*/
$cfg['GZipDump'] = true;
/**
* dump files
*
* @global boolean $cfg['BZipDump']
*/
$cfg['BZipDump'] = 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.
*
* @global boolean $cfg['CompressOnFly']
*/
$cfg['CompressOnFly'] = true;

/*******************************************************************************
* Tabs display settings
*/
/**
* use graphically less intense menu tabs
*
* @global boolean $cfg['LightTabs']
*/
$cfg['LightTabs'] = false;
/**
* Use icons instead of text for the table display of a database (true|false|'both')
*
* @global boolean $cfg['PropertiesIconic']
*/
$cfg['PropertiesIconic'] = true;
/**
* How many columns should be used for table display of a database?
* (a value larger than 1 results in some information being hidden)
*
* @global integer $cfg['PropertiesNumColumns']
*/
$cfg['PropertiesNumColumns'] = 1;
/**
* 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
*
* @global string $cfg['DefaultTabServer']
*/
$cfg['DefaultTabServer'] = 'main.php';
/**
* Possible values:
* 'db_structure.php' = tables list
* 'db_sql.php' = SQL form
* 'db_search.php' = search query
* 'db_operations.php' = operations on database
*
* @global string $cfg['DefaultTabDatabase']
*/
$cfg['DefaultTabDatabase'] = 'db_structure.php';
/**
* Possible values:
* 'tbl_structure.php' = fields list
* 'tbl_sql.php' = SQL form
* 'tbl_select.php' = select page
* 'tbl_change.php' = insert row page
* 'sql.php' = browse page
*
* @global string $cfg['DefaultTabTable']
*/
$cfg['DefaultTabTable'] = 'tbl_structure.php';

/*******************************************************************************
* Export defaults
*/
$cfg['Export'] = array();
/**
* sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt
*
* @global string $cfg['Export']['format']
*/
$cfg['Export']['format'] = 'sql';
/**
* none/zip/gzip/bzip2
*
* @global string $cfg['Export']['compression']
*/
$cfg['Export']['compression'] = 'none';
/**
*
*
* @global boolean $cfg['Export']['asfile']
*/
$cfg['Export']['asfile'] = false;
/**
*
*
* @global string $cfg['Export']['charset']
*/
$cfg['Export']['charset'] = '';
/**
*
*
* @global boolean $cfg['Export']['onserver']
*/
$cfg['Export']['onserver'] = false;
/**
*
*
* @global boolean $cfg['Export']['onserver_overwrite']
*/
$cfg['Export']['onserver_overwrite'] = false;
/**
*
*
* @global boolean $cfg['Export']['remember_file_template']
*/
$cfg['Export']['remember_file_template'] = true;
/**
*
*
* @global string $cfg['Export']['file_template_table']
*/
$cfg['Export']['file_template_table'] = '__TABLE__';
/**
*
*
* @global string $cfg['Export']['file_template_database']
*/
$cfg['Export']['file_template_database'] = '__DB__';
/**
*
*
* @global string $cfg['Export']['file_template_server']
*/
$cfg['Export']['file_template_server'] = '__SERVER__';
/**
*
*
* @global boolean $cfg['Export']['ods_columns']
*/
$cfg['Export']['ods_columns'] = false;
/**
*
*
* @global string $cfg['Export']['ods_null']
*/
$cfg['Export']['ods_null'] = 'NULL';
/**
*
*
* @global boolean $cfg['Export']['odt_structure']
*/
$cfg['Export']['odt_structure'] = true;
/**
*
*
* @global boolean $cfg['Export']['odt_data']
*/
$cfg['Export']['odt_data'] = true;
/**
*
*
* @global boolean $cfg['Export']['odt_columns']
*/
$cfg['Export']['odt_columns'] = true;
/**
*
*
* @global boolean $cfg['Export']['odt_relation']
*/
$cfg['Export']['odt_relation'] = true;
/**
*
*
* @global boolean $cfg['Export']['odt_comments']
*/
$cfg['Export']['odt_comments'] = true;
/**
*
*
* @global boolean $cfg['Export']['odt_mime']
*/
$cfg['Export']['odt_mime'] = true;
/**
*
*
* @global string $cfg['Export']['odt_null']
*/
$cfg['Export']['odt_null'] = 'NULL';
/**
*
*
* @global boolean $cfg['Export']['htmlexcel_columns']
*/
$cfg['Export']['htmlexcel_columns'] = false;
/**
*
*
* @global string $cfg['Export']['htmlexcel_null']
*/
$cfg['Export']['htmlexcel_null'] = 'NULL';
/**
*
*
* @global boolean $cfg['Export']['htmlword_structure']
*/
$cfg['Export']['htmlword_structure'] = true;
/**
*
*
* @global boolean $cfg['Export']['htmlword_data']
*/
$cfg['Export']['htmlword_data'] = true;
/**
*
*
* @global boolean $cfg['Export']['htmlword_columns']
*/
$cfg['Export']['htmlword_columns'] = false;
/**
*
*
* @global string $cfg['Export']['htmlword_null']
*/
$cfg['Export']['htmlword_null'] = 'NULL';
/**
*
*
* @global boolean $cfg['Export']['xls_columns']
*/
$cfg['Export']['xls_columns'] = false;
/**
*
*
* @global string $cfg['Export']['xls_null']
*/
$cfg['Export']['xls_null'] = 'NULL';
/**
*
*
* @global boolean $cfg['Export']['csv_columns']
*/
$cfg['Export']['csv_columns'] = false;
/**
*
*
* @global string $cfg['Export']['csv_null']
*/
$cfg['Export']['csv_null'] = 'NULL';
/**
*
*
* @global string $cfg['Export']['csv_separator']
*/
$cfg['Export']['csv_separator'] = ';';
/**
*
*
* @global string $cfg['Export']['csv_enclosed']
*/
$cfg['Export']['csv_enclosed'] = '"';
/**
*
*
* @global string $cfg['Export']['csv_escaped']
*/
$cfg['Export']['csv_escaped'] = '\\';
/**
*
*
* @global string $cfg['Export']['csv_terminated']
*/
$cfg['Export']['csv_terminated'] = 'AUTO';
/**
*
*
* @global boolean $cfg['Export']['excel_columns']
*/
$cfg['Export']['excel_columns'] = false;
/**
*
*
* @global string $cfg['Export']['excel_null']
*/
$cfg['Export']['excel_null'] = 'NULL';
/**
* win/mac
*
* @global string $cfg['Export']['excel_edition']
*/
$cfg['Export']['excel_edition'] = 'win';
/**
*
*
* @global boolean $cfg['Export']['latex_structure']
*/
$cfg['Export']['latex_structure'] = true;
/**
*
*
* @global boolean $cfg['Export']['latex_data']
*/
$cfg['Export']['latex_data'] = true;
/**
*
*
* @global boolean $cfg['Export']['latex_columns']
*/
$cfg['Export']['latex_columns'] = true;
/**
*
*
* @global boolean $cfg['Export']['latex_relation']
*/
$cfg['Export']['latex_relation'] = true;
/**
*
*
* @global boolean $cfg['Export']['latex_comments']
*/
$cfg['Export']['latex_comments'] = true;
/**
*
*
* @global boolean $cfg['Export']['latex_mime']
*/
$cfg['Export']['latex_mime'] = true;
/**
*
*
* @global string $cfg['Export']['latex_null']
*/
$cfg['Export']['latex_null'] = '\textit{NULL}';
/**
*
*
* @global boolean $cfg['Export']['latex_caption']
*/
$cfg['Export']['latex_caption'] = true;
/**
*
*
* @global string $cfg['Export']['latex_structure_caption']
*/
$cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
/**
*
*
* @global string $cfg['Export']['latex_structure_continued_caption']
*/
$cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
/**
*
*
* @global string $cfg['Export']['latex_data_caption']
*/
$cfg['Export']['latex_data_caption'] = 'strLatexContent';
/**
*
*
* @global string $cfg['Export']['latex_data_continued_caption']
*/
$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
/**
*
*
* @global string $cfg['Export']['latex_data_label']
*/
$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
/**
*
*
* @global string $cfg['Export']['latex_structure_label']
*/
$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
/**
*
*
* @global boolean $cfg['Export']['sql_structure']
*/
$cfg['Export']['sql_structure'] = true;
/**
*
*
* @global boolean $cfg['Export']['sql_data']
*/
$cfg['Export']['sql_data'] = true;
/**
*
*
* @global string $cfg['Export']['sql_compatibility']
*/
$cfg['Export']['sql_compatibility'] = 'NONE';
/**
*
*
* @global boolean $cfg['Export']['sql_disable_fk']
*/
$cfg['Export']['sql_disable_fk'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_use_transaction']
*/
$cfg['Export']['sql_use_transaction'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_drop_database']
*/
$cfg['Export']['sql_drop_database'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_drop_table']
*/
$cfg['Export']['sql_drop_table'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_if_not_exists']
* true by default for correct behavior when dealing with exporting
* of VIEWs and the stand-in table
*/
$cfg['Export']['sql_if_not_exists'] = true;
/**
*
*
* @global boolean $cfg['Export']['sql_procedure_function']
*/
$cfg['Export']['sql_procedure_function'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_auto_increment']
*/
$cfg['Export']['sql_auto_increment'] = true;
/**
*
*
* @global boolean $cfg['Export']['sql_backquotes']
*/
$cfg['Export']['sql_backquotes'] = true;
/**
*
*
* @global boolean $cfg['Export']['sql_dates']
*/
$cfg['Export']['sql_dates'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_relation']
*/
$cfg['Export']['sql_relation'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_columns']
*/
$cfg['Export']['sql_columns'] = true;
/**
*
*
* @global boolean $cfg['Export']['sql_delayed']
*/
$cfg['Export']['sql_delayed'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_ignore']
*/
$cfg['Export']['sql_ignore'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_hex_for_blob']
*/
$cfg['Export']['sql_hex_for_blob'] = true;
/**
* insert/update/replace
*
* @global string $cfg['Export']['sql_type']
*/
$cfg['Export']['sql_type'] = 'insert';
/**
*
*
* @global boolean $cfg['Export']['sql_extended']
*/
$cfg['Export']['sql_extended'] = true;
/**
*
*
* @global integer $cfg['Export']['sql_max_query_size']
*/
$cfg['Export']['sql_max_query_size'] = 50000;
/**
*
*
* @global boolean $cfg['Export']['sql_comments']
*/
$cfg['Export']['sql_comments'] = false;
/**
*
*
* @global boolean $cfg['Export']['sql_mime']
*/
$cfg['Export']['sql_mime'] = false;
/**
* \n is replaced by new line
*
* @global string $cfg['Export']['sql_header_comment']
*/
$cfg['Export']['sql_header_comment'] = '';
/**
*
*
* @global boolean $cfg['Export']['pdf_structure']
*/
$cfg['Export']['pdf_structure'] = false;
/**
*
*
* @global boolean $cfg['Export']['pdf_data']
*/
$cfg['Export']['pdf_data'] = true;
/**
*
*
* @global string $cfg['Export']['pdf_report_title']
*/
$cfg['Export']['pdf_report_title'] = '';
 楼主| kj861 发表于 2007-10-14 11:14:12 | 显示全部楼层
/*******************************************************************************
* Import defaults
*/
$cfg['Import'] = array();/**
*
*
* @global string $cfg['Import']['format']
*/
$cfg['Import']['format'] = 'sql';
/**
*
*
* @global boolean $cfg['Import']['allow_interrupt']
*/
$cfg['Import']['allow_interrupt'] = true;
/**
*
*
* @global integer $cfg['Import']['skip_queries']
*/
$cfg['Import']['skip_queries'] = '0';
/**
*
*
* @global string $cfg['Import']['sql_compatibility']
*/
$cfg['Import']['sql_compatibility'] = 'NONE';
/**
*
*
* @global boolean $cfg['Import']['csv_replace']
*/
$cfg['Import']['csv_replace'] = false;
/**
*
*
* @global string $cfg['Import']['csv_terminated']
*/
$cfg['Import']['csv_terminated'] = ';';
/**
*
*
* @global string $cfg['Import']['csv_enclosed']
*/
$cfg['Import']['csv_enclosed'] = '"';
/**
*
*
* @global string $cfg['Import']['csv_escaped']
*/
$cfg['Import']['csv_escaped'] = '\\';
/**
*
*
* @global string $cfg['Import']['csv_new_line']
*/
$cfg['Import']['csv_new_line'] = 'auto';
/**
*
*
* @global string $cfg['Import']['csv_columns']
*/
$cfg['Import']['csv_columns'] = '';
/**
*
*
* @global boolean $cfg['Import']['ldi_replace']
*/
$cfg['Import']['ldi_replace'] = false;
/**
*
*
* @global string $cfg['Import']['ldi_terminated']
*/
$cfg['Import']['ldi_terminated'] = ';';
/**
*
*
* @global string $cfg['Import']['ldi_enclosed']
*/
$cfg['Import']['ldi_enclosed'] = '"';
/**
*
*
* @global string $cfg['Import']['ldi_escaped']
*/
$cfg['Import']['ldi_escaped'] = '\\';
/**
*
*
* @global string $cfg['Import']['ldi_new_line']
*/
$cfg['Import']['ldi_new_line'] = 'auto';
/**
*
*
* @global string $cfg['Import']['ldi_columns']
*/
$cfg['Import']['ldi_columns'] = '';
/**
* 'auto' for auto-detection, true or false for forcing
*
* @global string $cfg['Import']['ldi_local_option']
*/
$cfg['Import']['ldi_local_option'] = 'auto';
/**
* 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.
*
* @global string $cfg['MySQLManualBase']
*/
$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
*
* @global string $cfg['MySQLManualType']
*/
$cfg['MySQLManualType'] = 'viewable';

/*******************************************************************************
* PDF options
*/
/**
*
*
* @global array $cfg['PDFPageSizes']
*/
$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
/**
*
*
* @global string $cfg['PDFDefaultPageSize']
*/
$cfg['PDFDefaultPageSize'] = 'A4';

/*******************************************************************************
* Language and character set conversion settings
*/
/**
* Default language to use, if not browser-defined or user-defined
*
* @global string $cfg['DefaultLang']
*/
$cfg['DefaultLang'] = 'zh';
/**
* Default connection collation (used for MySQL >= 4.1)
*
* @global string $cfg['DefaultConnectionCollation']
*/
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';
/**
* Force: always use this language - must be defined in
*        libraries/select_lang.lib.php
* $cfg['Lang'] = 'en-iso-8859-1';
*
* Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
* English only
*
* @global string $cfg['FilterLanguages']
*/
$cfg['FilterLanguages'] = '';
/**
* Default character set to use for recoding of MySQL queries, does not take
* any effect when character sets recoding is switched off by
* $cfg['AllowAnywhereRecoding'] or in language file
* (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
*
* @global string $cfg['DefaultCharset']
*/
$cfg['DefaultCharset'] = 'iso-8859-1';
/**
* Allow character set 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
*
* @global boolean $cfg['AllowAnywhereRecoding']
*/
$cfg['AllowAnywhereRecoding'] = false;
/**
* You can select here which functions will be used for character set 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
*
* @global string $cfg['RecodingEngine']
*/
$cfg['RecodingEngine'] = 'auto';
/**
* Specify some parameters for iconv used in character set conversion. See iconv
* documentation for details:
* http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
*
* @global string $cfg['IconvExtraParams']
*/
$cfg['IconvExtraParams'] = '//TRANSLIT';
/**
* Available character sets for MySQL conversion. currently contains all which could
* be found in lang/* files and few more.
* Character sets will be shown in same order as here listed, so if you frequently
* use some of these move them to the top.
*
* @global array $cfg['AvailableCharsets']
*/
$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/theme-name/layout.inc.php
*/
/**
* enable the left panel pointer
* (used when LeftFrameLight is false)
* see also LeftPointerColor
* in layout.inc.php
*
* @global boolean $cfg['LeftPointerEnable']
*/
$cfg['LeftPointerEnable'] = true;
/**
* enable the browse pointer
* see also BrowsePointerColor
* in layout.inc.php
*
* @global boolean $cfg['BrowsePointerEnable']
*/
$cfg['BrowsePointerEnable'] = true;
/**
* enable the browse marker
* see also BrowseMarkerColor
* in layout.inc.php
*
* @global boolean $cfg['BrowseMarkerEnable']
*/
$cfg['BrowseMarkerEnable'] = true;
/**
* textarea size (columns) in edit mode
* (this value will be emphasized (*2) for SQL
* query textareas and (*1.25) for query window)
*
* @global integer $cfg['TextareaCols']
*/
$cfg['TextareaCols'] = 40;
/**
* textarea size (rows) in edit mode
*
* @global integer $cfg['TextareaRows']
*/
$cfg['TextareaRows'] = 7;
/**
* double size of textarea size for LONGTEXT fields
*
* @global boolean $cfg['LongtextDoubleTextarea']
*/
$cfg['LongtextDoubleTextarea'] = true;
/**
* auto-select when clicking in the textarea of the query-box
*
* @global boolean $cfg['TextareaAutoSelect']
*/
$cfg['TextareaAutoSelect'] = true;
/**
* textarea size (columns) for CHAR/VARCHAR
*
* @global integer $cfg['CharTextareaCols']
*/
$cfg['CharTextareaCols'] = 40;
/**
* textarea size (rows) for CHAR/VARCHAR
*
* @global integer $cfg['CharTextareaRows']
*/
$cfg['CharTextareaRows'] = 2;
/**
* Enable Ctrl+Arrows moving between fields when editing?
*
* @global boolean $cfg['CtrlArrowsMoving']
*/
$cfg['CtrlArrowsMoving'] = true;
/**
* Max field data length in browse mode for all non-numeric fields
*
* @global integer $cfg['LimitChars']
*/
$cfg['LimitChars'] = 50;
/**
* show edit/delete links on left side of browse
* (or at the top with vertical browse)
*
* @global boolean $cfg['ModifyDeleteAtLeft']
*/
$cfg['ModifyDeleteAtLeft'] = true;
/**
* show edit/delete links on right side of browse
* (or at the bottom with vertical browse)
*
* @global boolean $cfg['ModifyDeleteAtRight']
*/
$cfg['ModifyDeleteAtRight'] = false;
/**
* default display direction (horizontal|vertical|horizontalflipped)
*
* @global string $cfg['DefaultDisplay']
*/
$cfg['DefaultDisplay'] = 'horizontal';
/**
* default display direction for altering/creating columns (tbl_properties)
* (horizontal|vertical|<number>)
* number indicates maximal number for which vertical model is used
*
* @global integer $cfg['DefaultPropDisplay']
*/
$cfg['DefaultPropDisplay'] = 3;
/**
* table-header rotation via faking or CSS? (css|fake)
* NOTE: CSS only works in IE browsers!
*
* @global string $cfg['HeaderFlipType']
*/
$cfg['HeaderFlipType'] = 'css';
/**
* shows stored relation-comments in 'browse' mode.
*
* @global boolean $cfg['ShowBrowseComments']
*/
$cfg['ShowBrowseComments'] = true;
/**
* shows stored relation-comments in 'table property' mode.
*
* @global boolean $cfg['ShowPropertyComments']
*/
$cfg['ShowPropertyComments']= true;
/**
* repeat header names every X cells? (0 = deactivate)
*
* @global integer $cfg['RepeatCells']
*/
$cfg['RepeatCells'] = 100;
/**
* 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
*
* @global boolean $cfg['EditInWindow']
*/
$cfg['EditInWindow'] = true;
/**
* Width of Query window
*
* @global integer $cfg['QueryWindowWidth']
*/
$cfg['QueryWindowWidth'] = 550;
/**
* Height of Query window
*
* @global integer $cfg['QueryWindowHeight']
*/
$cfg['QueryWindowHeight'] = 310;
/**
* Set to true if you want DB-based query history.If false, this utilizes
* JS-routines to display query history (lost by window close)
*
* @global boolean $cfg['QueryHistoryDB']
*/
$cfg['QueryHistoryDB'] = false;
/**
* which tab to display in the querywindow on startup
* (sql|files|history|full)
*
* @global string $cfg['QueryWindowDefTab']
*/
$cfg['QueryWindowDefTab'] = 'sql';
/**
* When using DB-based query history, how many entries should be kept?
*
* @global integer $cfg['QueryHistoryMax']
*/
$cfg['QueryHistoryMax'] = 25;
/**
* Use MIME-Types (stored in column comments table) for
*
* @global boolean $cfg['BrowseMIME']
*/
$cfg['BrowseMIME'] = true;
/**
* When approximate count < this, PMA will get exact count for table rows.
*
* @global integer $cfg['MaxExactCount']
*/
$cfg['MaxExactCount'] = 20000;
/**
* Zero means that no row count is done for views; see the doc
*
* @global integer $cfg['MaxExactCountViews']
*/
$cfg['MaxExactCountViews'] = 0;
/**
* Utilize DHTML/JS capabilities to allow WYSIWYG editing of
* the PDF page editor. Requires an IE6/Gecko based browser.
*
* @global boolean $cfg['WYSIWYG-PDF']
*/
$cfg['WYSIWYG-PDF'] = true;
/**
* Sort table and database in natural order
*
* @global boolean $cfg['NaturalOrder']
*/
$cfg['NaturalOrder'] = true;

//-----------------------------------------------------------------------------
// custom-setup by mkkeck: 2004-05-04
//    some specials for new icons and scrolling
/**
* @todo 2004-05-08 rabus: We need to rearrange these variables.
*/

/*******************************************************************************
* Window title settings
*/
/**
* title of browser window when a table is selected
*
* @global string $cfg['TitleTable']
*/
$cfg['TitleTable'] = [email=]'@HTTP_HOST[/email]@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
/**
* title of browser window when a database is selected
*
* @global string $cfg['TitleDatabase']
*/
$cfg['TitleDatabase'] = [email=]'@HTTP_HOST[/email]@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
/**
* title of browser window when a server is selected
*
* @global string $cfg['TitleServer']
*/
$cfg['TitleServer'] = [email=]'@HTTP_HOST[/email]@ / @VSERVER@ | @PHPMYADMIN@';
/**
* title of browser window when nothing is selected
* @global string $cfg['TitleDefault']
*/
$cfg['TitleDefault'] = [email=]'@HTTP_HOST[/email]@ | @PHPMYADMIN@';
/**
* show some icons for warning, error and information messages (true|false)?
*
* @global boolean $cfg['ErrorIconic']
*/
$cfg['ErrorIconic'] = true;
/**
* show icons in list on main page and on menu tabs (true|false)?
*
* @global boolean $cfg['MainPageIconic']
*/
$cfg['MainPageIconic'] = true;
/**
* show help button instead of strDocu (true|false)?
*
* @global boolean $cfg['ReplaceHelpImg']
*/
$cfg['ReplaceHelpImg'] = true;

/*******************************************************************************
* theme manager
*/
/**
* using themes manager please set up here the path to 'themes' else leave empty
*
* @global string $cfg['ThemePath']
*/
$cfg['ThemePath'] = './themes';
/**
* if you want to use selectable themes and if ThemesPath not empty
* set it to true, else set it to false (default is false);
*
* @global boolean $cfg['ThemeManager']
*/
$cfg['ThemeManager'] = true;
/**
* 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
*
* @global string $cfg['ThemeDefault']
*/
$cfg['ThemeDefault'] = 'original';
/**
* allow different theme for each configured server
*
* @global boolean $cfg['ThemePerServer']
*/
$cfg['ThemePerServer'] = false;

/*******************************************************************************
*
*/
/**
* 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)
*
* @global string $cfg['DefaultQueryTable']
*/
$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
/**
* 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)
*
* @global string $cfg['DefaultQueryDatabase']
*/
$cfg['DefaultQueryDatabase'] = '';

/*******************************************************************************
* SQL Query box settings
* These are the links display in all of the SQL Query boxes
*
* @global array $cfg['SQLQuery']
*/
$cfg['SQLQuery'] = array();
/**
* Edit link to change a query
*
* @global boolean $cfg['SQLQuery']['Edit']
*/
$cfg['SQLQuery']['Edit'] = true;
/**
* EXPLAIN on SELECT queries
*
* @global boolean $cfg['SQLQuery']['Explain']
*/
$cfg['SQLQuery']['Explain'] = true;
/**
* Wrap a query in PHP
*
* @global boolean $cfg['SQLQuery']['ShowAsPHP']
*/
$cfg['SQLQuery']['ShowAsPHP'] = true;
/**
* Validate a query (see $cfg['SQLValidator'] as well)
*
* @global boolean $cfg['SQLQuery']['Validate']
*/
$cfg['SQLQuery']['Validate'] = false;
/**
* Refresh the results page
*
* @global boolean $cfg['SQLQuery']['Refresh']
*/
$cfg['SQLQuery']['Refresh'] = true;

/*******************************************************************************
* Web server upload/save/import directories
*/
/**
* Directory for uploaded files that can be executed by phpMyAdmin.
* For example './upload'. Leave empty for no upload directory support.
* Use %u for username inclusion.
*
* @global string $cfg['UploadDir']
*/
$cfg['UploadDir'] = '';
/**
* Directory where phpMyAdmin can save exported data on server.
* For example './save'. Leave empty for no save directory support.
* Use %u for username inclusion.
*
* @global string $cfg['SaveDir']
*/
$cfg['SaveDir'] = '';
/**
* Directory where phpMyAdmin can save temporary files.
* This is needed for MS Excel export, see documentation how to enable that.
*
* @global string $cfg['TempDir']
*/
$cfg['TempDir'] = '';

/**
* Misc. settings
*/
/**
* Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
* which is a bit expensive for PHP < 4.3.0, but it is the only safe way how to
* determine GD version.
*
* @global string $cfg['GD2Available']
*/
$cfg['GD2Available'] = 'auto';
/**
* List of trusted proxies for IP allow/deny
*
* @global array $cfg['TrustedProxies']
*/
$cfg['TrustedProxies'] = array();

/*******************************************************************************
* SQL Parser Settings
*
* @global array $cfg['SQP']
*/
$cfg['SQP'] = array();
/**
* Pretty-printing style to use on queries (html, text, none)
*
* @global string $cfg['SQP']['fmtType']
*/
$cfg['SQP']['fmtType'] = 'html';
/**
* Amount to indent each level (floats are valid)
*
* @global integer $cfg['SQP']['fmtInd']
*/
$cfg['SQP']['fmtInd'] = '1';
/**
* Units for indenting each level (CSS Types - {em, px, pt})
*
* @global string $cfg['SQP']['fmtIndUnit']
*/
$cfg['SQP']['fmtIndUnit'] = 'em';

/*******************************************************************************
* If you wish to use the SQL Validator service, you should be aware of the
* following:
* All SQL statements are stored anonymously for statistical purposes.
* Mimer SQL Validator, Copyright 2002 Upright Database Technology.
* All rights reserved.
*
* @global array $cfg['SQLValidator']
*/
$cfg['SQLValidator'] = array();
/**
* Make the SQL Validator available
*
* @global boolean $cfg['SQLValidator']['use']
*/
$cfg['SQLValidator']['use'] = false;
/**
* If you have a custom username, specify it here (defaults to anonymous)
*
* @global string $cfg['SQLValidator']['username']
*/
$cfg['SQLValidator']['username'] = '';
/**
* Password for username
*
* @global string $cfg['SQLValidator']['password']
*/
$cfg['SQLValidator']['password'] = '';

/*******************************************************************************
* Developers ONLY!
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*
* @global array $cfg['DBG']
*/
$cfg['DBG'] = array();
/**
* Make the DBG stuff available
*
* @global boolean $cfg['DBG']['enable']
*/
$cfg['DBG']['enable'] = false;
/**
* Produce profiling results of PHP
*
* @global boolean $cfg['DBG']['profile']['enable']
*/
$cfg['DBG']['profile']['enable'] = false;
/**
* Threshold of long running code to display
* Anything below the threshold is not displayed
*
* @global float $cfg['DBG']['profile']['threshold']
*/
$cfg['DBG']['profile']['threshold'] = 0.5;

/*******************************************************************************
* MySQL settings
*/
/**
* Column types;
* VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity
*
* @global array $cfg['ColumnTypes']
*/
$cfg['ColumnTypes'] = array(
   'VARCHAR',
   'TINYINT',
   'TEXT',
   'DATE',
   'SMALLINT',
   'MEDIUMINT',
   'INT',
   'BIGINT',
   'FLOAT',
   'DOUBLE',
   'DECIMAL',
   'DATETIME',
   'TIMESTAMP',
   'TIME',
   'YEAR',
   'CHAR',
   'TINYBLOB',
   'TINYTEXT',
   'BLOB',
   'MEDIUMBLOB',
   'MEDIUMTEXT',
   'LONGBLOB',
   'LONGTEXT',
   'ENUM',
   'SET',
   'BIT',
   'BOOL'
);
/**
* Attributes
* Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
* for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php
*
* @global array $cfg['AttributeTypes']
*/
$cfg['AttributeTypes'] = array(
   '',
   'BINARY',
   'UNSIGNED',
   'UNSIGNED ZEROFILL'
);

if ($cfg['ShowFunctionFields']) {
    /**
     * Available functions
     *
     * @global array $cfg['Functions']
     */
    $cfg['Functions'] = array(
       'ASCII',
       'CHAR',
       'SOUNDEX',
       'LCASE',
       'UCASE',
       'NOW',
       'PASSWORD',
       'OLD_PASSWORD',
       'MD5',
       'SHA1',
       'ENCRYPT',
       'COMPRESS',
       'UNCOMPRESS',
       'RAND',
       'LAST_INSERT_ID',
       'COUNT',
       'AVG',
       'SUM',
       'CURDATE',
       'CURTIME',
       'UTC_DATE',
       'UTC_TIME',
       'UTC_TIMESTAMP',
       'FROM_DAYS',
       'FROM_UNIXTIME',
       'PERIOD_ADD',
       'PERIOD_DIFF',
       'TO_DAYS',
       'UNIX_TIMESTAMP',
       'USER',
       'WEEKDAY',
       'CONCAT',
       'HEX',
       'UNHEX'
    );
    /**
     * Which column types will be mapped to which Group?
     *
     * @global array $cfg['RestrictColumnTypes']
     */
    $cfg['RestrictColumnTypes'] = array(
       'VARCHAR' => 'FUNC_CHAR',
       'TINYINT' => 'FUNC_NUMBER',
       'TEXT' => 'FUNC_CHAR',
       'DATE' => 'FUNC_DATE',
       'SMALLINT' => 'FUNC_NUMBER',
       'MEDIUMINT' => 'FUNC_NUMBER',
       'INT' => 'FUNC_NUMBER',
       'BIGINT' => 'FUNC_NUMBER',
       'FLOAT' => 'FUNC_NUMBER',
       'DOUBLE' => 'FUNC_NUMBER',
       'DECIMAL' => 'FUNC_NUMBER',
       'DATETIME' => 'FUNC_DATE',
       'TIMESTAMP' => 'FUNC_DATE',
       'TIME' => 'FUNC_DATE',
       'YEAR' => 'FUNC_DATE',
       'CHAR' => 'FUNC_CHAR',
       'TINYBLOB' => 'FUNC_CHAR',
       'TINYTEXT' => 'FUNC_CHAR',
       'BLOB' => 'FUNC_CHAR',
       'MEDIUMBLOB' => 'FUNC_CHAR',
       'MEDIUMTEXT' => 'FUNC_CHAR',
       'LONGBLOB' => 'FUNC_CHAR',
       'LONGTEXT' => 'FUNC_CHAR',
       'ENUM' => '',
       'SET' => ''
    );
    /**
     * Map above defined groups to any function
     *
     * @global array $cfg['RestrictFunctions']
     */
    $cfg['RestrictFunctions'] = array(
        'FUNC_CHAR' => array(
            'ASCII',
            'CHAR',
            'SOUNDEX',
            'LCASE',
            'UCASE',
            'PASSWORD',
            'OLD_PASSWORD',
            'MD5',
            'SHA1',
            'ENCRYPT',
            'COMPRESS',
            'UNCOMPRESS',
            'LAST_INSERT_ID',
            'USER',
            'CONCAT',
            'HEX',
            'UNHEX'
        ),
        'FUNC_DATE' => array(
            'NOW',
            'CURDATE',
            'CURTIME',
            'FROM_DAYS',
            'FROM_UNIXTIME',
            'PERIOD_ADD',
            'PERIOD_DIFF',
            'TO_DAYS',
            'UNIX_TIMESTAMP',
            'UTC_DATE',
            'UTC_TIME',
            'UTC_TIMESTAMP',
            'WEEKDAY'
        ),
        'FUNC_NUMBER' => array(
            'ASCII',
            'CHAR',
            'MD5',
            'SHA1',
            'ENCRYPT',
            'RAND',
            'LAST_INSERT_ID',
            'UNIX_TIMESTAMP',
            'COUNT',
            'AVG',
            'SUM'
        )
    );
    /**
     * Default functions for above defined groups
     *
     * @global array $cfg['DefaultFunctions']
     */
    $cfg['DefaultFunctions'] = array(
        'FUNC_CHAR' => '',
        'FUNC_DATE' => '',
        'FUNC_NUMBER' => '',
        'first_timestamp' => 'NOW'
    );

} // end if
/**
* Search operators
*
* @global array $cfg['NumOperators']
*/
$cfg['NumOperators'] = array(
   '=',
   '>',
   '>=',
   '<',
   '<=',
   '!=',
   'LIKE',
   'NOT LIKE'
);
/**
* Search operators
*
* @global array $cfg['TextOperators']
*/
$cfg['TextOperators'] = array(
   'LIKE',
   'LIKE %...%',
   'NOT LIKE',
   '=',
   '!=',
   'REGEXP',
   'NOT REGEXP'
);
/**
* Search operators
*
* @global array $cfg['EnumOperators']
*/
$cfg['EnumOperators'] = array(
   '=',
   '!='
);
/**
* Search operators
*
* @global array $cfg['SetOperators']
*/
$cfg['SetOperators'] = array(
   'IN',
   'NOT IN'
);
/**
* Search operators
*
* @global array $cfg['NullOperators']
*/
$cfg['NullOperators'] = array(
   'IS NULL',
   'IS NOT NULL'
);
/**
* Search operators
*
* @global array $cfg['UnaryOperators']
*/
$cfg['UnaryOperators'] = array(
   'IS NULL' => 1,
   'IS NOT NULL' => 1
);
?>


谢谢大家了!
回复

使用道具 举报

 楼主| kj861 发表于 2007-10-14 11:46:22 | 显示全部楼层
搞定了,就差这一步聚。

找到
cfg['Servers'][$i]['host']          = 'localhost'

改成
cfg['Servers'][$i]['host']          = 'localhost'     //说明:如果你是连接本机的数据库这里无需修改,如果连接的是远程数据库,请把localhost改成数据库实际的IP地址
回复

使用道具 举报

lynx_047 发表于 2010-8-10 20:49:35 | 显示全部楼层
为了500分, 帮顶
回复

使用道具 举报

xiaoyuwxz 发表于 2010-8-11 05:45:01 | 显示全部楼层
下个tar包,解压就可以用了,不用这么麻烦
即使下载了zip包,也只要改下配置文件名,也是直接可以用的。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-16 14:08 , Processed in 0.034085 second(s), 3 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表