Config.inc er meget uoverskuelig, med den forklarende tekst.
prøv at kig på min config.
<?php
/* $Id: config.inc.php,v 1.135 2002/08/10 11:34:19 loic1 Exp $ */
/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
*/
/**
* Sets the php error reporting - Please do not change this line!
*/
if (!isset($old_error_reporting)) {
error_reporting(E_ALL);
@ini_set('display_errors', '1');
}
/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
*
http://www.wendt-net.dk/phpMyAdmin-2.3.0/
*
* 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.
*
* If the auto-detection code does work properly, you can set to TRUE
the
* $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
*/
$cfg['PmaAbsoluteUri'] = '
http://www.wendt-net.dk/phpmyadmin-2.3.0/';
/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being
set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
/**
* 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;
/**
* 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 ''.
$i++;
$cfgServers[$i]['host'] = 'localhost'; // MySQL hostname
$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]['controluser'] = ''; // MySQL control
user settings
// (this user must
have read-only
$cfg['Servers'][$i]['controlpass'] = 'kodeord'; // access to
the "mysql/user"
// and "mysql/db"
tables)
$cfg['Servers'][$i]['auth_type'] = 'http'; // 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
// at left frame
// It may also be an
array
// of db-names
$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
// - leave blank for
no support
$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table -
leave blank for no bookmark support
$cfg['Servers'][$i]['relation'] = ''; // table to describe
the relation between links (see doc)
// - leave blank
for no relation-links support
$cfg['Servers'][$i]['table_info'] = ''; // table to describe
the display fields
// - leave blank
for no display fields support
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe
the tables position for the PDF
// schema - leave
blank for no PDF schema support
$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe
pages of relationpdf
// - leave blank if
you don't want to use this
$cfg['Servers'][$i]['column_comments'] // table to store
columncomments
= ''; // - leave blank if
you don't want to use this
$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();
$i++;
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';
$cfg['Servers'][$i]['bookmarktable'] = '';
$cfg['Servers'][$i]['relation'] = '';
$cfg['Servers'][$i]['table_info'] = '';
$cfg['Servers'][$i]['table_coords'] = '';
$cfg['Servers'][$i]['pdf_pages'] = '';
$cfg['Servers'][$i]['column_comments'] = '';
$cfg['Servers'][$i]['AllowDeny']['order']
= '';
$cfg['Servers'][$i]['AllowDeny']['rules']
= array();
$i++;
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';
$cfg['Servers'][$i]['bookmarktable'] = '';
$cfg['Servers'][$i]['relation'] = '';
$cfg['Servers'][$i]['table_info'] = '';
$cfg['Servers'][$i]['table_coords'] = '';
$cfg['Servers'][$i]['pdf_pages'] = '';
$cfg['Servers'][$i]['column_comments'] = '';
$cfg['Servers'][$i]['AllowDeny']['order']
= '';
$cfg['Servers'][$i]['AllowDeny']['rules']
= 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)
$cfg['Server'] = '';
unset($cfg['Servers'][0]);
/**
* Other core phpMyAdmin settings
*/
$cfg['OBGzip'] = TRUE; // use GZIP output buffering if
possible
$cfg['PersistentConnections'] = FALSE; // use persistent connections to
MySQL database
$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['UseDbSearch'] = TRUE; // whether to enable the
"database search" feature
// or not
// Left frame setup
$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and
display only the
// current tables in the left
frame.
$cfg['ShowTooltip'] = TRUE; // display table comment as
tooltip in left frame
// 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['ShowMysqlInfo'] = FALSE; // whether to display the "MySQL
runtime
$cfg['ShowMysqlVars'] = FALSE; // information", "MySQL system
variables", "PHP
$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'] = TRUE; // do not display text inside
navigation bar buttons
$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
// For the export features...
$cfg['ZipDump'] = TRUE; // Allow the use of
zip/gzip/bzip
$cfg['GZipDump'] = TRUE; // compression for
$cfg['BZipDump'] = TRUE; // dump files
// Default Tabs display settings
$cfg['DefaultTabDatabase'] = 'db_details_structure.php';
// Possible values:
// 'db_details_structure.php' =
tables list
// 'db_details.php' = sql form
// 'db_search.php' = search query
$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
/**
* Link to the official MySQL documentation
* Be sure to include no trailing slash on the path
*/
$cfg['ManualBaseShort'] = '
http://www.mysql.com/doc';
/**
* 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';
// 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;
// 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-1257',
'koi8-r',
'big5',
'gb2312',
'utf-8',
'utf-7',
'x-user-defined',
'euc-jp',
'ks_c_5601-1987',
'tis-620',
'SHIFT_JIS'
);
// Loads language file
require('./libraries/select_lang.lib.php');
/**
* Customization & design
*/
$cfg['LeftWidth'] = 150; // left frame width
$cfg['LeftBgColor'] = '#D0DCE0'; // background color for the
left frame
$cfg['RightBgColor'] = '#F5F5F5'; // background color for the
right frame
$cfg['RightBgImage'] = ''; // path to a background
image for the right frame
// (leave blank for no
background image)
$cfg['LeftPointerColor'] = '#CCFFCC'; // color of the pointer in
left frame
// (blank for no pointer)
$cfg['Border'] = 0; // border width on tables
$cfg['ThBgcolor'] = '#D3DCE3'; // table header row colour
$cfg['BgcolorOne'] = '#CCCCCC'; // table data row colour
$cfg['BgcolorTwo'] = '#DDDDDD'; // table data row colour,
alternate
$cfg['BrowsePointerColor'] = '#CCFFCC'; // color of the pointer in
browse mode
// (blank for no pointer)
$cfg['BrowseMarkerColor'] = '#FFCC99'; // color of the marker
(visually marks row
// by clicking on it) in
browse mode
// (blank for no marker)
$cfg['TextareaCols'] = 40; // textarea size (columns)
in edit mode
// (this value will be
emphasized (*2) for sql
// query textareas)
$cfg['TextareaRows'] = 7; // textarea size (rows) in
edit mode
$cfg['LimitChars'] = 50; // max field data length in
browse mode
$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)
$cfg['RepeatCells'] = 100; // repeat header names every
X cells? (0 = deactivate)
/**
* 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
$cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries
$cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP
$cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see
$cfg['SQLValidator'] as well)
/**
* SQL Parser Settings
*/
$cfg['SQP']['enable'] = TRUE; // Totally turn off the SQL
Parser (not recommended)
$cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to
use on queries (html, none)
$cfg['SQP']['fmtInd'] = '1'; // Amount to indent each
level (floats ok)
$cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each
level (CSS Types - {em,px,pt})
$cfg['SQP']['fmtColor'] = array( // Syntax colouring data
'comment' => '#808000',
'comment_mysql' => '',
'comment_ansi' => '',
'comment_c' => '',
'digit' => '',
'digit_hex' => 'teal',
'digit_integer' => 'teal',
'digit_float' => 'aqua',
'punct' => 'fuchsia',
'alpha' => '',
'alpha_columnType' => '#FF9900',
'alpha_columnAttrib' => '#0000FF',
'alpha_reservedWord' => '#990099',
'alpha_functionName' => '#FF0000',
'alpha_identifier' => 'black',
'alpha_variable' => '#800000',
'quote' => '#008000',
'quote_double' => '',
'quote_single' => '',
'quote_backtick' => ''
);
/**
* 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.
*/
$cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator
available
$cfg['SQLValidator']['username'] = ''; // If you have a custom
username, specify it here (defaults to anonymous)
$cfg['SQLValidator']['password'] = ''; // Password for username
/**
* MySQL settings
*/
// Column types;
// varchar, tinyint, text and date are listed first, based on estimated
popularity
$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'
);
// Atributes
$cfg['AttributeTypes'] = array(
'',
'BINARY',
'UNSIGNED',
'UNSIGNED ZEROFILL'
);
// Available functions
if ($cfg['ShowFunctionFields']) {
$cfg['Functions'] = array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'NOW',
'PASSWORD',
'MD5',
'ENCRYPT',
'RAND',
'LAST_INSERT_ID',
'COUNT',
'AVG',
'SUM',
'CURDATE',
'CURTIME',
'FROM_DAYS',
'FROM_UNIXTIME',
'PERIOD_ADD',
'PERIOD_DIFF',
'TO_DAYS',
'UNIX_TIMESTAMP',
'USER',
'WEEKDAY',
'CONCAT'
);
} // end if
/**
* Unset magic_quotes_runtime - do not change!
*/
set_magic_quotes_runtime(0);
/**
* File Revision - do not change either!
*/
$cfg['FileRevision'] = '$Revision: 1.135 $';
?>
--
Vil du lære at kode HTML, XHTML, CSS, SSI eller ASP ???
- Pædagogiske tutorials på dansk
- Kom godt i gang med koderne
KLIK HER! =>
http://www.html.dk/tutorials