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 }
  18
  19
  20 /**
  21  * Your phpMyAdmin url
  22  *
  23  * Complete the variable below with the full url ie
  24  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  25  *
  26  * It must contain characters that are valid for a URL, and the path is
  27  * case sensitive on some Web servers, for example Unix-based servers.
  28  *
  29  * In most cases you can leave this variable alone, as the correct value
  30  * will be detected automatically. However, we recommened that you do
  31  * test to see that the auto-detection code works in your system.
  32  *
  33  * If the auto-detection code does work properly, you can set the
  34  * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
  35  */
  36 $cfg['PmaAbsoluteUri'] = '';
  37
  38
  39 /**
  40  * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
  41  * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
  42  * works perfectly.
  43  */
  44 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
  45
  46
  47 /**
  48  * Server(s) configuration
  49  */
  50 $i = 0;
  51 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
  52 // You can disable a server config entry by setting host to ''.
  53 $i++;
  54 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
  55 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  56 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  57 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  58 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  59                                                     // (this user must have read-only
  60 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  61                                                     // and "mysql/db" tables)
  62 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  63 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  64 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  65                                                     // with 'config' auth_type)
  66 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  67                                                     // this db is displayed
  68                                                     // at left frame
  69                                                     // It may also be an array
  70                                                     // of db-names
  71 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  72
  73 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  74                                                     // - leave blank for no support
  75 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support
  76 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
  77                                                     //   - leave blank for no relation-links support
  78 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
  79                                                     //   - leave blank for no display fields support
  80 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF
  81                                                     //   schema - leave blank for no PDF schema support
  82 $cfg['Servers'][$i]['column_comments']              // table to store columncomments
  83                                      = '';
  84                                                     // - leave blank if you don't want to use this
  85 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
  86 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
  87                                      = '';
  88 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
  89                                      = array();
  90
  91
  92 $i++;
  93 $cfg['Servers'][$i]['host']            = '';
  94 $cfg['Servers'][$i]['port']            = '';
  95 $cfg['Servers'][$i]['socket']          = '';
  96 $cfg['Servers'][$i]['connect_type']    = 'tcp';
  97 $cfg['Servers'][$i]['controluser']     = '';
  98 $cfg['Servers'][$i]['controlpass']     = '';
  99 $cfg['Servers'][$i]['auth_type']       = 'config';
 100 $cfg['Servers'][$i]['user']            = 'root';
 101 $cfg['Servers'][$i]['password']        = '';
 102 $cfg['Servers'][$i]['only_db']         = '';
 103 $cfg['Servers'][$i]['verbose']         = '';
 104 $cfg['Servers'][$i]['pmadb']           = '';
 105 $cfg['Servers'][$i]['bookmarktable']   = '';
 106 $cfg['Servers'][$i]['relation']        = '';
 107 $cfg['Servers'][$i]['table_info']      = '';
 108 $cfg['Servers'][$i]['table_coords']    = '';
 109 $cfg['Servers'][$i]['column_comments'] = '';
 110 $cfg['Servers'][$i]['pdf_pages']       = '';
 111 $cfg['Servers'][$i]['AllowDeny']['order']
 112                                        = '';
 113 $cfg['Servers'][$i]['AllowDeny']['rules']
 114                                        = array();
 115
 116 $i++;
 117 $cfg['Servers'][$i]['host']            = '';
 118 $cfg['Servers'][$i]['port']            = '';
 119 $cfg['Servers'][$i]['socket']          = '';
 120 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 121 $cfg['Servers'][$i]['controluser']     = '';
 122 $cfg['Servers'][$i]['controlpass']     = '';
 123 $cfg['Servers'][$i]['auth_type']       = 'config';
 124 $cfg['Servers'][$i]['user']            = 'root';
 125 $cfg['Servers'][$i]['password']        = '';
 126 $cfg['Servers'][$i]['only_db']         = '';
 127 $cfg['Servers'][$i]['verbose']         = '';
 128 $cfg['Servers'][$i]['pmadb']           = '';
 129 $cfg['Servers'][$i]['bookmarktable']   = '';
 130 $cfg['Servers'][$i]['relation']        = '';
 131 $cfg['Servers'][$i]['table_info']      = '';
 132 $cfg['Servers'][$i]['table_coords']    = '';
 133 $cfg['Servers'][$i]['column_comments'] = '';
 134 $cfg['Servers'][$i]['pdf_pages']       = '';
 135 $cfg['Servers'][$i]['AllowDeny']['order']
 136                                        = '';
 137 $cfg['Servers'][$i]['AllowDeny']['rules']
 138                                        = array();
 139
 140 // If you have more than one server configured, you can set $cfg['ServerDefault']
 141 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 142 // or set it to 0 to be given a list of servers without logging in
 143 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 144 // set to that server.
 145 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 146 $cfg['Server']        = '';
 147 unset($cfg['Servers'][0]);
 148
 149
 150 /**
 151  * Other core phpMyAdmin settings
 152  */
 153 $cfg['OBGzip']                = TRUE;   // use GZIP output buffering if possible
 154 $cfg['PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
 155 $cfg['ExecTimeLimit']         = 300;    // maximum execution time in seconds (0 for no limit)
 156 $cfg['SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
 157                                         // locked tables (since MySQL 3.23.30)
 158 $cfg['ShowSQL']               = TRUE;   // show SQL queries as run
 159 $cfg['AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
 160 $cfg['Confirm']               = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 161 $cfg['LoginCookieRecall']     = TRUE;   // recall previous login in cookie auth. mode or not
 162 $cfg['UseDbSearch']           = TRUE;   // whether to enable the "database search" feature
 163                                         // or not
 164
 165 // Left frame setup
 166 $cfg['LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
 167                                         // current tables in the left frame.
 168 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
 169
 170 // In the main frame, at startup...
 171 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 172                                         // the pages about database details and table
 173                                         // properties
 174 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 175 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 176 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 177 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 178 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 179
 180 // In browse mode...
 181 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 182 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
 183 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 184 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 185 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 186                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 187                                         // descending order for fields of type
 188                                         // TIME, DATE, DATETIME & TIMESTAMP,
 189                                         // ascending order else-)
 190
 191 // In edit mode...
 192 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 193                                         // valid values are:
 194                                         //   FALSE  allow editing
 195                                         //   'blob' allow editing except for BLOB fields
 196                                         //   'all'  disallow editing
 197 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 198
 199 // For the export features...
 200 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 201 $cfg['GZipDump']              = TRUE;   // compression for
 202 $cfg['BZipDump']              = TRUE;   // dump files
 203
 204 // Default Tabs display settings
 205 $cfg['DefaultTabDatabase']    = 'db_details_structure.php3';
 206                                    // Possible values:
 207                                    // 'db_details_structure.php3' = tables list
 208                                    // 'db_details.php3' = sql form
 209                                    // 'db_search.php3' = search query
 210 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php3';
 211                                    // Possible values:
 212                                    // 'tbl_properties_structure.php3' = fields list
 213                                    // 'tbl_properties.php3' = sql form
 214                                    // 'tbl_select.php3 = select page
 215                                    // 'tbl_change.php3 = insert row page
 216
 217
 218 /**
 219  * Link to the official MySQL documentation
 220  * Be sure to include no trailing slash on the path
 221  */
 222 $cfg['ManualBaseShort'] = 'http://www.mysql.com/doc';
 223
 224
 225 /**
 226  * Language and charset conversion settings
 227  */
 228 // Default language to use, if not browser-defined or user-defined
 229 $cfg['DefaultLang'] = 'en';
 230
 231 // Default charset to use for recoding of MySQL queries, does not take
 232 // any effect when charsets recoding is switched off by
 233 // $cfg['AllowAnywhereRecoding'] or in language file
 234 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 235 $cfg['DefaultCharset'] = 'iso-8859-1';
 236
 237 // Allow charset recoding of MySQL queries, must be also enabled in language
 238 // file to make harder using other language files than unicode.
 239 $cfg['AllowAnywhereRecoding'] = TRUE;
 240
 241 // Force: always use this language - must be defined in
 242 //        libraries/select_lang.lib.php3
 243 // $cfg['Lang']     = 'en';
 244 // Loads language file
 245 require('./libraries/select_lang.lib.php3');
 246
 247
 248 /**
 249  * Customization & design
 250  */
 251 $cfg['LeftWidth']           = 150;          // left frame width
 252 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
 253 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
 254                                             // (blank for no pointer)
 255 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
 256 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
 257                                             // (leave blank for no background image)
 258 $cfg['Border']              = 0;            // border width on tables
 259 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
 260 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
 261 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
 262 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
 263                                             // (blank for no pointer)
 264 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
 265                                             // by clicking on it) in browse mode
 266                                             // (blank for no marker)
 267 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 268                                             // (this value will be emphasized (*2) for sql
 269                                             // query textareas)
 270 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 271 $cfg['LimitChars']          = 50;           // max field data length in browse mode
 272 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 273                                             // (or at the top with vertical browse)
 274 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 275                                             // (or at the bottom with vertical browse)
 276 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction (horizontal|vertical)
 277 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 278
 279 // Syntax coloring (Note: this feature will be implemented after 2.3.0)
 280 $cfg['UseSyntaxColoring']   = TRUE;         // use syntaxcoloring on output of SQL, might be a little slower
 281 $cfg['colorFunctions']      = '#FF0000';    // Colors used for Syntaxcoloring of SQL Statements
 282 $cfg['colorKeywords']       = '#990099';
 283 $cfg['colorStrings']        = '#008000';
 284 $cfg['colorColType']        = '#FF9900';
 285 $cfg['colorAdd']            = '#0000FF';
 286
 287
 288 /**
 289  * Available charsets for MySQL conversion. currently contains all which could
 290  * be found in lang/* files and few more.
 291  *
 292  * Charsets will be shown in same order as here listed, so if you frequently
 293  * use some of these move them to the top.
 294  */
 295 $cfg['AvailableCharsets'] = array(
 296     'iso-8859-1',
 297     'iso-8859-2',
 298     'iso-8859-3',
 299     'iso-8859-4',
 300     'iso-8859-5',
 301     'iso-8859-6',
 302     'iso-8859-7',
 303     'iso-8859-8',
 304     'iso-8859-9',
 305     'iso-8859-10',
 306     'iso-8859-11',
 307     'iso-8859-12',
 308     'iso-8859-13',
 309     'iso-8859-14',
 310     'iso-8859-15',
 311     'windows-1250',
 312     'windows-1251',
 313     'windows-1252',
 314     'windows-1257',
 315     'koi8-r',
 316     'big5',
 317     'gb2312',
 318     'utf-8',
 319     'utf-7',
 320     'x-user-defined',
 321     'euc-jp',
 322     'ks_c_5601-1987',
 323     'tis-620',
 324     'SHIFT_JIS'
 325 );
 326
 327
 328 /**
 329  * MySQL settings
 330  */
 331 // Column types;
 332 // varchar, tinyint, text and date are listed first, based on estimated popularity
 333 $cfg['ColumnTypes'] = array(
 334    'VARCHAR',
 335    'TINYINT',
 336    'TEXT',
 337    'DATE',
 338    'SMALLINT',
 339    'MEDIUMINT',
 340    'INT',
 341    'BIGINT',
 342    'FLOAT',
 343    'DOUBLE',
 344    'DECIMAL',
 345    'DATETIME',
 346    'TIMESTAMP',
 347    'TIME',
 348    'YEAR',
 349    'CHAR',
 350    'TINYBLOB',
 351    'TINYTEXT',
 352    'BLOB',
 353    'MEDIUMBLOB',
 354    'MEDIUMTEXT',
 355    'LONGBLOB',
 356    'LONGTEXT',
 357    'ENUM',
 358    'SET'
 359 );
 360
 361 // Atributes
 362 $cfg['AttributeTypes'] = array(
 363    '',
 364    'BINARY',
 365    'UNSIGNED',
 366    'UNSIGNED ZEROFILL'
 367 );
 368
 369 // Available functions
 370 if ($cfg['ShowFunctionFields']) {
 371     $cfg['Functions'] = array(
 372        'ASCII',
 373        'CHAR',
 374        'SOUNDEX',
 375        'LCASE',
 376        'UCASE',
 377        'NOW',
 378        'PASSWORD',
 379        'MD5',
 380        'ENCRYPT',
 381        'RAND',
 382        'LAST_INSERT_ID',
 383        'COUNT',
 384        'AVG',
 385        'SUM',
 386        'CURDATE',
 387        'CURTIME',
 388        'FROM_DAYS',
 389        'FROM_UNIXTIME',
 390        'PERIOD_ADD',
 391        'PERIOD_DIFF',
 392        'TO_DAYS',
 393        'UNIX_TIMESTAMP',
 394        'USER',
 395        'WEEKDAY',
 396        'CONCAT'
 397     );
 398 } // end if
 399
 400 // Keywords for syntax coloring
 401 if ($cfg['UseSyntaxColoring']) {
 402     $cfg['keywords'] = array(
 403         'SELECT',
 404         'INSERT',
 405         'LEFT',
 406         'INNER',
 407         'UPDATE',
 408         'REPLACE',
 409         'EXPLAIN',
 410         'FROM',
 411         'WHERE',
 412         'LIMIT',
 413         'INTO',
 414         'ALTER',
 415         'ADD',
 416         'DROP',
 417         'GROUP',
 418         'ORDER',
 419         'CHANGE',
 420         'CREATE',
 421         'DELETE',
 422         'VALUES'
 423     );
 424 } // end if
 425
 426 // Other reserved words for syntax coloring
 427 if ($cfg['UseSyntaxColoring']) {
 428     $cfg['additional'] = array(
 429         'TABLE',
 430         'DEFAULT',
 431         'NULL',
 432         'NOT',
 433         'INDEX',
 434         'PRIMARY',
 435         'KEY',
 436         'UNIQUE',
 437         'BINARY',
 438         'UNSIGNED',
 439         'ZEROFILL',
 440         'AUTO_INCREMENT',
 441         'AND',
 442         'OR',
 443         'DISTINCT',
 444         'DISTINCTROW',
 445         'BY',
 446         'ON',
 447         'JOIN',
 448         'BETWEEN',
 449         'IN',
 450         'IF',
 451         'ELSE',
 452         'SET'
 453     );
 454 }
 455
 456
 457 /**
 458  * Unset magic_quotes_runtime - do not change!
 459  */
 460 set_magic_quotes_runtime(0);
 461
 462
 463 /**
 464  * File Revision - do not change either!
 465  */
 466 $cfg['FileRevision'] = '$Revision$';
 467 ?>