config.inc.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 /**
   6  * phpMyAdmin Configuration File
   7  *
   8  * All directives are explained in Documentation.html
   9  */
  10
  11
  12 /**
  13  * Sets the php error reporting - Please do not change this line!
  14  */
  15 if (!isset($old_error_reporting)) {
  16     error_reporting(E_ALL);
  17     @ini_set('display_errors', '1');
  18 }
  19
  20
  21 /**
  22  * Your phpMyAdmin url
  23  *
  24  * Complete the variable below with the full url ie
  25  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  26  *
  27  * It must contain characters that are valid for a URL, and the path is
  28  * case sensitive on some Web servers, for example Unix-based servers.
  29  *
  30  * In most cases you can leave this variable empty, as the correct value
  31  * will be detected automatically. However, we recommend that you do
  32  * test to see that the auto-detection code works in your system. A good
  33  * test is to browse a table, then edit a row and save it.  There will be
  34  * an error message if phpMyAdmin cannot auto-detect the correct value.
  35  *
  36  * If the auto-detection code does work properly, you can set to TRUE the
  37  * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
  38  */
  39 $cfg['PmaAbsoluteUri'] = '';
  40
  41
  42 /**
  43  * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
  44  * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
  45  * works perfectly.
  46  */
  47 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
  48
  49 /**
  50  * Disable the default warning that is displayed on the DB Details Structure page if
  51  * any of the required Tables for the relationfeatures could not be found
  52  */
  53 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
  54
  55
  56 /**
  57  * Server(s) configuration
  58  */
  59 $i = 0;
  60 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
  61 // You can disable a server config entry by setting host to ''.
  62 $i++;
  63 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
  64 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  65 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  66 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  67 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  68                                                     // (requires PHP >= 4.3.0)
  69 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  70                                                     // (this user must have read-only
  71 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  72                                                     // and "mysql/db" tables)
  73 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  74 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  75 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  76                                                     // with 'config' auth_type)
  77 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  78                                                     // this db is displayed
  79                                                     // at left frame
  80                                                     // It may also be an array
  81                                                     // of db-names
  82 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  83
  84 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  85                                                     // - leave blank for no support
  86 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support
  87 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
  88                                                     //   - leave blank for no relation-links support
  89 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
  90                                                     //   - leave blank for no display fields support
  91 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF
  92                                                     //   schema - leave blank for no PDF schema support
  93 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
  94                                                     // - leave blank if you don't want to use this
  95 $cfg['Servers'][$i]['column_comments']              // table to store columncomments
  96                                      = '';          // - leave blank if you don't want to use this
  97 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
  98                                      = '';
  99 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
 100                                      = array();
 101
 102
 103 $i++;
 104 $cfg['Servers'][$i]['host']            = '';
 105 $cfg['Servers'][$i]['port']            = '';
 106 $cfg['Servers'][$i]['socket']          = '';
 107 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 108 $cfg['Servers'][$i]['compress']        = FALSE;
 109 $cfg['Servers'][$i]['controluser']     = '';
 110 $cfg['Servers'][$i]['controlpass']     = '';
 111 $cfg['Servers'][$i]['auth_type']       = 'config';
 112 $cfg['Servers'][$i]['user']            = 'root';
 113 $cfg['Servers'][$i]['password']        = '';
 114 $cfg['Servers'][$i]['only_db']         = '';
 115 $cfg['Servers'][$i]['verbose']         = '';
 116 $cfg['Servers'][$i]['pmadb']           = '';
 117 $cfg['Servers'][$i]['bookmarktable']   = '';
 118 $cfg['Servers'][$i]['relation']        = '';
 119 $cfg['Servers'][$i]['table_info']      = '';
 120 $cfg['Servers'][$i]['table_coords']    = '';
 121 $cfg['Servers'][$i]['pdf_pages']       = '';
 122 $cfg['Servers'][$i]['column_comments'] = '';
 123 $cfg['Servers'][$i]['AllowDeny']['order']
 124                                        = '';
 125 $cfg['Servers'][$i]['AllowDeny']['rules']
 126                                        = array();
 127
 128 $i++;
 129 $cfg['Servers'][$i]['host']            = '';
 130 $cfg['Servers'][$i]['port']            = '';
 131 $cfg['Servers'][$i]['socket']          = '';
 132 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 133 $cfg['Servers'][$i]['compress']        = FALSE;
 134 $cfg['Servers'][$i]['controluser']     = '';
 135 $cfg['Servers'][$i]['controlpass']     = '';
 136 $cfg['Servers'][$i]['auth_type']       = 'config';
 137 $cfg['Servers'][$i]['user']            = 'root';
 138 $cfg['Servers'][$i]['password']        = '';
 139 $cfg['Servers'][$i]['only_db']         = '';
 140 $cfg['Servers'][$i]['verbose']         = '';
 141 $cfg['Servers'][$i]['pmadb']           = '';
 142 $cfg['Servers'][$i]['bookmarktable']   = '';
 143 $cfg['Servers'][$i]['relation']        = '';
 144 $cfg['Servers'][$i]['table_info']      = '';
 145 $cfg['Servers'][$i]['table_coords']    = '';
 146 $cfg['Servers'][$i]['pdf_pages']       = '';
 147 $cfg['Servers'][$i]['column_comments'] = '';
 148 $cfg['Servers'][$i]['AllowDeny']['order']
 149                                        = '';
 150 $cfg['Servers'][$i]['AllowDeny']['rules']
 151                                        = array();
 152
 153 // If you have more than one server configured, you can set $cfg['ServerDefault']
 154 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 155 // or set it to 0 to be given a list of servers without logging in
 156 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 157 // set to that server.
 158 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 159 $cfg['Server']        = '';
 160 unset($cfg['Servers'][0]);
 161
 162
 163 /**
 164  * Other core phpMyAdmin settings
 165  */
 166 $cfg['OBGzip']                = TRUE;   // use GZIP output buffering if possible
 167 $cfg['PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
 168 $cfg['ExecTimeLimit']         = 300;    // maximum execution time in seconds (0 for no limit)
 169 $cfg['SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
 170                                         // locked tables (since MySQL 3.23.30)
 171 $cfg['ShowSQL']               = TRUE;   // show SQL queries as run
 172 $cfg['AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
 173 $cfg['Confirm']               = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 174 $cfg['LoginCookieRecall']     = TRUE;   // recall previous login in cookie auth. mode or not
 175 $cfg['UseDbSearch']           = TRUE;   // whether to enable the "database search" feature
 176                                         // or not
 177
 178 // Left frame setup
 179 $cfg['LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
 180                                         // current tables in the left frame.
 181 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
 182 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 183
 184 // In the main frame, at startup...
 185 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 186                                         // the pages about database details and table
 187                                         // properties
 188 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 189 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 190 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 191 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 192 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 193
 194 // In browse mode...
 195 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 196 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
 197 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 198 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 199 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 200                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 201                                         // descending order for fields of type
 202                                         // TIME, DATE, DATETIME & TIMESTAMP,
 203                                         // ascending order else-)
 204
 205 // In edit mode...
 206 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 207                                         // valid values are:
 208                                         //   FALSE  allow editing
 209                                         //   'blob' allow editing except for BLOB fields
 210                                         //   'all'  disallow editing
 211 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 212 $cfg['CharEditing']           = 'input';
 213                                         // Which editor should be used for CHAR/VARCHAR fields:
 214                                         //  input - allows limiting of input length
 215                                         //  textarea - allows newlines in fields
 216
 217 // For the export features...
 218 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 219 $cfg['GZipDump']              = TRUE;   // compression for
 220 $cfg['BZipDump']              = TRUE;   // dump files
 221
 222 // Default Tabs display settings
 223 $cfg['DefaultTabServer']      = 'main.php3';
 224                                    // Possible values:
 225                                    // 'main.php3' = the welcome page
 226                                    // (recommended for multiuser setups)
 227                                    // 'server_databases.php3' = list of databases
 228                                    // 'server_status.php3' = runtime information
 229                                    // 'server_variables.php3' = MySQL server variables
 230                                    // 'server_privileges.php3' = user management
 231                                    // 'server_processlist.php3' = process list
 232 $cfg['DefaultTabDatabase']    = 'db_details_structure.php3';
 233                                    // Possible values:
 234                                    // 'db_details_structure.php3' = tables list
 235                                    // 'db_details.php3' = sql form
 236                                    // 'db_search.php3' = search query
 237 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php3';
 238                                    // Possible values:
 239                                    // 'tbl_properties_structure.php3' = fields list
 240                                    // 'tbl_properties.php3' = sql form
 241                                    // 'tbl_select.php3 = select page
 242                                    // 'tbl_change.php3 = insert row page
 243
 244
 245 /**
 246  * Link to the official MySQL documentation.
 247  * Be sure to include no trailing slash on the path.
 248  * See http://www.mysql.com/documentation/index.html for more information
 249  * about MySQL manuals and their types.
 250  */
 251 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
 252
 253 /**
 254  * Type of MySQL documentation:
 255  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 256  *   searchable - "Searchable, with user comments"
 257  *   chapters   - "HTML, one page per chapter"
 258  *   big        - "HTML, all on one page"
 259  *   none       - do not show documentation links
 260  */
 261 $cfg['MySQLManualType'] = 'searchable';
 262
 263
 264 /**
 265  * Language and charset conversion settings
 266  */
 267 // Default language to use, if not browser-defined or user-defined
 268 $cfg['DefaultLang'] = 'en-iso-8859-1';
 269
 270 // Force: always use this language - must be defined in
 271 //        libraries/select_lang.lib.php3
 272 // $cfg['Lang']     = 'en-iso-8859-1';
 273
 274 // Default charset to use for recoding of MySQL queries, does not take
 275 // any effect when charsets recoding is switched off by
 276 // $cfg['AllowAnywhereRecoding'] or in language file
 277 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 278 $cfg['DefaultCharset'] = 'iso-8859-1';
 279
 280 // Allow charset recoding of MySQL queries, must be also enabled in language
 281 // file to make harder using other language files than unicode.
 282 // Default value is FALSE to avoid problems on servers without the iconv
 283 // extension and where dl() is not supported
 284 $cfg['AllowAnywhereRecoding'] = FALSE;
 285
 286 // You can select here which functions will be used for charset conversion.
 287 // Possible values are:
 288 //      auto   - automatically use available one (first is tested iconv, then
 289 //               recode)
 290 //      iconv  - use iconv or libiconv functions
 291 //      recode - use recode_string function
 292 $cfg['RecodingEngine'] = 'auto';
 293
 294 // Available charsets for MySQL conversion. currently contains all which could
 295 // be found in lang/* files and few more.
 296 // Charsets will be shown in same order as here listed, so if you frequently
 297 // use some of these move them to the top.
 298 $cfg['AvailableCharsets'] = array(
 299     'iso-8859-1',
 300     'iso-8859-2',
 301     'iso-8859-3',
 302     'iso-8859-4',
 303     'iso-8859-5',
 304     'iso-8859-6',
 305     'iso-8859-7',
 306     'iso-8859-8',
 307     'iso-8859-9',
 308     'iso-8859-10',
 309     'iso-8859-11',
 310     'iso-8859-12',
 311     'iso-8859-13',
 312     'iso-8859-14',
 313     'iso-8859-15',
 314     'windows-1250',
 315     'windows-1251',
 316     'windows-1252',
 317     'windows-1257',
 318     'koi8-r',
 319     'big5',
 320     'gb2312',
 321     'utf-8',
 322     'utf-7',
 323     'x-user-defined',
 324     'euc-jp',
 325     'ks_c_5601-1987',
 326     'tis-620',
 327     'SHIFT_JIS'
 328 );
 329
 330 // Loads language file
 331 require('./libraries/select_lang.lib.php3');
 332
 333
 334 /**
 335  * Customization & design
 336  */
 337 $cfg['LeftWidth']           = 150;          // left frame width
 338 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
 339 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
 340 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
 341                                             // (leave blank for no background image)
 342 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
 343                                             // (blank for no pointer)
 344 $cfg['Border']              = 0;            // border width on tables
 345 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
 346 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
 347 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
 348 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
 349                                             // (blank for no pointer)
 350 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
 351                                             // by clicking on it) in browse mode
 352                                             // (blank for no marker)
 353 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 354                                             // (this value will be emphasized (*2) for sql
 355                                             // query textareas)
 356 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 357 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 358 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 359 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 360 $cfg['LimitChars']          = 50;           // max field data length in browse mode
 361 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 362                                             // (or at the top with vertical browse)
 363 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 364                                             // (or at the bottom with vertical browse)
 365 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction (horizontal|vertical)
 366 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 367
 368
 369 /**
 370  * SQL Query box settings
 371  * These are the links display in all of the SQL Query boxes
 372  */
 373 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 374 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 375 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 376 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 377
 378
 379 /**
 380  * web-server upload directory
 381  */
 382 $cfg['UploadDir']             = '';         // for example, './upload/'; you must end it with
 383                                             // a slash, and you leave it empty for no upload
 384                                             // directory
 385
 386
 387 /**
 388  * SQL Parser Settings
 389  */
 390 $cfg['SQP']['enable']       = TRUE;         // Totally turn off the SQL Parser (not recommended)
 391 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 392 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 393 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 394 $cfg['SQP']['fmtColor']     = array(        // Syntax colouring data
 395     'comment'            => '#808000',
 396     'comment_mysql'      => '',
 397     'comment_ansi'       => '',
 398     'comment_c'          => '',
 399     'digit'              => '',
 400     'digit_hex'          => 'teal',
 401     'digit_integer'      => 'teal',
 402     'digit_float'        => 'aqua',
 403     'punct'              => 'fuchsia',
 404     'alpha'              => '',
 405     'alpha_columnType'   => '#FF9900',
 406     'alpha_columnAttrib' => '#0000FF',
 407     'alpha_reservedWord' => '#990099',
 408     'alpha_functionName' => '#FF0000',
 409     'alpha_identifier'   => 'black',
 410     'alpha_variable'     => '#800000',
 411     'quote'              => '#008000',
 412     'quote_double'       => '',
 413     'quote_single'       => '',
 414     'quote_backtick'     => ''
 415 );
 416
 417
 418 /**
 419  * If you wish to use the SQL Validator service, you should be
 420  * aware of the following:
 421  * All SQL statements are stored anonymously for statistical purposes.
 422  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 423  * All rights reserved.
 424  */
 425 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 426 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 427 $cfg['SQLValidator']['password'] = '';      // Password for username
 428
 429 /**
 430  * Developers ONLY!
 431  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 432  */
 433 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 434 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 435 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 436                                             // Anything below the threshold is not displayed
 437
 438
 439 /**
 440  * MySQL settings
 441  */
 442 // Column types;
 443 // varchar, tinyint, text and date are listed first, based on estimated popularity
 444 $cfg['ColumnTypes'] = array(
 445    'VARCHAR',
 446    'TINYINT',
 447    'TEXT',
 448    'DATE',
 449    'SMALLINT',
 450    'MEDIUMINT',
 451    'INT',
 452    'BIGINT',
 453    'FLOAT',
 454    'DOUBLE',
 455    'DECIMAL',
 456    'DATETIME',
 457    'TIMESTAMP',
 458    'TIME',
 459    'YEAR',
 460    'CHAR',
 461    'TINYBLOB',
 462    'TINYTEXT',
 463    'BLOB',
 464    'MEDIUMBLOB',
 465    'MEDIUMTEXT',
 466    'LONGBLOB',
 467    'LONGTEXT',
 468    'ENUM',
 469    'SET'
 470 );
 471
 472 // Atributes
 473 $cfg['AttributeTypes'] = array(
 474    '',
 475    'BINARY',
 476    'UNSIGNED',
 477    'UNSIGNED ZEROFILL'
 478 );
 479
 480 // Available functions
 481 if ($cfg['ShowFunctionFields']) {
 482     $cfg['Functions'] = array(
 483        'ASCII',
 484        'CHAR',
 485        'SOUNDEX',
 486        'LCASE',
 487        'UCASE',
 488        'NOW',
 489        'PASSWORD',
 490        'MD5',
 491        'ENCRYPT',
 492        'RAND',
 493        'LAST_INSERT_ID',
 494        'COUNT',
 495        'AVG',
 496        'SUM',
 497        'CURDATE',
 498        'CURTIME',
 499        'FROM_DAYS',
 500        'FROM_UNIXTIME',
 501        'PERIOD_ADD',
 502        'PERIOD_DIFF',
 503        'TO_DAYS',
 504        'UNIX_TIMESTAMP',
 505        'USER',
 506        'WEEKDAY',
 507        'CONCAT'
 508     );
 509 } // end if
 510
 511
 512 /**
 513  * Unset magic_quotes_runtime - do not change!
 514  */
 515 set_magic_quotes_runtime(0);
 516
 517 /**
 518  * File Revision - do not change either!
 519  */
 520 $cfg['FileRevision'] = '$Revision$';
 521 ?>