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