config.inc.php3

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