config.inc.php

   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  * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  57  * at least one server configuration uses 'cookie' auth_type, enter here a
  58  * passphrase that will be used by blowfish. The maximum length seems to be 46
  59  * characters.
  60  */
  61 $cfg['blowfish_secret'] = '';
  62
  63 /**
  64  * Server(s) configuration
  65  */
  66 $i = 0;
  67 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
  68 // You can disable a server config entry by setting host to ''.
  69 $i++;
  70 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
  71 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  72 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  73 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  74 $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
  75 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  76                                                     // (requires PHP >= 4.3.0)
  77 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  78                                                     // (this user must have read-only
  79 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  80                                                     // and "mysql/db" tables).
  81                                                     // The controluser is also
  82                                                     // used for all relational
  83                                                     // features (pmadb)
  84 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  85 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  86 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  87                                                     // with 'config' auth_type)
  88 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  89                                                     // this db is displayed in left frame
  90                                                     // It may also be an array of db-names, where sorting order is relevant.
  91 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  92
  93 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  94                                                     // (see scripts/create_tables.sql)
  95                                                     //   - leave blank for no support
  96                                                     //     DEFAULT: 'phpmyadmin'
  97 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
  98                                                     //   - leave blank for no bookmark support
  99                                                     //     DEFAULT: 'pma_bookmark'
 100 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
 101                                                     //   - leave blank for no relation-links support
 102                                                     //     DEFAULT: 'pma_relation'
 103 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
 104                                                     //   - leave blank for no display fields support
 105                                                     //     DEFAULT: 'pma_table_info'
 106 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
 107                                                     //   - leave blank for no PDF schema support
 108                                                     //     DEFAULT: 'pma_table_coords'
 109 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
 110                                                     //   - leave blank if you don't want to use this
 111                                                     //     DEFAULT: 'pma_pdf_pages'
 112 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
 113                                                     //   - leave blank for no column comments/mime types
 114                                                     //     DEFAULT: 'pma_column_info'
 115 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
 116                                                     //   - leave blank for no SQL query history
 117                                                     //     DEFAULT: 'pma_history'
 118 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
 119                                                     // are up to date. This prevents compatibility
 120                                                     // checks and thereby increases performance.
 121 $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
 122 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
 123                                      = '';
 124 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
 125                                      = array();
 126
 127 /**
 128  * If you are configuring for only one server, stop here. You can jump to the next
 129  *   section called "Other core phpMyAdmin settings."
 130  * The following section allows you to add a second server to this installation.
 131  */
 132
 133 $i++;
 134 $cfg['Servers'][$i]['host']            = '';
 135 $cfg['Servers'][$i]['port']            = '';
 136 $cfg['Servers'][$i]['socket']          = '';
 137 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 138 $cfg['Servers'][$i]['extension']       = 'mysql';
 139 $cfg['Servers'][$i]['compress']        = FALSE;
 140 $cfg['Servers'][$i]['controluser']     = '';
 141 $cfg['Servers'][$i]['controlpass']     = '';
 142 $cfg['Servers'][$i]['auth_type']       = 'config';
 143 $cfg['Servers'][$i]['user']            = 'root';
 144 $cfg['Servers'][$i]['password']        = '';
 145 $cfg['Servers'][$i]['only_db']         = '';
 146 $cfg['Servers'][$i]['verbose']         = '';
 147 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 148 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
 149 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
 150 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
 151 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
 152 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
 153 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
 154 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
 155 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 156 $cfg['Servers'][$i]['AllowRoot']       = TRUE;
 157 $cfg['Servers'][$i]['AllowDeny']['order']
 158                                        = '';
 159 $cfg['Servers'][$i]['AllowDeny']['rules']
 160                                        = array();
 161
 162 /**
 163  * This section allows you to configure a third server for this installation.
 164  */
 165
 166 $i++;
 167 $cfg['Servers'][$i]['host']            = '';
 168 $cfg['Servers'][$i]['port']            = '';
 169 $cfg['Servers'][$i]['socket']          = '';
 170 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 171 $cfg['Servers'][$i]['extension']       = 'mysql';
 172 $cfg['Servers'][$i]['compress']        = FALSE;
 173 $cfg['Servers'][$i]['controluser']     = '';
 174 $cfg['Servers'][$i]['controlpass']     = '';
 175 $cfg['Servers'][$i]['auth_type']       = 'config';
 176 $cfg['Servers'][$i]['user']            = 'root';
 177 $cfg['Servers'][$i]['password']        = '';
 178 $cfg['Servers'][$i]['only_db']         = '';
 179 $cfg['Servers'][$i]['verbose']         = '';
 180 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 181 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
 182 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
 183 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
 184 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
 185 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
 186 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
 187 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
 188 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 189 $cfg['Servers'][$i]['AllowRoot']       = TRUE;
 190
 191 $cfg['Servers'][$i]['AllowDeny']['order']
 192                                        = '';
 193 $cfg['Servers'][$i]['AllowDeny']['rules']
 194                                        = array();
 195
 196 // If you have more than one server configured, you can set $cfg['ServerDefault']
 197 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 198 // or set it to 0 to be given a list of servers without logging in
 199 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 200 // set to that server.
 201 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 202 $cfg['Server']        = '';
 203 unset($cfg['Servers'][0]);
 204
 205
 206 /**
 207  * Other core phpMyAdmin settings
 208  */
 209 $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
 210 $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
 211 $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
 212 $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
 213                                           // locked tables (since MySQL 3.23.30)
 214 $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
 215 $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
 216 $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 217 $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
 218 $cfg['LoginCookieValidity']     = 1800;   // validity of cookie login (in seconds)
 219 $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
 220                                           // or not
 221 $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
 222                                           // even if one of the queries failed
 223 $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
 224                                           // multiple-statement queries. See the read_dump.php file for hardcoded
 225                                           // defaults on how many queries a statement may contain!
 226 $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth
 227
 228 // Left frame setup
 229 $cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the
 230                                          // current tables in the left frame.
 231 $cfg['LeftFrameDBTree']       = TRUE;    // turn the select-based light menu into a tree
 232 $cfg['LeftFrameDBSeparator']  = '_';     // the separator to sub-tree the select-based light menu tree
 233 $cfg['LeftFrameTableSeparator']= '__';   // Which string will be used to generate table prefixes
 234                                          // to split/nest tables into multiple categories
 235 $cfg['LeftFrameTableLevel']   = '1';     // How many sublevels should be displayed when splitting
 236                                          // up tables by the above Separator
 237 $cfg['ShowTooltip']           = TRUE;    // display table comment as tooltip in left frame
 238 $cfg['ShowTooltipAliasDB']    = FALSE;   // if ShowToolTip is enabled, this defines that table/db comments
 239 $cfg['ShowTooltipAliasTB']    = FALSE;   // are shown (in the left menu and db_details_structure) instead of
 240                                          // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
 241                                          // use the Aliases for nested descriptors, not the table itself.
 242
 243 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 244 $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
 245 $cfg['DisplayServersList']    = FALSE;  // server choice as links
 246
 247 // In the main frame, at startup...
 248 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 249                                         // the pages about database details and table
 250                                         // properties
 251 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 252 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 253 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 254 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 255 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 256
 257 // In browse mode...
 258 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 259 $cfg['NavigationBarIconic']   = 'both'; // Use icons instead of text for the navigation bar buttons
 260                                         // and on right panel top menu (server db table) (TRUE|FALSE|'both')
 261 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 262 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 263 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 264                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 265                                         // descending order for fields of type
 266                                         // TIME, DATE, DATETIME & TIMESTAMP,
 267                                         // ascending order else-)
 268
 269 // In edit mode...
 270 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 271                                         // valid values are:
 272                                         //   FALSE  allow editing
 273                                         //   'blob' allow editing except for BLOB fields
 274                                         //   'all'  disallow editing
 275 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 276 $cfg['CharEditing']           = 'input';
 277                                         // Which editor should be used for CHAR/VARCHAR fields:
 278                                         //  input - allows limiting of input length
 279                                         //  textarea - allows newlines in fields
 280 $cfg['InsertRows']            = 2;      // How many rows can be inserted at one time
 281
 282 $cfg['ForeignKeyDropdownOrder'] =       // Sort order for items in a foreign-key dropdown box.
 283     array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.
 284 $cfg['ForeignKeyMaxLimit'] = 100;       // A dropdown will be used if fewer items are present
 285
 286
 287 // For the export features...
 288 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 289 $cfg['GZipDump']              = TRUE;   // compression for
 290 $cfg['BZipDump']              = TRUE;   // dump files
 291 $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
 292                                         // fly without need for much memory.
 293                                         // If you encounter problems with
 294                                         // created gzip/bzip2 files disable
 295                                         // this feature.
 296
 297 // Tabs display settings
 298 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
 299 $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
 300 $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
 301                                         // (a value larger than 1 results in some information being hidden)
 302
 303 $cfg['DefaultTabServer']      = 'main.php';
 304                                    // Possible values:
 305                                    // 'main.php' = the welcome page
 306                                    // (recommended for multiuser setups)
 307                                    // 'server_databases.php' = list of databases
 308                                    // 'server_status.php' = runtime information
 309                                    // 'server_variables.php' = MySQL server variables
 310                                    // 'server_privileges.php' = user management
 311                                    // 'server_processlist.php' = process list
 312 $cfg['DefaultTabDatabase']    = 'db_details_structure.php';
 313                                    // Possible values:
 314                                    // 'db_details_structure.php' = tables list
 315                                    // 'db_details.php' = sql form
 316                                    // 'db_search.php' = search query
 317                                    // 'db_operations.php' = operations on database
 318 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php';
 319                                    // Possible values:
 320                                    // 'tbl_properties_structure.php' = fields list
 321                                    // 'tbl_properties.php' = sql form
 322                                    // 'tbl_select.php = select page
 323                                    // 'tbl_change.php = insert row page
 324
 325 /**
 326  * Export defaults
 327  */
 328
 329 $cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
 330 $cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2
 331
 332 $cfg['Export']['asfile']                    = FALSE;
 333 $cfg['Export']['onserver']                  = FALSE;
 334 $cfg['Export']['onserver_overwrite']        = FALSE;
 335 $cfg['Export']['remember_file_template']    = TRUE;
 336 $cfg['Export']['file_template_table']       = '__TABLE__';
 337 $cfg['Export']['file_template_database']    = '__DB__';
 338 $cfg['Export']['file_template_server']      = '__SERVER__';
 339
 340 $cfg['Export']['htmlexcel_columns']         = FALSE;
 341 $cfg['Export']['htmlexcel_null']            = 'NULL';
 342
 343 $cfg['Export']['htmlword_structure']        = TRUE;
 344 $cfg['Export']['htmlword_data']             = TRUE;
 345 $cfg['Export']['htmlword_columns']          = FALSE;
 346 $cfg['Export']['htmlword_null']             = 'NULL';
 347
 348 $cfg['Export']['xls_columns']               = FALSE;
 349 $cfg['Export']['xls_null']                  = 'NULL';
 350
 351 $cfg['Export']['csv_columns']               = FALSE;
 352 $cfg['Export']['csv_null']                  = 'NULL';
 353 $cfg['Export']['csv_separator']             = ';';
 354 $cfg['Export']['csv_enclosed']              = '&quot;';
 355 $cfg['Export']['csv_escaped']               = '\\';
 356 $cfg['Export']['csv_terminated']            = 'AUTO';
 357 $cfg['Export']['excel_columns']             = FALSE;
 358 $cfg['Export']['excel_null']                = 'NULL';
 359 $cfg['Export']['excel_edition']             = 'win'; // win/mac
 360
 361 $cfg['Export']['latex_structure']           = TRUE;
 362 $cfg['Export']['latex_data']                = TRUE;
 363 $cfg['Export']['latex_columns']             = TRUE;
 364 $cfg['Export']['latex_relation']            = TRUE;
 365 $cfg['Export']['latex_comments']            = TRUE;
 366 $cfg['Export']['latex_mime']                = TRUE;
 367 $cfg['Export']['latex_null']                = '\textit{NULL}';
 368 $cfg['Export']['latex_caption']             = TRUE;
 369 $cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
 370 $cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';
 371
 372 $cfg['Export']['sql_structure']             = TRUE;
 373 $cfg['Export']['sql_data']                  = TRUE;
 374 $cfg['Export']['sql_compat']                = 'NONE';
 375 $cfg['Export']['sql_disable_fk']            = FALSE;
 376 $cfg['Export']['sql_use_transaction']       = FALSE;
 377 $cfg['Export']['sql_drop_database']         = FALSE;
 378 $cfg['Export']['sql_drop_table']            = FALSE;
 379 $cfg['Export']['sql_if_not_exists']         = FALSE;
 380 $cfg['Export']['sql_auto_increment']        = TRUE;
 381 $cfg['Export']['sql_backquotes']            = TRUE;
 382 $cfg['Export']['sql_dates']                 = FALSE;
 383 $cfg['Export']['sql_relation']              = FALSE;
 384 $cfg['Export']['sql_columns']               = FALSE;
 385 $cfg['Export']['sql_delayed']               = FALSE;
 386 $cfg['Export']['sql_ignore']                = FALSE;
 387 $cfg['Export']['sql_hex_for_binary']        = TRUE;
 388 $cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace
 389 $cfg['Export']['sql_extended']              = FALSE;
 390 $cfg['Export']['sql_comments']              = FALSE;
 391 $cfg['Export']['sql_mime']                  = FALSE;
 392 $cfg['Export']['sql_header_comment']        = ''; // \n is replaced by new line
 393
 394 /**
 395  * Link to the official MySQL documentation.
 396  * Be sure to include no trailing slash on the path.
 397  * See http://dev.mysql.com/doc/ for more information
 398  * about MySQL manuals and their types.
 399  */
 400 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en';
 401
 402 /**
 403  * Type of MySQL documentation:
 404  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 405  *   searchable - "Searchable, with user comments"
 406  *   chapters   - "HTML, one page per chapter"
 407  *   big        - "HTML, all on one page"
 408  *   none       - do not show documentation links
 409  */
 410 $cfg['MySQLManualType'] = 'searchable';
 411
 412
 413 /**
 414  * PDF options
 415  */
 416 $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
 417 $cfg['PDFDefaultPageSize']  = 'A4';
 418
 419
 420 /**
 421  * Language and charset conversion settings
 422  */
 423 // Default language to use, if not browser-defined or user-defined
 424 $cfg['DefaultLang'] = 'en-iso-8859-1';
 425
 426 // Force: always use this language - must be defined in
 427 //        libraries/select_lang.lib.php
 428 // $cfg['Lang']     = 'en-iso-8859-1';
 429
 430 // Default charset to use for recoding of MySQL queries, does not take
 431 // any effect when charsets recoding is switched off by
 432 // $cfg['AllowAnywhereRecoding'] or in language file
 433 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 434 $cfg['DefaultCharset'] = 'iso-8859-1';
 435
 436 // Allow charset recoding of MySQL queries, must be also enabled in language
 437 // file to make harder using other language files than unicode.
 438 // Default value is FALSE to avoid problems on servers without the iconv
 439 // extension and where dl() is not supported
 440 $cfg['AllowAnywhereRecoding'] = FALSE;
 441
 442 // You can select here which functions will be used for charset conversion.
 443 // Possible values are:
 444 //      auto   - automatically use available one (first is tested iconv, then
 445 //               recode)
 446 //      iconv  - use iconv or libiconv functions
 447 //      recode - use recode_string function
 448 $cfg['RecodingEngine'] = 'auto';
 449
 450 // Specify some parameters for iconv used in charset conversion. See iconv
 451 // documentation for details:
 452 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
 453 $cfg['IconvExtraParams'] = '';
 454
 455 // Available charsets for MySQL conversion. currently contains all which could
 456 // be found in lang/* files and few more.
 457 // Charsets will be shown in same order as here listed, so if you frequently
 458 // use some of these move them to the top.
 459 $cfg['AvailableCharsets'] = array(
 460     'iso-8859-1',
 461     'iso-8859-2',
 462     'iso-8859-3',
 463     'iso-8859-4',
 464     'iso-8859-5',
 465     'iso-8859-6',
 466     'iso-8859-7',
 467     'iso-8859-8',
 468     'iso-8859-9',
 469     'iso-8859-10',
 470     'iso-8859-11',
 471     'iso-8859-12',
 472     'iso-8859-13',
 473     'iso-8859-14',
 474     'iso-8859-15',
 475     'windows-1250',
 476     'windows-1251',
 477     'windows-1252',
 478     'windows-1256',
 479     'windows-1257',
 480     'koi8-r',
 481     'big5',
 482     'gb2312',
 483     'utf-8',
 484     'utf-7',
 485     'x-user-defined',
 486     'euc-jp',
 487     'ks_c_5601-1987',
 488     'tis-620',
 489     'SHIFT_JIS'
 490 );
 491
 492 /**
 493  * Customization & design
 494  *
 495  * The graphical settings are now located in themes/themename/layout.inc.php
 496  */
 497
 498 $cfg['LeftPointerEnable']   = TRUE;         // enable the left panel pointer
 499                                             // (used when LeftFrameLight is FALSE)
 500                                             // see also LeftPointerColor
 501                                             // in layout.inc.php
 502
 503 $cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer
 504                                             // see also BrowsePointerColor
 505                                             // in layout.inc.php
 506
 507 $cfg['BrowseMarkerEnable'] = TRUE;         // enable the browse marker
 508                                             // see also BrowseMarkerColor
 509                                             // in layout.inc.php
 510
 511 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 512                                             // (this value will be emphasized (*2) for sql
 513                                             // query textareas and (*1.25) for query window)
 514 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 515 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
 516 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 517 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 518 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 519 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
 520 $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
 521 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 522                                             // (or at the top with vertical browse)
 523 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 524                                             // (or at the bottom with vertical browse)
 525 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
 526                                             // (horizontal|vertical|horizontalflipped)
 527 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
 528                                             // creating columns (tbl_properties)
 529                                             // (horizontal|vertical)
 530
 531 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
 532                                             // NOTE: CSS only works in IE browsers!
 533 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
 534 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
 535 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 536
 537 $cfg['QueryFrame']          = TRUE;         // displays a link or icon in the left frame to open the querybox, and activates the querybox when clicking on [Edit] on the results page.
 538 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
 539                                             // if set to 'false', the target of the querybox is always the right frame.
 540 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
 541 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
 542 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
 543                                             // If FALSE, this utilizes JS-routines to display
 544                                             // query history (lost by window close)
 545 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
 546                                             // (sql|files|history|full)
 547 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
 548                                             // should be kept?
 549 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
 550 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
 551                                             // table rows.
 552 $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
 553                                             // the PDF page editor. Requires an IE6/Mozilla based browser.
 554
 555 $cfg['NaturalOrder']        = TRUE;         // Sort table and database in natural order
 556
 557
 558 //-----------------------------------------------------------------------------
 559 // custom-setup by mkkeck: 2004-05-04
 560 //    some specials for new icons and scrollings
 561 // FIXME:
 562 // 2004-05-08 rabus: We need to rearrange these variables.
 563
 564 $cfg['ShowHttpHostTitle']   = TRUE;            // show HttpHost in browsers window title (true|false)?
 565 $cfg['SetHttpHostTitle']    = '';              // if ShowHttpHostTitle=true, please set your host (server)
 566                                              // or an other string, wich should be shown in browsers window title.
 567                                              // If not set (or empty), the PMA will get your real Host-Adress.
 568
 569 $cfg['ErrorIconic']          = TRUE;    // show some icons for warning, error and information messages (true|false)?
 570 $cfg['MainPageIconic']       = TRUE;    // show icons in list on main page and on menu tabs (true|false)?
 571 $cfg['ReplaceHelpImg']       = TRUE;    // show help button instead of strDocumentation (true|false)?
 572
 573 // theme manager
 574 $cfg['ThemePath']           = './themes';    // using themes manager please set up here the path to 'themes'
 575                                              // else leave empty
 576 $cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty
 577                                              // set it to true, else set it to false (default is false);
 578 $cfg['ThemeDefault']        = 'original';         // set up default theme, if ThemePath not empty
 579                                              // you can set up here an valid path to themes or 'original' for
 580                                              // the original pma-theme
 581 $cfg['ThemePerServer']      = FALSE;         // allow diferent theme for each configured server
 582
 583 //-----------------------------------------------------------------------------
 584
 585
 586 /**
 587  * Default queries
 588  * %d will be replaced by the database name.
 589  * %t will be replaced by the table name.
 590  * %f will be replaced by a list of field names.
 591  * (%t and %f only applies to DefaultQueryTable)
 592  */
 593 $cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';
 594 $cfg['DefaultQueryDatabase'] = '';
 595
 596 /**
 597  * SQL Query box settings
 598  * These are the links display in all of the SQL Query boxes
 599  */
 600 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 601 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 602 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 603 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 604 $cfg['SQLQuery']['Refresh']   = TRUE;       // Refresh the results page
 605
 606
 607 /**
 608  * Webserver upload/save/import directories
 609  */
 610 $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
 611                                             // phpMyAdmin. For example './upload'. Leave empty for
 612                                             // no upload directory support
 613 $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
 614                                             // server. For example './save'. Leave empty for no save
 615                                             // directory support.
 616 $cfg['docSQLDir']             = '';         // Directory for docSQL imports, phpMyAdmin can import
 617                                             // docSQL files from that directory. For example
 618                                             // './docSQL'. Leave empty for no docSQL import support.
 619 $cfg['TempDir']               = '';         // Directory where phpMyAdmin can save temporary files.
 620                                             // This is needed for MS Excel export, see documentation
 621                                             // how to enable that.
 622
 623
 624 /**
 625  * Misc. settings
 626  */
 627 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
 628                                             // does autodetection, which is a bit expensive for
 629                                             // php < 4.3.0, but it is the only safe vay how to
 630                                             // determine GD version.
 631 /**
 632  * SQL Parser Settings
 633  */
 634 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 635 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 636 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 637 // The graphical settings are now located in themes/themename/layout.inc.php
 638
 639 /**
 640  * If you wish to use the SQL Validator service, you should be
 641  * aware of the following:
 642  * All SQL statements are stored anonymously for statistical purposes.
 643  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 644  * All rights reserved.
 645  */
 646 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 647 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 648 $cfg['SQLValidator']['password'] = '';      // Password for username
 649
 650 /**
 651  * Developers ONLY!
 652  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 653  */
 654 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 655 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 656 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 657                                             // Anything below the threshold is not displayed
 658
 659
 660 /**
 661  * MySQL settings
 662  */
 663 // Column types;
 664 // varchar, tinyint, text and date are listed first, based on estimated popularity
 665 $cfg['ColumnTypes'] = array(
 666    'VARCHAR',
 667    'TINYINT',
 668    'TEXT',
 669    'DATE',
 670    'SMALLINT',
 671    'MEDIUMINT',
 672    'INT',
 673    'BIGINT',
 674    'FLOAT',
 675    'DOUBLE',
 676    'DECIMAL',
 677    'DATETIME',
 678    'TIMESTAMP',
 679    'TIME',
 680    'YEAR',
 681    'CHAR',
 682    'TINYBLOB',
 683    'TINYTEXT',
 684    'BLOB',
 685    'MEDIUMBLOB',
 686    'MEDIUMTEXT',
 687    'LONGBLOB',
 688    'LONGTEXT',
 689    'ENUM',
 690    'SET',
 691    'BOOL'
 692 );
 693
 694 // Attributes
 695 // Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
 696 // for MySQL >= 4.1.2, in tbl_properties.inc.php
 697
 698 $cfg['AttributeTypes'] = array(
 699    '',
 700    'BINARY',
 701    'UNSIGNED',
 702    'UNSIGNED ZEROFILL'
 703 );
 704
 705 // Available functions
 706 if ($cfg['ShowFunctionFields']) {
 707     $cfg['Functions'] = array(
 708        'ASCII',
 709        'CHAR',
 710        'SOUNDEX',
 711        'LCASE',
 712        'UCASE',
 713        'NOW',
 714        'PASSWORD',
 715        'OLD_PASSWORD',
 716        'MD5',
 717        'SHA1',
 718        'ENCRYPT',
 719        'RAND',
 720        'LAST_INSERT_ID',
 721        'COUNT',
 722        'AVG',
 723        'SUM',
 724        'CURDATE',
 725        'CURTIME',
 726        'FROM_DAYS',
 727        'FROM_UNIXTIME',
 728        'PERIOD_ADD',
 729        'PERIOD_DIFF',
 730        'TO_DAYS',
 731        'UNIX_TIMESTAMP',
 732        'USER',
 733        'WEEKDAY',
 734        'CONCAT'
 735     );
 736
 737     // Which column types will be mapped to which Group?
 738     $cfg['RestrictColumnTypes'] = array(
 739        'VARCHAR'      => 'FUNC_CHAR',
 740        'TINYINT'      => 'FUNC_NUMBER',
 741        'TEXT'         => 'FUNC_CHAR',
 742        'DATE'         => 'FUNC_DATE',
 743        'SMALLINT'     => 'FUNC_NUMBER',
 744        'MEDIUMINT'    => 'FUNC_NUMBER',
 745        'INT'          => 'FUNC_NUMBER',
 746        'BIGINT'       => 'FUNC_NUMBER',
 747        'FLOAT'        => 'FUNC_NUMBER',
 748        'DOUBLE'       => 'FUNC_NUMBER',
 749        'DECIMAL'      => 'FUNC_NUMBER',
 750        'DATETIME'     => 'FUNC_DATE',
 751        'TIMESTAMP'    => 'FUNC_DATE',
 752        'TIME'         => 'FUNC_DATE',
 753        'YEAR'         => 'FUNC_DATE',
 754        'CHAR'         => 'FUNC_CHAR',
 755        'TINYBLOB'     => 'FUNC_CHAR',
 756        'TINYTEXT'     => 'FUNC_CHAR',
 757        'BLOB'         => 'FUNC_CHAR',
 758        'MEDIUMBLOB'   => 'FUNC_CHAR',
 759        'MEDIUMTEXT'   => 'FUNC_CHAR',
 760        'LONGBLOB'     => 'FUNC_CHAR',
 761        'LONGTEXT'     => 'FUNC_CHAR',
 762        'ENUM'         => '',
 763        'SET'          => ''
 764     );
 765
 766     // Map above defined groups to any function
 767     $cfg['RestrictFunctions'] = array(
 768         'FUNC_CHAR'   => array(
 769             'ASCII',
 770             'CHAR',
 771             'SOUNDEX',
 772             'LCASE',
 773             'UCASE',
 774             'PASSWORD',
 775             'OLD_PASSWORD',
 776             'MD5',
 777             'SHA1',
 778             'ENCRYPT',
 779             'LAST_INSERT_ID',
 780             'USER',
 781             'CONCAT'
 782         ),
 783
 784         'FUNC_DATE'   => array(
 785             'NOW',
 786             'CURDATE',
 787             'CURTIME',
 788             'FROM_DAYS',
 789             'FROM_UNIXTIME',
 790             'PERIOD_ADD',
 791             'PERIOD_DIFF',
 792             'TO_DAYS',
 793             'UNIX_TIMESTAMP',
 794             'WEEKDAY'
 795         ),
 796
 797         'FUNC_NUMBER' => array(
 798             'ASCII',
 799             'CHAR',
 800             'MD5',
 801             'SHA1',
 802             'ENCRYPT',
 803             'RAND',
 804             'LAST_INSERT_ID',
 805             'UNIX_TIMESTAMP',
 806             'COUNT',
 807             'AVG',
 808             'SUM'
 809         )
 810     );
 811
 812     // Default functions for above defined groups
 813     $cfg['DefaultFunctions'] = array(
 814         'FUNC_CHAR'         => '',
 815         'FUNC_DATE'         => '',
 816         'FUNC_NUMBER'       => '',
 817         'first_timestamp'   => 'NOW'
 818     );
 819
 820
 821 } // end if
 822
 823 // Search operators
 824 $cfg['NumOperators'] = array(
 825    '=',
 826    '>',
 827    '>=',
 828    '<',
 829    '<=',
 830    '!=',
 831    'LIKE',
 832    'NOT LIKE'
 833 );
 834
 835 $cfg['TextOperators'] = array(
 836    'LIKE',
 837    'LIKE %...%',
 838    'NOT LIKE',
 839    '=',
 840    '!=',
 841    'REGEXP',
 842    'NOT REGEXP'
 843 );
 844
 845 $cfg['EnumOperators'] = array(
 846    '=',
 847    '!='
 848 );
 849
 850 $cfg['SetOperators'] = array(
 851    'IN',
 852    'NOT IN'
 853 );
 854
 855 $cfg['NullOperators'] = array(
 856    'IS NULL',
 857    'IS NOT NULL'
 858 );
 859
 860 $cfg['UnaryOperators'] = array(
 861    'IS NULL'     => 1,
 862    'IS NOT NULL' => 1
 863 );
 864
 865 /**
 866  * Unset magic_quotes_runtime - do not change!
 867  */
 868 set_magic_quotes_runtime(0);
 869
 870 /**
 871  * File Revision - do not change either!
 872  */
 873 $cfg['FileRevision'] = '$Revision$';
 874 ?>