Translated using Weblate (French)
[phpmyadmin.git] / libraries / config.default.php
blobe3aa2cdd14ae64ed7eb3ed951488a38ef08b461b
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * <code>
5 * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
6 * NN N O O !! D D O O NN N O O T E D D I T !!
7 * N N N O O !! D D O O N N N O O T EEEE D D I T !!
8 * N NN O O D D O O N NN O O T E D D I T
9 * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
10 * </code>
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
15 * config.inc.php
17 * All directives are explained in the documentation
19 * @package PhpMyAdmin
22 /**
23 * Your phpMyAdmin URL.
25 * Complete the variable below with the full URL ie
26 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
28 * It must contain characters that are valid for a URL, and the path is
29 * case sensitive on some Web servers, for example Unix-based servers.
31 * In most cases you can leave this variable empty, as the correct value
32 * will be detected automatically. However, we recommend that you do
33 * test to see that the auto-detection code works in your system. A good
34 * test is to browse a table, then edit a row and save it. There will be
35 * an error message if phpMyAdmin cannot auto-detect the correct value.
37 * @global string $cfg['PmaAbsoluteUri']
39 $cfg['PmaAbsoluteUri'] = '';
41 /**
42 * Disable the default warning that is displayed on the DB Details Structure page if
43 * any of the required Tables for the configuration storage could not be found
45 * @global boolean $cfg['PmaNoRelation_DisableWarning']
47 $cfg['PmaNoRelation_DisableWarning'] = false;
49 /**
50 * Disable the default warning that is displayed if Suhosin is detected
52 * @global boolean $cfg['SuhosinDisableWarning']
54 $cfg['SuhosinDisableWarning'] = false;
56 /**
57 * Disable the default warning that is displayed if mcrypt is missing for
58 * cookie authentication.
60 * @global boolean $cfg['McryptDisableWarning']
62 $cfg['McryptDisableWarning'] = false;
64 /**
65 * Disable the default warning that is displayed if a diffrence between
66 * the MySQL library and server is detected.
68 * @global boolean $cfg['['ServerLibraryDifference_DisableWarning']']
70 $cfg['ServerLibraryDifference_DisableWarning'] = false;
72 /**
73 * Disable the default warning about MySQL reserved words in column names
75 * @global boolean $cfg['ReservedWordDisableWarning']
77 $cfg['ReservedWordDisableWarning'] = false;
79 /**
80 * Show warning about incomplete translations on certain threshold.
82 * @global boolean $cfg['TranslationWarningThreshold']
84 $cfg['TranslationWarningThreshold'] = 80;
86 /**
87 * Allows phpMyAdmin to be included from a other document in a frame;
88 * setting this to true is a potential security hole
90 * @global boolean $cfg['AllowThirdPartyFraming']
92 $cfg['AllowThirdPartyFraming'] = false;
94 /**
95 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
96 * at least one server configuration uses 'cookie' auth_type, enter here a
97 * pass phrase that will be used by blowfish. The maximum length seems to be 46
98 * characters.
100 * @global string $cfg['blowfish_secret']
102 $cfg['blowfish_secret'] = '';
105 /*******************************************************************************
106 * Server(s) configuration
108 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
109 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
110 * to ''. If you want more than one server, just copy following section
111 * (including $i incrementation) several times. There is no need to define
112 * full server array, just define values you need to change.
114 * @global array $cfg['Servers']
116 $cfg['Servers'] = array();
118 $i = 1;
121 * MySQL hostname or IP address
123 * @global string $cfg['Servers'][$i]['host']
125 $cfg['Servers'][$i]['host'] = 'localhost';
128 * MySQL port - leave blank for default port
130 * @global string $cfg['Servers'][$i]['port']
132 $cfg['Servers'][$i]['port'] = '';
135 * Path to the socket - leave blank for default socket
137 * @global string $cfg['Servers'][$i]['socket']
139 $cfg['Servers'][$i]['socket'] = '';
142 * Use SSL for connecting to MySQL server?
144 * @global boolean $cfg['Servers'][$i]['ssl']
146 $cfg['Servers'][$i]['ssl'] = false;
149 * How to connect to MySQL server ('tcp' or 'socket')
151 * @global string $cfg['Servers'][$i]['connect_type']
153 $cfg['Servers'][$i]['connect_type'] = 'tcp';
156 * The PHP MySQL extension to use ('mysql' or 'mysqli')
158 * @global string $cfg['Servers'][$i]['extension']
160 $cfg['Servers'][$i]['extension'] = 'mysqli';
163 * Use compressed protocol for the MySQL connection
165 * @global boolean $cfg['Servers'][$i]['compress']
167 $cfg['Servers'][$i]['compress'] = false;
170 * MySQL control host. This permits to use a host different than the
171 * main host, for the phpMyAdmin configuration storage. If left empty,
172 * $cfg['Servers'][$i]['host'] is used instead.
174 * @global string $cfg['Servers'][$i]['controlhost']
176 $cfg['Servers'][$i]['controlhost'] = '';
179 * MySQL control user settings (this user must have read-only
180 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
181 * used for all relational features (pmadb)
183 * @global string $cfg['Servers'][$i]['controluser']
185 $cfg['Servers'][$i]['controluser'] = '';
188 * MySQL control user settings (this user must have read-only
189 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
190 * used for all relational features (pmadb)
192 * @global string $cfg['Servers'][$i]['controlpass']
194 $cfg['Servers'][$i]['controlpass'] = '';
197 * Authentication method (valid choices: config, http, signon or cookie)
199 * @global string $cfg['Servers'][$i]['auth_type']
201 $cfg['Servers'][$i]['auth_type'] = 'cookie';
204 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
206 * @global string $cfg['Servers'][$i]['auth_http_realm']
208 $cfg['Servers'][$i]['auth_http_realm'] = '';
211 * File containing Swekey ids and login names (see /contrib);
212 * leave empty to deactivate Swekey hardware authentication
214 * @global string $cfg['Servers'][$i]['auth_swekey_config']
216 $cfg['Servers'][$i]['auth_swekey_config'] = '';
219 * MySQL user
221 * @global string $cfg['Servers'][$i]['user']
223 $cfg['Servers'][$i]['user'] = 'root';
226 * MySQL password (only needed with 'config' auth_type)
228 * @global string $cfg['Servers'][$i]['password']
230 $cfg['Servers'][$i]['password'] = '';
233 * Session to use for 'signon' authentication method
235 * @global string $cfg['Servers'][$i]['SignonSession']
237 $cfg['Servers'][$i]['SignonSession'] = '';
240 * PHP script to use for 'signon' authentication method
242 * @global string $cfg['Servers'][$i]['SignonScript']
244 $cfg['Servers'][$i]['SignonScript'] = '';
247 * URL where to redirect user to login for 'signon' authentication method
249 * @global string $cfg['Servers'][$i]['SignonURL']
251 $cfg['Servers'][$i]['SignonURL'] = '';
254 * URL where to redirect user after logout
256 * @global string $cfg['Servers'][$i]['LogoutURL']
258 $cfg['Servers'][$i]['LogoutURL'] = '';
261 * Whether to try to connect without password
263 * @global boolean $cfg['Servers'][$i]['nopassword']
265 $cfg['Servers'][$i]['nopassword'] = false;
268 * If set to a db-name, only this db is displayed in navigation panel
269 * It may also be an array of db-names
271 * @global string $cfg['Servers'][$i]['only_db']
273 $cfg['Servers'][$i]['only_db'] = '';
276 * Database name to be hidden from listings
278 * @global string $cfg['Servers'][$i]['hide_db']
280 $cfg['Servers'][$i]['hide_db'] = '';
283 * Verbose name for this host - leave blank to show the hostname
284 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
286 * @global string $cfg['Servers'][$i]['verbose']
288 $cfg['Servers'][$i]['verbose'] = '';
291 * Database used for Relation, Bookmark and PDF Features
292 * (see examples/create_tables.sql)
293 * - leave blank for no support
294 * SUGGESTED: 'phpmyadmin'
296 * @global string $cfg['Servers'][$i]['pmadb']
298 $cfg['Servers'][$i]['pmadb'] = '';
301 * Bookmark table
302 * - leave blank for no bookmark support
303 * SUGGESTED: 'pma__bookmark'
305 * @global string $cfg['Servers'][$i]['bookmarktable']
307 $cfg['Servers'][$i]['bookmarktable'] = '';
310 * table to describe the relation between links (see doc)
311 * - leave blank for no relation-links support
312 * SUGGESTED: 'pma__relation'
314 * @global string $cfg['Servers'][$i]['relation']
316 $cfg['Servers'][$i]['relation'] = '';
319 * table to describe the display fields
320 * - leave blank for no display fields support
321 * SUGGESTED: 'pma__table_info'
323 * @global string $cfg['Servers'][$i]['table_info']
325 $cfg['Servers'][$i]['table_info'] = '';
328 * table to describe the tables position for the PDF schema
329 * - leave blank for no PDF schema support
330 * SUGGESTED: 'pma__table_coords'
332 * @global string $cfg['Servers'][$i]['table_coords']
334 $cfg['Servers'][$i]['table_coords'] = '';
337 * table to describe pages of relationpdf
338 * - leave blank if you don't want to use this
339 * SUGGESTED: 'pma__pdf_pages'
341 * @global string $cfg['Servers'][$i]['pdf_pages']
343 $cfg['Servers'][$i]['pdf_pages'] = '';
346 * table to store column information
347 * - leave blank for no column comments/mime types
348 * SUGGESTED: 'pma__column_info'
350 * @global string $cfg['Servers'][$i]['column_info']
352 $cfg['Servers'][$i]['column_info'] = '';
355 * table to store SQL history
356 * - leave blank for no SQL query history
357 * SUGGESTED: 'pma__history'
359 * @global string $cfg['Servers'][$i]['history']
361 $cfg['Servers'][$i]['history'] = '';
364 * table to store the coordinates for Designer
365 * - leave blank for no Designer feature
366 * SUGGESTED: 'pma__designer_coords'
368 * @global string $cfg['Servers'][$i]['designer_coords']
370 $cfg['Servers'][$i]['designer_coords'] = '';
373 * table to store recently used tables
374 * - leave blank for no "persistent" recently used tables
375 * SUGGESTED: 'pma__recent'
377 $cfg['Servers'][$i]['recent'] = '';
380 * table to store UI preferences for tables
381 * - leave blank for no "persistent" UI preferences
382 * SUGGESTED: 'pma__table_uiprefs'
384 $cfg['Servers'][$i]['table_uiprefs'] = '';
387 * table to store SQL tracking
388 * - leave blank for no SQL tracking
389 * SUGGESTED: 'pma__tracking'
391 * @global string $cfg['Servers'][$i]['tracking']
393 $cfg['Servers'][$i]['tracking'] = '';
396 * table to store user preferences
397 * - leave blank to disable server storage
398 * SUGGESTED: 'pma__userconfig'
400 * @global string $cfg['Servers'][$i]['userconfig']
402 $cfg['Servers'][$i]['userconfig'] = '';
405 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
407 * In case where tables in databases is modified (e.g. dropped or renamed),
408 * table_uiprefs may contains invalid data (referring to tables which are not
409 * exist anymore).
410 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
411 * newest record in table_uiprefs and automatically delete older records.
413 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
415 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
418 * whether to allow root login
420 * @global boolean $cfg['Servers'][$i]['AllowRoot']
422 $cfg['Servers'][$i]['AllowRoot'] = true;
425 * whether to allow login of any user without a password
427 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
429 $cfg['Servers'][$i]['AllowNoPassword'] = false;
432 * Host authentication order, leave blank to not use
434 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
436 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
439 * Host authentication rules, leave blank for defaults
441 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
443 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
446 * Disable use of INFORMATION_SCHEMA. Is always 'false' for Drizzle.
448 * @see https://sourceforge.net/p/phpmyadmin/bugs/2606/
449 * @see http://bugs.mysql.com/19588
450 * @global boolean $cfg['Servers'][$i]['DisableIS']
452 $cfg['Servers'][$i]['DisableIS'] = true;
455 * SQL command to fetch available databases
457 * by default most user will be fine with SHOW DATABASES,
458 * for servers with a huge amount of databases it is possible to
459 * define a command which executes faster but with less information
461 * especially when accessing database servers from ISPs changing this command
462 * can result in a great speed improvement
464 * false will disable fetching databases from the server, only databases in
465 * $cfg['Servers'][$i]['only_db'] will be displayed
467 * #user# will be replaced by current user
469 * examples:
470 * 'SHOW DATABASES'
471 * "SHOW DATABASES LIKE '#user#\_%'"
472 * 'SELECT DISTINCT TABLE_SCHEMA FROM information_schema.SCHEMA_PRIVILEGES'
473 * 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA'
474 * false
476 * @global array $cfg['Servers'][$i]['ShowDatabasesCommand']
478 $cfg['Servers'][$i]['ShowDatabasesCommand'] = 'SHOW DATABASES';
481 * Whether the tracking mechanism creates
482 * versions for tables and views automatically.
484 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
487 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
490 * Defines the list of statements
491 * the auto-creation uses for new versions.
493 * @global string $cfg['Servers'][$i]['tracking_default_statements']
496 $cfg['Servers'][$i]['tracking_default_statements']
497 = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
498 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
499 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
502 * Whether a DROP VIEW IF EXISTS statement will be added
503 * as first line to the log when creating a view.
505 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
508 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
511 * Whether a DROP TABLE IF EXISTS statement will be added
512 * as first line to the log when creating a table.
514 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
517 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
520 * Whether a DROP DATABASE IF EXISTS statement will be added
521 * as first line to the log when creating a database.
523 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
526 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
529 * Enables caching of TABLE STATUS outputs for specific databases on this server
530 * (in some cases TABLE STATUS can be very slow, so you may want to cache it).
531 * APC is used (if the PHP extension is available, if not, this setting is ignored
532 * silently). You have to provide StatusCacheLifetime.
533 * Takes effect only if DisableIS is true.
535 * @global array $cfg['Servers'][$i]['StatusCacheDatabases']
537 $cfg['Servers'][$i]['StatusCacheDatabases'] = array();
540 * Lifetime in seconds of the TABLE STATUS cache if StatusCacheDatabases is used
542 * @global integer $cfg['Servers'][$i]['StatusCacheLifetime']
544 $cfg['Servers'][$i]['StatusCacheLifetime'] = 0;
547 * Default server (0 = no default server)
549 * If you have more than one server configured, you can set $cfg['ServerDefault']
550 * to any one of them to auto-connect to that server when phpMyAdmin is started,
551 * or set it to 0 to be given a list of servers without logging in
552 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
553 * set to that server.
555 * @global integer $cfg['ServerDefault']
557 $cfg['ServerDefault'] = 1;
560 * Other core phpMyAdmin settings
564 * whether version check is active
566 * @global boolean $cfg['VersionCheck']
568 if (defined('VERSION_CHECK_DEFAULT')) {
569 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
570 } else {
571 $cfg['VersionCheck'] = true;
575 * maximum number of db's displayed in database list
577 * @global integer $cfg['MaxDbList']
579 $cfg['MaxDbList'] = 100;
582 * maximum number of items displayed in navigation panel
584 * @global integer $cfg['MaxDbList']
586 $cfg['MaxNavigationItems'] = 250;
589 * maximum number of tables displayed in table list
591 * @global integer $cfg['MaxTableList']
593 $cfg['MaxTableList'] = 250;
596 * whether to show hint or not
598 * @global boolean $cfg['ShowHint']
600 $cfg['ShowHint'] = true;
603 * maximum number of characters when a SQL query is displayed
605 * @global integer $cfg['MaxCharactersInDisplayedSQL']
607 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
610 * use GZIP output buffering if possible (true|false|'auto')
612 * @global string $cfg['OBGzip']
614 $cfg['OBGzip'] = 'auto';
617 * use persistent connections to MySQL database
619 * @global boolean $cfg['PersistentConnections']
621 $cfg['PersistentConnections'] = false;
624 * whether to force using HTTPS
626 * @global boolean $cfg['ForceSSL']
628 $cfg['ForceSSL'] = false;
631 * maximum execution time in seconds (0 for no limit)
633 * @global integer $cfg['ExecTimeLimit']
635 $cfg['ExecTimeLimit'] = 300;
638 * Path for storing session data (session_save_path PHP parameter).
640 * @global integer $cfg['SessionSavePath']
642 $cfg['SessionSavePath'] = '';
645 * maximum allocated bytes ('0' for no limit)
646 * this is a string because '16M' is a valid value; we must put here
647 * a string as the default value so that /setup accepts strings
649 * @global string $cfg['MemoryLimit']
651 $cfg['MemoryLimit'] = '0';
654 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
655 * Is ignored for Drizzle.
657 * @global boolean $cfg['SkipLockedTables']
659 $cfg['SkipLockedTables'] = false;
662 * show SQL queries as run
664 * @global boolean $cfg['ShowSQL']
666 $cfg['ShowSQL'] = true;
669 * retain SQL input on Ajax execute
671 * @global boolean $cfg['RetainQueryEditor']
673 $cfg['RetainQueryBox'] = false;
676 * use CodeMirror syntax highlighting for editing SQL
678 * @global boolean $cfg['CodemirrorEnable']
680 $cfg['CodemirrorEnable'] = true;
683 * show a 'Drop database' link to normal users
685 * @global boolean $cfg['AllowUserDropDatabase']
687 $cfg['AllowUserDropDatabase'] = false;
690 * confirm some commands that can result in loss of data
691 * (see "need_confirm" in the parser)
693 * @global boolean $cfg['Confirm']
695 $cfg['Confirm'] = true;
698 * recall previous login in cookie authentication mode or not
700 * @global boolean $cfg['LoginCookieRecall']
702 $cfg['LoginCookieRecall'] = true;
705 * validity of cookie login (in seconds; 1440 matches php.ini's
706 * session.gc_maxlifetime)
708 * @global integer $cfg['LoginCookieValidity']
710 $cfg['LoginCookieValidity'] = 1440;
713 * how long login cookie should be stored (in seconds)
715 * @global integer $cfg['LoginCookieStore']
717 $cfg['LoginCookieStore'] = 0;
720 * whether to delete all login cookies on logout
722 * @global boolean $cfg['LoginCookieDeleteAll']
724 $cfg['LoginCookieDeleteAll'] = true;
727 * whether to enable the "database search" feature or not
729 * @global boolean $cfg['UseDbSearch']
731 $cfg['UseDbSearch'] = true;
734 * if set to true, PMA continues computing multiple-statement queries
735 * even if one of the queries failed
737 * @global boolean $cfg['IgnoreMultiSubmitErrors']
739 $cfg['IgnoreMultiSubmitErrors'] = false;
742 * allow login to any user entered server in cookie based authentication
744 * @global boolean $cfg['AllowArbitraryServer']
746 $cfg['AllowArbitraryServer'] = false;
749 /*******************************************************************************
750 * Error handler configuration
752 * this configures phpMyAdmin's own error handler, it is used to avoid information
753 * disclosure, gather errors for logging, reporting and displaying
755 * @global array $cfg['Error_Handler']
757 $cfg['Error_Handler'] = array();
760 * whether to display errors or not
762 * this does not affect errors of type E_USER_*
764 * @global boolean $cfg['Error_Handler']['display']
766 $cfg['Error_Handler']['display'] = false;
769 * (NOT IMPLEMENTED YET)
770 * where to log errors, false or empty to disable
772 * <code>
773 * // EXAMPLE log to std PHP error log
774 * $cfg['Error_Handler']['log'] = array(0);
775 * // EXAMPLE mail errors
776 * $cfg['Error_Handler']['log'] = array(1, 'admin@example.org');
777 * // EXAMPLE append to specific file
778 * $cfg['Error_Handler']['log'] = array(3, '/var/log/phpmyadmin_error.log');
779 * </code>
781 * @see http://php.net/error_log
782 * @global string $cfg['Error_Handler']['log']
784 //$cfg['Error_Handler']['log'] = false;
787 * gather all errors in session to be displayed on a error reporting page
788 * for viewing and/or sending to phpMyAdmin developer team
790 * @global boolean $cfg['Error_Handler']['gather']
792 $cfg['Error_Handler']['gather'] = false;
795 /*******************************************************************************
796 * Navigation panel setup
800 * turn the select-based light menu into a tree
802 * @global boolean $cfg['NavigationTreeEnableGrouping']
804 $cfg['NavigationTreeEnableGrouping'] = true;
807 * the separator to sub-tree the select-based light menu tree
809 * @global string $cfg['NavigationTreeDbSeparator']
811 $cfg['NavigationTreeDbSeparator'] = '_';
814 * Which string will be used to generate table prefixes
815 * to split/nest tables into multiple categories
817 * @global string $cfg['NavigationTreeTableSeparator']
819 $cfg['NavigationTreeTableSeparator'] = '__';
822 * How many sublevels should be displayed when splitting up tables
823 * by the above Separator
825 * @global integer $cfg['NavigationTreeTableLevel']
827 $cfg['NavigationTreeTableLevel'] = 1;
830 * display logo at top of navigation panel
832 * @global boolean $cfg['NavigationDisplayLogo']
834 $cfg['NavigationDisplayLogo'] = true;
837 * where should logo link point to (can also contain an external URL)
839 * @global string $cfg['NavigationLogoLink']
841 $cfg['NavigationLogoLink'] = 'index.php';
844 * whether to open the linked page in the main window ('main') or
845 * in a new window ('new')
847 * @global string $cfg['NavigationLogoLinkWindow']
849 $cfg['NavigationLogoLinkWindow'] = 'main';
852 * number of recently used tables displayed in the navigation panel
854 * @global integer $cfg['NumRecentTables']
856 $cfg['NumRecentTables'] = 10;
859 * display a JavaScript table filter in the navigation panel
860 * when more then x tables are present
862 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
864 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
867 * display server choice at top of navigation panel
869 * @global boolean $cfg['NavigationDisplayServers']
871 $cfg['NavigationDisplayServers'] = true;
874 * server choice as links
876 * @global boolean $cfg['DisplayServersList']
878 $cfg['DisplayServersList'] = false;
881 * display a JavaScript database filter in the navigation panel
882 * when more then x databases are present
884 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
886 $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
889 * target of the navigation panel quick access icon
891 * Possible values:
892 * 'tbl_structure.php' = fields list
893 * 'tbl_sql.php' = SQL form
894 * 'tbl_select.php' = search page
895 * 'tbl_change.php' = insert row page
896 * 'sql.php' = browse page
898 * @global string $cfg['NavigationTreeDefaultTabTable']
900 $cfg['NavigationTreeDefaultTabTable'] = 'tbl_structure.php';
903 /*******************************************************************************
904 * In the main panel, at startup...
908 * allow to display statistics and space usage in the pages about database
909 * details and table properties
911 * @global boolean $cfg['ShowStats']
913 $cfg['ShowStats'] = true;
916 * show PHP info link
918 * @global boolean $cfg['ShowPhpInfo']
920 $cfg['ShowPhpInfo'] = false;
923 * show MySQL server and web server information
925 * @global boolean $cfg['ShowServerInfo']
927 $cfg['ShowServerInfo'] = true;
930 * show change password link
932 * @global boolean $cfg['ShowChgPassword']
934 $cfg['ShowChgPassword'] = true;
937 * show create database form
939 * @global boolean $cfg['ShowCreateDb']
941 $cfg['ShowCreateDb'] = true;
944 /*******************************************************************************
945 * Database structure
949 * show creation timestamp column in database structure (true|false)?
951 * @global boolean $cfg['ShowDbStructureCreation']
953 $cfg['ShowDbStructureCreation'] = false;
956 * show last update timestamp column in database structure (true|false)?
958 * @global boolean $cfg['ShowDbStructureLastUpdate']
960 $cfg['ShowDbStructureLastUpdate'] = false;
963 * show last check timestamp column in database structure (true|false)?
965 * @global boolean $cfg['ShowDbStructureLastCheck']
967 $cfg['ShowDbStructureLastCheck'] = false;
970 * allow hide action columns to drop down menu in database structure (true|false)?
972 * @global boolean $cfg['HideStructureActions']
974 $cfg['HideStructureActions'] = true;
977 /*******************************************************************************
978 * In browse mode...
982 * Use icons instead of text for the navigation bar buttons (table browse)
983 * ('text'|'icons'|'both')
985 * @global string $cfg['TableNavigationLinksMode']
987 $cfg['TableNavigationLinksMode'] = 'icons';
990 * Defines whether a user should be displayed a "show all (records)"
991 * button in browse mode or not.
993 * @global boolean $cfg['ShowAll']
995 $cfg['ShowAll'] = false;
998 * Number of rows displayed when browsing a result set. If the result
999 * set contains more rows, "Previous" and "Next".
1001 * @global integer $cfg['MaxRows']
1003 $cfg['MaxRows'] = 30;
1006 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1007 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1008 * ascending order else-)
1010 * @global string $cfg['Order']
1012 $cfg['Order'] = 'SMART';
1015 * default for 'Show binary contents as HEX'
1017 * @global string $cfg['DisplayBinaryAsHex']
1019 $cfg['DisplayBinaryAsHex'] = true;
1022 * grid editing: save edited cell(s) in browse-mode at once
1024 * @global boolean $cfg['SaveCellsAtOnce']
1027 $cfg['SaveCellsAtOnce'] = false;
1030 * grid editing: which action triggers it, or completely disable the feature
1032 * Possible values:
1033 * 'click'
1034 * 'double-click'
1035 * 'disabled'
1037 * @global string $cfg['GridEditing']
1039 $cfg['GridEditing'] ='double-click';
1042 /*******************************************************************************
1043 * In edit mode...
1047 * disallow editing of binary fields
1048 * valid values are:
1049 * false allow editing
1050 * 'blob' allow editing except for BLOB fields
1051 * 'noblob' disallow editing except for BLOB fields
1052 * 'all' disallow editing
1054 * @global string $cfg['ProtectBinary']
1056 $cfg['ProtectBinary'] = 'blob';
1059 * Display the function fields in edit/insert mode
1061 * @global boolean $cfg['ShowFunctionFields']
1063 $cfg['ShowFunctionFields'] = true;
1066 * Display the type fields in edit/insert mode
1068 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1070 $cfg['ShowFieldTypesInDataEditView'] = true;
1073 * Which editor should be used for CHAR/VARCHAR fields:
1074 * input - allows limiting of input length
1075 * textarea - allows newlines in fields
1077 * @global string $cfg['CharEditing']
1079 $cfg['CharEditing'] = 'input';
1082 * The minimum size for character input fields
1084 * @global integer $cfg['MinSizeForInputField']
1086 $cfg['MinSizeForInputField'] = 4;
1089 * The maximum size for character input fields
1091 * @global integer $cfg['MinSizeForInputField']
1093 $cfg['MaxSizeForInputField'] = 60;
1096 * How many rows can be inserted at one time
1098 * @global integer $cfg['InsertRows']
1100 $cfg['InsertRows'] = 2;
1103 * Sort order for items in a foreign-key drop-down list.
1104 * 'content' is the referenced data, 'id' is the key value.
1106 * @global array $cfg['ForeignKeyDropdownOrder']
1108 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
1111 * A drop-down list will be used if fewer items are present
1113 * @global integer $cfg['ForeignKeyMaxLimit']
1115 $cfg['ForeignKeyMaxLimit'] = 100;
1118 /*******************************************************************************
1119 * For the export features...
1123 * Allow for the use of zip compression (requires zip support to be enabled)
1125 * @global boolean $cfg['ZipDump']
1127 $cfg['ZipDump'] = true;
1130 * Allow for the use of gzip compression (requires zlib)
1132 * @global boolean $cfg['GZipDump']
1134 $cfg['GZipDump'] = true;
1137 * Allow for the use of bzip2 compression (requires bz2 extension)
1139 * @global boolean $cfg['BZipDump']
1141 $cfg['BZipDump'] = true;
1144 * Will compress gzip/bzip2 exports on the fly without the need for much memory.
1145 * If you encounter problems with created gzip/bzip2 files disable this feature.
1147 * @global boolean $cfg['CompressOnFly']
1149 $cfg['CompressOnFly'] = true;
1152 /*******************************************************************************
1153 * Tabs display settings
1157 * How to display the menu tabs ('icons'|'text'|'both')
1159 * @global boolean $cfg['TabsMode']
1161 $cfg['TabsMode'] = 'both';
1164 * How to display various action links ('icons'|'text'|'both')
1166 * @global boolean $cfg['ActionLinksMode']
1168 $cfg['ActionLinksMode'] = 'both';
1171 * How many columns should be used for table display of a database?
1172 * (a value larger than 1 results in some information being hidden)
1174 * @global integer $cfg['PropertiesNumColumns']
1176 $cfg['PropertiesNumColumns'] = 1;
1179 * Possible values:
1180 * 'index.php' = the welcome page
1181 * (recommended for multiuser setups)
1182 * 'server_databases.php' = list of databases
1183 * 'server_status.php' = runtime information
1184 * 'server_variables.php' = MySQL server variables
1185 * 'server_privileges.php' = user management
1187 * @global string $cfg['DefaultTabServer']
1189 $cfg['DefaultTabServer'] = 'index.php';
1192 * Possible values:
1193 * 'db_structure.php' = tables list
1194 * 'db_sql.php' = SQL form
1195 * 'db_search.php' = search query
1196 * 'db_operations.php' = operations on database
1198 * @global string $cfg['DefaultTabDatabase']
1200 $cfg['DefaultTabDatabase'] = 'db_structure.php';
1203 * Possible values:
1204 * 'tbl_structure.php' = fields list
1205 * 'tbl_sql.php' = SQL form
1206 * 'tbl_select.php' = search page
1207 * 'tbl_change.php' = insert row page
1208 * 'sql.php' = browse page
1210 * @global string $cfg['DefaultTabTable']
1212 $cfg['DefaultTabTable'] = 'sql.php';
1214 /*******************************************************************************
1215 * Export defaults
1217 $cfg['Export'] = array();
1220 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xls/xml/yaml
1222 * @global string $cfg['Export']['format']
1224 $cfg['Export']['format'] = 'sql';
1227 * quick/custom/custom-no-form
1229 * @global string $cfg['Export']['format']
1231 $cfg['Export']['method'] = 'quick';
1234 * none/zip/gzip/bzip2
1236 * @global string $cfg['Export']['compression']
1238 $cfg['Export']['compression'] = 'none';
1243 * @global boolean $cfg['Export']['asfile']
1245 $cfg['Export']['asfile'] = true;
1250 * @global string $cfg['Export']['charset']
1252 $cfg['Export']['charset'] = '';
1257 * @global boolean $cfg['Export']['onserver']
1259 $cfg['Export']['onserver'] = false;
1264 * @global boolean $cfg['Export']['onserver_overwrite']
1266 $cfg['Export']['onserver_overwrite'] = false;
1271 * @global boolean $cfg['Export']['quick_export_onserver']
1273 $cfg['Export']['quick_export_onserver'] = false;
1278 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1280 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1285 * @global boolean $cfg['Export']['remember_file_template']
1287 $cfg['Export']['remember_file_template'] = true;
1292 * @global string $cfg['Export']['file_template_table']
1294 $cfg['Export']['file_template_table'] = '@TABLE@';
1299 * @global string $cfg['Export']['file_template_database']
1301 $cfg['Export']['file_template_database'] = '@DATABASE@';
1306 * @global string $cfg['Export']['file_template_server']
1308 $cfg['Export']['file_template_server'] = '@SERVER@';
1313 * @global string $cfg['Export']['codegen_structure_or_data']
1315 $cfg['Export']['codegen_structure_or_data'] = 'data';
1320 * @global $cfg['Export']['codegen_format']
1322 $cfg['Export']['codegen_format'] = 0;
1327 * @global boolean $cfg['Export']['ods_columns']
1329 $cfg['Export']['ods_columns'] = false;
1334 * @global string $cfg['Export']['ods_null']
1336 $cfg['Export']['ods_null'] = 'NULL';
1341 * @global string $cfg['Export']['odt_structure_or_data']
1343 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1348 * @global boolean $cfg['Export']['odt_columns']
1350 $cfg['Export']['odt_columns'] = true;
1355 * @global boolean $cfg['Export']['odt_relation']
1357 $cfg['Export']['odt_relation'] = true;
1362 * @global boolean $cfg['Export']['odt_comments']
1364 $cfg['Export']['odt_comments'] = true;
1369 * @global boolean $cfg['Export']['odt_mime']
1371 $cfg['Export']['odt_mime'] = true;
1376 * @global string $cfg['Export']['odt_null']
1378 $cfg['Export']['odt_null'] = 'NULL';
1383 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1385 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1390 * @global boolean $cfg['Export']['htmlword_columns']
1392 $cfg['Export']['htmlword_columns'] = false;
1397 * @global string $cfg['Export']['htmlword_null']
1399 $cfg['Export']['htmlword_null'] = 'NULL';
1404 * @global string $cfg['Export']['texytext_structure_or_data']
1406 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1411 * @global boolean $cfg['Export']['texytext_columns']
1413 $cfg['Export']['texytext_columns'] = false;
1418 * @global string $cfg['Export']['texytext_null']
1420 $cfg['Export']['texytext_null'] = 'NULL';
1425 * @global boolean $cfg['Export']['xls_columns']
1427 $cfg['Export']['xls_columns'] = false;
1432 * @global string $cfg['Export']['xls_structure_or_data']
1434 $cfg['Export']['xls_structure_or_data'] = 'data';
1439 * @global string $cfg['Export']['xls_null']
1441 $cfg['Export']['xls_null'] = 'NULL';
1446 * @global boolean $cfg['Export']['xlsx_columns']
1448 $cfg['Export']['xlsx_columns'] = false;
1453 * @global string $cfg['Export']['xlsx_structure_or_data']
1455 $cfg['Export']['xlsx_structure_or_data'] = 'data';
1460 * @global string $cfg['Export']['xlsx_null']
1462 $cfg['Export']['xlsx_null'] = 'NULL';
1467 * @global boolean $cfg['Export']['csv_columns']
1469 $cfg['Export']['csv_columns'] = false;
1474 * @global string $cfg['Export']['csv_structure_or_data']
1476 $cfg['Export']['csv_structure_or_data'] = 'data';
1481 * @global string $cfg['Export']['csv_null']
1483 $cfg['Export']['csv_null'] = 'NULL';
1488 * @global string $cfg['Export']['csv_separator']
1490 $cfg['Export']['csv_separator'] = ',';
1495 * @global string $cfg['Export']['csv_enclosed']
1497 $cfg['Export']['csv_enclosed'] = '"';
1502 * @global string $cfg['Export']['csv_escaped']
1504 $cfg['Export']['csv_escaped'] = '"';
1509 * @global string $cfg['Export']['csv_terminated']
1511 $cfg['Export']['csv_terminated'] = 'AUTO';
1516 * @global string $cfg['Export']['csv_removeCRLF']
1518 $cfg['Export']['csv_removeCRLF'] = false;
1523 * @global boolean $cfg['Export']['excel_columns']
1525 $cfg['Export']['excel_columns'] = false;
1530 * @global string $cfg['Export']['excel_null']
1532 $cfg['Export']['excel_null'] = 'NULL';
1535 * win/mac
1537 * @global string $cfg['Export']['excel_edition']
1539 $cfg['Export']['excel_edition'] = 'win';
1544 * @global string $cfg['Export']['excel_removeCRLF']
1546 $cfg['Export']['excel_removeCRLF'] = false;
1551 * @global string $cfg['Export']['excel_structure_or_data']
1553 $cfg['Export']['excel_structure_or_data'] = 'data';
1558 * @global string $cfg['Export']['latex_structure_or_data']
1560 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1565 * @global boolean $cfg['Export']['latex_columns']
1567 $cfg['Export']['latex_columns'] = true;
1572 * @global boolean $cfg['Export']['latex_relation']
1574 $cfg['Export']['latex_relation'] = true;
1579 * @global boolean $cfg['Export']['latex_comments']
1581 $cfg['Export']['latex_comments'] = true;
1586 * @global boolean $cfg['Export']['latex_mime']
1588 $cfg['Export']['latex_mime'] = true;
1593 * @global string $cfg['Export']['latex_null']
1595 $cfg['Export']['latex_null'] = '\textit{NULL}';
1600 * @global boolean $cfg['Export']['latex_caption']
1602 $cfg['Export']['latex_caption'] = true;
1607 * @global string $cfg['Export']['latex_structure_caption']
1609 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1614 * @global string $cfg['Export']['latex_structure_continued_caption']
1616 $cfg['Export']['latex_structure_continued_caption']
1617 = 'strLatexStructure strLatexContinued';
1622 * @global string $cfg['Export']['latex_data_caption']
1624 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1629 * @global string $cfg['Export']['latex_data_continued_caption']
1631 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1636 * @global string $cfg['Export']['latex_data_label']
1638 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1643 * @global string $cfg['Export']['latex_structure_label']
1645 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1650 * @global string $cfg['Export']['mediawiki_structure_or_data']
1652 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1657 * @global boolean $cfg['Export']['mediawiki_caption']
1660 $cfg['Export']['mediawiki_caption'] = true;
1664 * @global boolean $cfg['Export']['mediawiki_headers']
1666 $cfg['Export']['mediawiki_headers'] = true;
1671 * @global string $cfg['Export']['ods_structure_or_data']
1673 $cfg['Export']['ods_structure_or_data'] = 'data';
1678 * @global string $cfg['Export']['pdf_structure_or_data']
1680 $cfg['Export']['pdf_structure_or_data'] = 'data';
1685 * @global string $cfg['Export']['phparray_structure_or_data']
1687 $cfg['Export']['phparray_structure_or_data'] = 'data';
1692 * @global string $cfg['Export']['json_structure_or_data']
1694 $cfg['Export']['json_structure_or_data'] = 'data';
1699 * @global string $cfg['Export']['sql_structure_or_data']
1701 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1706 * @global string $cfg['Export']['sql_compatibility']
1708 $cfg['Export']['sql_compatibility'] = 'NONE';
1711 * Whether to include comments in SQL export.
1713 * @global string $cfg['Export']['sql_include_comments']
1715 $cfg['Export']['sql_include_comments'] = true;
1720 * @global boolean $cfg['Export']['sql_disable_fk']
1722 $cfg['Export']['sql_disable_fk'] = false;
1727 * @global boolean $cfg['Export']['sql_use_transaction']
1729 $cfg['Export']['sql_use_transaction'] = false;
1734 * @global boolean $cfg['Export']['sql_create_database']
1736 $cfg['Export']['sql_create_database'] = false;
1741 * @global boolean $cfg['Export']['sql_drop_database']
1743 $cfg['Export']['sql_drop_database'] = false;
1748 * @global boolean $cfg['Export']['sql_drop_table']
1750 $cfg['Export']['sql_drop_table'] = false;
1755 * true by default for correct behavior when dealing with exporting
1756 * of VIEWs and the stand-in table
1757 * @global boolean $cfg['Export']['sql_if_not_exists']
1759 $cfg['Export']['sql_if_not_exists'] = true;
1764 * @global boolean $cfg['Export']['sql_procedure_function']
1766 $cfg['Export']['sql_procedure_function'] = true;
1771 * @global boolean $cfg['Export']['sql_auto_increment']
1773 $cfg['Export']['sql_auto_increment'] = true;
1778 * @global boolean $cfg['Export']['sql_backquotes']
1780 $cfg['Export']['sql_backquotes'] = true;
1785 * @global boolean $cfg['Export']['sql_dates']
1787 $cfg['Export']['sql_dates'] = false;
1792 * @global boolean $cfg['Export']['sql_relation']
1794 $cfg['Export']['sql_relation'] = false;
1799 * @global boolean $cfg['Export']['sql_truncate']
1801 $cfg['Export']['sql_truncate'] = false;
1806 * @global boolean $cfg['Export']['sql_delayed']
1808 $cfg['Export']['sql_delayed'] = false;
1813 * @global boolean $cfg['Export']['sql_ignore']
1815 $cfg['Export']['sql_ignore'] = false;
1818 * Export time in UTC.
1820 * @global boolean $cfg['Export']['sql_utc_time']
1822 $cfg['Export']['sql_utc_time'] = true;
1827 * @global boolean $cfg['Export']['sql_hex_for_blob']
1829 $cfg['Export']['sql_hex_for_blob'] = true;
1832 * insert/update/replace
1834 * @global string $cfg['Export']['sql_type']
1836 $cfg['Export']['sql_type'] = 'INSERT';
1841 * @global integer $cfg['Export']['sql_max_query_size']
1843 $cfg['Export']['sql_max_query_size'] = 50000;
1848 * @global boolean $cfg['Export']['sql_comments']
1850 $cfg['Export']['sql_comments'] = false;
1855 * @global boolean $cfg['Export']['sql_mime']
1857 $cfg['Export']['sql_mime'] = false;
1860 * \n is replaced by new line
1862 * @global string $cfg['Export']['sql_header_comment']
1864 $cfg['Export']['sql_header_comment'] = '';
1869 * @global boolean $cfg['Export']['sql_create_table_statements']
1871 $cfg['Export']['sql_create_table_statements'] = true;
1874 * Whether to use complete inserts, extended inserts, both, or neither
1876 * @global string $cfg['Export']['sql_insert_syntax']
1878 $cfg['Export']['sql_insert_syntax'] = 'both';
1883 * @global string $cfg['Export']['pdf_report_title']
1885 $cfg['Export']['pdf_report_title'] = '';
1890 *@global string $cfg['Export']['xml_structure_or_data']
1892 $cfg['Export']['xml_structure_or_data'] = 'data';
1895 * Export schema for each structure
1897 * @global string $cfg['Export']['xml_export_struc']
1899 $cfg['Export']['xml_export_struc'] = true;
1902 * Export functions
1904 * @global string $cfg['Export']['xml_export_functions']
1906 $cfg['Export']['xml_export_functions'] = true;
1909 * Export procedures
1911 * @global string $cfg['Export']['xml_export_procedures']
1913 $cfg['Export']['xml_export_procedures'] = true;
1916 * Export schema for each table
1918 * @global string $cfg['Export']['xml_export_tables']
1920 $cfg['Export']['xml_export_tables'] = true;
1923 * Export triggers
1925 * @global string $cfg['Export']['xml_export_triggers']
1927 $cfg['Export']['xml_export_triggers'] = true;
1930 * Export views
1932 * @global string $cfg['Export']['xml_export_views']
1934 $cfg['Export']['xml_export_views'] = true;
1937 * Export contents data
1939 * @global string $cfg['Export']['xml_export_contents']
1941 $cfg['Export']['xml_export_contents'] = true;
1946 * @global string $cfg['Export']['yaml_structure_or_data']
1948 $cfg['Export']['yaml_structure_or_data'] = 'data';
1950 /*******************************************************************************
1951 * Import defaults
1953 $cfg['Import'] = array();
1958 * @global string $cfg['Import']['format']
1960 $cfg['Import']['format'] = 'sql';
1963 * Default charset for import.
1965 * @global string $cfg['Import']['charset']
1967 $cfg['Import']['charset'] = '';
1972 * @global boolean $cfg['Import']['allow_interrupt']
1974 $cfg['Import']['allow_interrupt'] = true;
1979 * @global integer $cfg['Import']['skip_queries']
1981 $cfg['Import']['skip_queries'] = 0;
1986 * @global string $cfg['Import']['sql_compatibility']
1988 $cfg['Import']['sql_compatibility'] = 'NONE';
1993 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
1995 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
2000 * @global boolean $cfg['Import']['csv_replace']
2002 $cfg['Import']['csv_replace'] = false;
2007 * @global boolean $cfg['Import']['csv_ignore']
2009 $cfg['Import']['csv_ignore'] = false;
2014 * @global string $cfg['Import']['csv_terminated']
2016 $cfg['Import']['csv_terminated'] = ',';
2021 * @global string $cfg['Import']['csv_enclosed']
2023 $cfg['Import']['csv_enclosed'] = '"';
2028 * @global string $cfg['Import']['csv_escaped']
2030 $cfg['Import']['csv_escaped'] = '"';
2035 * @global string $cfg['Import']['csv_new_line']
2037 $cfg['Import']['csv_new_line'] = 'auto';
2042 * @global string $cfg['Import']['csv_columns']
2044 $cfg['Import']['csv_columns'] = '';
2049 * @global string $cfg['Import']['csv_col_names']
2051 $cfg['Import']['csv_col_names'] = false;
2056 * @global boolean $cfg['Import']['ldi_replace']
2058 $cfg['Import']['ldi_replace'] = false;
2063 * @global boolean $cfg['Import']['ldi_ignore']
2065 $cfg['Import']['ldi_ignore'] = false;
2070 * @global string $cfg['Import']['ldi_terminated']
2072 $cfg['Import']['ldi_terminated'] = ';';
2077 * @global string $cfg['Import']['ldi_enclosed']
2079 $cfg['Import']['ldi_enclosed'] = '"';
2084 * @global string $cfg['Import']['ldi_escaped']
2086 $cfg['Import']['ldi_escaped'] = '\\';
2091 * @global string $cfg['Import']['ldi_new_line']
2093 $cfg['Import']['ldi_new_line'] = 'auto';
2098 * @global string $cfg['Import']['ldi_columns']
2100 $cfg['Import']['ldi_columns'] = '';
2103 * 'auto' for auto-detection, true or false for forcing
2105 * @global string $cfg['Import']['ldi_local_option']
2107 $cfg['Import']['ldi_local_option'] = 'auto';
2112 * @global string $cfg['Import']['ods_col_names']
2114 $cfg['Import']['ods_col_names'] = false;
2119 * @global string $cfg['Import']['ods_empty_rows']
2121 $cfg['Import']['ods_empty_rows'] = true;
2126 * @global string $cfg['Import']['ods_recognize_percentages']
2128 $cfg['Import']['ods_recognize_percentages'] = true;
2133 * @global string $cfg['Import']['ods_recognize_currency']
2135 $cfg['Import']['ods_recognize_currency'] = true;
2140 * @global string $cfg['Import']['xml_col_names']
2142 $cfg['Import']['xls_col_names'] = false;
2147 * @global string $cfg['Import']['xml_empty_rows']
2149 $cfg['Import']['xls_empty_rows'] = true;
2154 * @global string $cfg['Import']['xlsx_col_names']
2156 $cfg['Import']['xlsx_col_names'] = false;
2159 * Link to the official MySQL documentation.
2160 * Be sure to include no trailing slash on the path.
2161 * See http://dev.mysql.com/doc/ for more information
2162 * about MySQL manuals and their types.
2164 * @global string $cfg['MySQLManualBase']
2166 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
2169 * Type of MySQL documentation:
2170 * viewable - "viewable online", current one used on MySQL website
2171 * searchable - "Searchable, with user comments"
2172 * chapters - "HTML, one page per chapter"
2173 * chapters_old - "HTML, one page per chapter",
2174 * format used prior to MySQL 5.0 release
2175 * big - "HTML, all on one page"
2176 * old - old style used in phpMyAdmin 2.3.0 and sooner
2177 * none - do not show documentation links
2179 * @global string $cfg['MySQLManualType']
2181 $cfg['MySQLManualType'] = 'viewable';
2184 /*******************************************************************************
2185 * PDF options
2191 * @global array $cfg['PDFPageSizes']
2193 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
2198 * @global string $cfg['PDFDefaultPageSize']
2200 $cfg['PDFDefaultPageSize'] = 'A4';
2203 /*******************************************************************************
2204 * Language and character set conversion settings
2208 * Default language to use, if not browser-defined or user-defined
2210 * @global string $cfg['DefaultLang']
2212 $cfg['DefaultLang'] = 'en';
2215 * Default connection collation
2217 * @global string $cfg['DefaultConnectionCollation']
2219 $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
2222 * Force: always use this language
2223 * $cfg['Lang'] = 'en';
2225 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2226 * English only
2228 * @global string $cfg['FilterLanguages']
2230 $cfg['FilterLanguages'] = '';
2233 * You can select here which functions will be used for character set conversion.
2234 * Possible values are:
2235 * auto - automatically use available one (first is tested iconv, then
2236 * recode)
2237 * iconv - use iconv or libiconv functions
2238 * recode - use recode_string function
2239 * none - disable encoding conversion
2241 * @global string $cfg['RecodingEngine']
2243 $cfg['RecodingEngine'] = 'auto';
2246 * Specify some parameters for iconv used in character set conversion. See iconv
2247 * documentation for details:
2248 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
2250 * @global string $cfg['IconvExtraParams']
2252 $cfg['IconvExtraParams'] = '//TRANSLIT';
2255 * Available character sets for MySQL conversion. currently contains all which could
2256 * be found in lang/* files and few more.
2257 * Character sets will be shown in same order as here listed, so if you frequently
2258 * use some of these move them to the top.
2260 * @global array $cfg['AvailableCharsets']
2262 $cfg['AvailableCharsets'] = array(
2263 'iso-8859-1',
2264 'iso-8859-2',
2265 'iso-8859-3',
2266 'iso-8859-4',
2267 'iso-8859-5',
2268 'iso-8859-6',
2269 'iso-8859-7',
2270 'iso-8859-8',
2271 'iso-8859-9',
2272 'iso-8859-10',
2273 'iso-8859-11',
2274 'iso-8859-12',
2275 'iso-8859-13',
2276 'iso-8859-14',
2277 'iso-8859-15',
2278 'windows-1250',
2279 'windows-1251',
2280 'windows-1252',
2281 'windows-1256',
2282 'windows-1257',
2283 'koi8-r',
2284 'big5',
2285 'gb2312',
2286 'utf-16',
2287 'utf-8',
2288 'utf-7',
2289 'x-user-defined',
2290 'euc-jp',
2291 'ks_c_5601-1987',
2292 'tis-620',
2293 'SHIFT_JIS'
2297 /*******************************************************************************
2298 * Customization & design
2300 * The graphical settings are now located in themes/theme-name/layout.inc.php
2304 * enable the left panel pointer
2305 * see also LeftPointerColor
2306 * in layout.inc.php
2308 * @global boolean $cfg['NavigationTreePointerEnable']
2310 $cfg['NavigationTreePointerEnable'] = true;
2313 * enable the browse pointer
2314 * see also BrowsePointerColor
2315 * in layout.inc.php
2317 * @global boolean $cfg['BrowsePointerEnable']
2319 $cfg['BrowsePointerEnable'] = true;
2322 * enable the browse marker
2323 * see also BrowseMarkerColor
2324 * in layout.inc.php
2326 * @global boolean $cfg['BrowseMarkerEnable']
2328 $cfg['BrowseMarkerEnable'] = true;
2331 * textarea size (columns) in edit mode
2332 * (this value will be emphasized (*2) for SQL
2333 * query textareas and (*1.25) for query window)
2335 * @global integer $cfg['TextareaCols']
2337 $cfg['TextareaCols'] = 40;
2340 * textarea size (rows) in edit mode
2342 * @global integer $cfg['TextareaRows']
2344 $cfg['TextareaRows'] = 15;
2347 * double size of textarea size for LONGTEXT columns
2349 * @global boolean $cfg['LongtextDoubleTextarea']
2351 $cfg['LongtextDoubleTextarea'] = true;
2354 * auto-select when clicking in the textarea of the query-box
2356 * @global boolean $cfg['TextareaAutoSelect']
2358 $cfg['TextareaAutoSelect'] = false;
2361 * textarea size (columns) for CHAR/VARCHAR
2363 * @global integer $cfg['CharTextareaCols']
2365 $cfg['CharTextareaCols'] = 40;
2368 * textarea size (rows) for CHAR/VARCHAR
2370 * @global integer $cfg['CharTextareaRows']
2372 $cfg['CharTextareaRows'] = 2;
2375 * Max field data length in browse mode for all non-numeric fields
2377 * @global integer $cfg['LimitChars']
2379 $cfg['LimitChars'] = 50;
2382 * Where to show the edit/copy/delete links in browse mode
2383 * Possible values are 'left', 'right', 'both' and 'none';
2384 * which will be interpreted as 'top', 'bottom', 'both' and 'none'
2385 * respectively for vertical display mode
2387 * @global string $cfg['RowActionLinks']
2389 $cfg['RowActionLinks'] = 'left';
2392 * default display direction (horizontal|vertical|horizontalflipped)
2394 * @global string $cfg['DefaultDisplay']
2396 $cfg['DefaultDisplay'] = 'horizontal';
2399 * remember the last way a table sorted
2401 * @global string $cfg['RememberSorting']
2403 $cfg['RememberSorting'] = true;
2406 * table-header rotation via faking or CSS? (css|fake|auto)
2407 * NOTE: CSS only works in IE browsers!
2409 * @global string $cfg['HeaderFlipType']
2411 $cfg['HeaderFlipType'] = 'auto';
2414 * shows stored relation-comments in 'browse' mode.
2416 * @global boolean $cfg['ShowBrowseComments']
2418 $cfg['ShowBrowseComments'] = true;
2421 * shows stored relation-comments in 'table property' mode.
2423 * @global boolean $cfg['ShowPropertyComments']
2425 $cfg['ShowPropertyComments']= true;
2428 * shows table display direction.
2430 $cfg['ShowDisplayDirection'] = false;
2433 * repeat header names every X cells? (0 = deactivate)
2435 * @global integer $cfg['RepeatCells']
2437 $cfg['RepeatCells'] = 100;
2440 * Set to true if Edit link should open the query to edit in the query window
2441 * and to false if we should edit in the right panel
2443 * @global boolean $cfg['EditInWindow']
2445 $cfg['EditInWindow'] = true;
2448 * Width of Query window
2450 * @global integer $cfg['QueryWindowWidth']
2452 $cfg['QueryWindowWidth'] = 550;
2455 * Height of Query window
2457 * @global integer $cfg['QueryWindowHeight']
2459 $cfg['QueryWindowHeight'] = 310;
2462 * Set to true if you want DB-based query history.If false, this utilizes
2463 * JS-routines to display query history (lost by window close)
2465 * @global boolean $cfg['QueryHistoryDB']
2467 $cfg['QueryHistoryDB'] = false;
2470 * which tab to display in the querywindow on startup
2471 * (sql|files|history|full)
2473 * @global string $cfg['QueryWindowDefTab']
2475 $cfg['QueryWindowDefTab'] = 'sql';
2478 * When using DB-based query history, how many entries should be kept?
2480 * @global integer $cfg['QueryHistoryMax']
2482 $cfg['QueryHistoryMax'] = 25;
2485 * Use MIME-Types (stored in column comments table) for
2487 * @global boolean $cfg['BrowseMIME']
2489 $cfg['BrowseMIME'] = true;
2492 * When approximate count < this, PMA will get exact count for table rows.
2494 * @global integer $cfg['MaxExactCount']
2496 $cfg['MaxExactCount'] = 0;
2499 * Zero means that no row count is done for views; see the doc
2501 * @global integer $cfg['MaxExactCountViews']
2503 $cfg['MaxExactCountViews'] = 0;
2506 * Sort table and database in natural order
2508 * @global boolean $cfg['NaturalOrder']
2510 $cfg['NaturalOrder'] = true;
2513 * Initial state for sliders
2514 * (open | closed | disabled)
2516 * @global string $cfg['InitialSlidersState']
2518 $cfg['InitialSlidersState'] = 'closed';
2521 * User preferences: disallow these settings
2522 * For possible setting names look in libraries/config/user_preferences.forms.php
2524 * @global array $cfg['UserprefsDisallow']
2526 $cfg['UserprefsDisallow'] = array();
2529 * User preferences: enable the Developer tab
2531 $cfg['UserprefsDeveloperTab'] = false;
2533 /*******************************************************************************
2534 * Window title settings
2538 * title of browser window when a table is selected
2540 * @global string $cfg['TitleTable']
2542 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2545 * title of browser window when a database is selected
2547 * @global string $cfg['TitleDatabase']
2549 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2552 * title of browser window when a server is selected
2554 * @global string $cfg['TitleServer']
2556 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2559 * title of browser window when nothing is selected
2560 * @global string $cfg['TitleDefault']
2562 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2565 /*******************************************************************************
2566 * theme manager
2570 * using themes manager please set up here the path to 'themes' else leave empty
2572 * @global string $cfg['ThemePath']
2574 $cfg['ThemePath'] = './themes';
2577 * if you want to use selectable themes and if ThemesPath not empty
2578 * set it to true, else set it to false (default is false);
2580 * @global boolean $cfg['ThemeManager']
2582 $cfg['ThemeManager'] = true;
2585 * set up default theme, if ThemePath not empty you can set up here an valid
2586 * path to themes or 'original' for the original pma-theme
2588 * @global string $cfg['ThemeDefault']
2590 $cfg['ThemeDefault'] = 'pmahomme';
2593 * allow different theme for each configured server
2595 * @global boolean $cfg['ThemePerServer']
2597 $cfg['ThemePerServer'] = false;
2600 /*******************************************************************************
2605 * Default query for table
2607 * @global string $cfg['DefaultQueryTable']
2609 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2612 * Default query for database
2614 * @global string $cfg['DefaultQueryDatabase']
2616 $cfg['DefaultQueryDatabase'] = '';
2619 /*******************************************************************************
2620 * SQL Query box settings
2621 * These are the links display in all of the SQL Query boxes
2623 * @global array $cfg['SQLQuery']
2625 $cfg['SQLQuery'] = array();
2628 * Edit link to change a query
2630 * @global boolean $cfg['SQLQuery']['Edit']
2632 $cfg['SQLQuery']['Edit'] = true;
2635 * EXPLAIN on SELECT queries
2637 * @global boolean $cfg['SQLQuery']['Explain']
2639 $cfg['SQLQuery']['Explain'] = true;
2642 * Wrap a query in PHP
2644 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2646 $cfg['SQLQuery']['ShowAsPHP'] = true;
2649 * Validate a query (see $cfg['SQLValidator'] as well)
2651 * @global boolean $cfg['SQLQuery']['Validate']
2653 $cfg['SQLQuery']['Validate'] = false;
2656 * Refresh the results page
2658 * @global boolean $cfg['SQLQuery']['Refresh']
2660 $cfg['SQLQuery']['Refresh'] = true;
2663 /*******************************************************************************
2664 * Web server upload/save/import directories
2668 * Directory for uploaded files that can be executed by phpMyAdmin.
2669 * For example './upload'. Leave empty for no upload directory support.
2670 * Use %u for username inclusion.
2672 * @global string $cfg['UploadDir']
2674 $cfg['UploadDir'] = '';
2677 * Directory where phpMyAdmin can save exported data on server.
2678 * For example './save'. Leave empty for no save directory support.
2679 * Use %u for username inclusion.
2681 * @global string $cfg['SaveDir']
2683 $cfg['SaveDir'] = '';
2686 * Directory where phpMyAdmin can save temporary files.
2688 * @global string $cfg['TempDir']
2690 $cfg['TempDir'] = '';
2694 * Misc. settings
2698 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2699 * which is the only safe way to determine GD version.
2701 * @global string $cfg['GD2Available']
2703 $cfg['GD2Available'] = 'auto';
2706 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2708 * @global array $cfg['TrustedProxies']
2710 $cfg['TrustedProxies'] = array();
2713 * We normally check the permissions on the configuration file to ensure
2714 * it's not world writable. However, phpMyAdmin could be installed on
2715 * a NTFS filesystem mounted on a non-Windows server, in which case the
2716 * permissions seems wrong but in fact cannot be detected. In this case
2717 * a sysadmin would set the following to false.
2719 $cfg['CheckConfigurationPermissions'] = true;
2722 * Limit for length of URL in links. When length would be above this limit, it
2723 * is replaced by form with button.
2724 * This is required as some web servers (IIS) have problems with long URLs.
2725 * The recommended limit is 2000
2726 * (see http://www.boutell.com/newfaq/misc/urllength.html) but we put
2727 * 1000 to accommodate Suhosin, see bug #3358750.
2729 $cfg['LinkLengthLimit'] = 1000;
2732 * Additional string to allow in CSP headers.
2734 $cfg['CSPAllow'] = '';
2737 * Disable the table maintenance mass operations, like optimizing or
2738 * repairing the selected tables of a database. An accidental execution
2739 * of such a maintenance task can enormously slow down a bigger database.
2741 $cfg['DisableMultiTableMaintenance'] = false;
2743 /*******************************************************************************
2744 * SQL Parser Settings
2746 * @global array $cfg['SQP']
2748 $cfg['SQP'] = array();
2751 * Pretty-printing style to use on queries (html, text, none)
2753 * @global string $cfg['SQP']['fmtType']
2755 $cfg['SQP']['fmtType'] = 'html';
2758 * Amount to indent each level (floats are valid)
2760 * @global integer $cfg['SQP']['fmtInd']
2762 $cfg['SQP']['fmtInd'] = '1';
2765 * Units for indenting each level (CSS Types - {em, px, pt})
2767 * @global string $cfg['SQP']['fmtIndUnit']
2769 $cfg['SQP']['fmtIndUnit'] = 'em';
2772 /*******************************************************************************
2773 * If you wish to use the SQL Validator service, you should be aware of the
2774 * following:
2775 * All SQL statements are stored anonymously for statistical purposes.
2776 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2777 * All rights reserved.
2779 * @global array $cfg['SQLValidator']
2781 $cfg['SQLValidator'] = array();
2784 * Make the SQL Validator available
2786 * @global boolean $cfg['SQLValidator']['use']
2788 $cfg['SQLValidator']['use'] = false;
2791 * If you have a custom username, specify it here (defaults to anonymous)
2793 * @global string $cfg['SQLValidator']['username']
2795 $cfg['SQLValidator']['username'] = '';
2798 * Password for username
2800 * @global string $cfg['SQLValidator']['password']
2802 $cfg['SQLValidator']['password'] = '';
2805 /*******************************************************************************
2806 * Developers ONLY!
2808 * @global array $cfg['DBG']
2810 $cfg['DBG'] = array();
2813 * Output executed queries and their execution times
2815 * @global boolean $cfg['DBG']['sql']
2817 $cfg['DBG']['sql'] = false;
2820 /*******************************************************************************
2821 * MySQL settings
2825 * Default functions for above defined groups
2827 * @global array $cfg['DefaultFunctions']
2829 $cfg['DefaultFunctions'] = array(
2830 'FUNC_CHAR' => '',
2831 'FUNC_DATE' => '',
2832 'FUNC_NUMBER' => '',
2833 'FUNC_SPATIAL' => 'GeomFromText',
2834 'FUNC_UUID' => 'UUID',
2835 'first_timestamp' => 'NOW',
2839 * Max rows retreived for zoom search
2841 $cfg['maxRowPlotLimit'] = 500;