2 /* vim: set expandtab sw=4 ts=4 sts=4: */
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 !!
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
17 * All directives are explained in the documentation
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'] = '';
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;
50 * Disable the default warning that is displayed if Suhosin is detected
52 * @global boolean $cfg['SuhosinDisableWarning']
54 $cfg['SuhosinDisableWarning'] = false;
57 * Disable the default warning that is displayed if a diffrence between
58 * the MySQL library and server is detected.
60 * @global boolean $cfg['['ServerLibraryDifference_DisableWarning']']
62 $cfg['ServerLibraryDifference_DisableWarning'] = false;
65 * Disable the default warning about MySQL reserved words in column names
67 * @global boolean $cfg['ReservedWordDisableWarning']
69 $cfg['ReservedWordDisableWarning'] = false;
72 * Show warning about incomplete translations on certain threshold.
74 * @global boolean $cfg['TranslationWarningThreshold']
76 $cfg['TranslationWarningThreshold'] = 80;
79 * Allows phpMyAdmin to be included from a other document in a frame;
80 * setting this to true is a potential security hole
82 * @global boolean $cfg['AllowThirdPartyFraming']
84 $cfg['AllowThirdPartyFraming'] = false;
87 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
88 * at least one server configuration uses 'cookie' auth_type, enter here a
89 * pass phrase that will be used by blowfish. The maximum length seems to be 46
92 * @global string $cfg['blowfish_secret']
94 $cfg['blowfish_secret'] = '';
97 /*******************************************************************************
98 * Server(s) configuration
100 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
101 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
102 * to ''. If you want more than one server, just copy following section
103 * (including $i incrementation) several times. There is no need to define
104 * full server array, just define values you need to change.
106 * @global array $cfg['Servers']
108 $cfg['Servers'] = array();
113 * MySQL hostname or IP address
115 * @global string $cfg['Servers'][$i]['host']
117 $cfg['Servers'][$i]['host'] = 'localhost';
120 * MySQL port - leave blank for default port
122 * @global string $cfg['Servers'][$i]['port']
124 $cfg['Servers'][$i]['port'] = '';
127 * Path to the socket - leave blank for default socket
129 * @global string $cfg['Servers'][$i]['socket']
131 $cfg['Servers'][$i]['socket'] = '';
134 * Use SSL for connecting to MySQL server?
136 * @global boolean $cfg['Servers'][$i]['ssl']
138 $cfg['Servers'][$i]['ssl'] = false;
141 * Path to the key file when using SSL for connecting to the MySQL server
143 * @global string $cfg['Servers'][$i]['ssl_key']
145 $cfg['Servers'][$i]['ssl_key'] = null;
148 * Path to the cert file when using SSL for connecting to the MySQL server
150 * @global string $cfg['Servers'][$i]['ssl_cert']
152 $cfg['Servers'][$i]['ssl_cert'] = null;
155 * Path to the CA file when using SSL for connecting to the MySQL server
157 * @global string $cfg['Servers'][$i]['ssl_ca']
159 $cfg['Servers'][$i]['ssl_ca'] = null;
162 * Directory containing trusted SSL CA certificates in PEM format
164 * @global string $cfg['Servers'][$i]['ssl_ca_path']
166 $cfg['Servers'][$i]['ssl_ca_path'] = null;
169 * List of allowable ciphers for SSL connections to the MySQL server
171 * @global string $cfg['Servers'][$i]['ssl_ciphers']
173 $cfg['Servers'][$i]['ssl_ciphers'] = null;
176 * How to connect to MySQL server ('tcp' or 'socket')
178 * @global string $cfg['Servers'][$i]['connect_type']
180 $cfg['Servers'][$i]['connect_type'] = 'tcp';
183 * Use compressed protocol for the MySQL connection
185 * @global boolean $cfg['Servers'][$i]['compress']
187 $cfg['Servers'][$i]['compress'] = false;
190 * MySQL control host. This permits to use a host different than the
191 * main host, for the phpMyAdmin configuration storage. If left empty,
192 * $cfg['Servers'][$i]['host'] is used instead.
194 * @global string $cfg['Servers'][$i]['controlhost']
196 $cfg['Servers'][$i]['controlhost'] = '';
199 * MySQL control port. This permits to use a port different than the
200 * main port, for the phpMyAdmin configuration storage. If left empty,
201 * $cfg['Servers'][$i]['port'] is used instead.
203 * @global string $cfg['Servers'][$i]['controlport']
205 $cfg['Servers'][$i]['controlport'] = '';
208 * MySQL control user settings (this user must have read-only
209 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
210 * used for all relational features (pmadb)
212 * @global string $cfg['Servers'][$i]['controluser']
214 $cfg['Servers'][$i]['controluser'] = '';
217 * MySQL control user settings (this user must have read-only
218 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
219 * used for all relational features (pmadb)
221 * @global string $cfg['Servers'][$i]['controlpass']
223 $cfg['Servers'][$i]['controlpass'] = '';
226 * Authentication method (valid choices: config, http, signon or cookie)
228 * @global string $cfg['Servers'][$i]['auth_type']
230 $cfg['Servers'][$i]['auth_type'] = 'cookie';
233 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
235 * @global string $cfg['Servers'][$i]['auth_http_realm']
237 $cfg['Servers'][$i]['auth_http_realm'] = '';
240 * File containing Swekey ids and login names (see /contrib);
241 * leave empty to deactivate Swekey hardware authentication
243 * @global string $cfg['Servers'][$i]['auth_swekey_config']
245 $cfg['Servers'][$i]['auth_swekey_config'] = '';
250 * @global string $cfg['Servers'][$i]['user']
252 $cfg['Servers'][$i]['user'] = 'root';
255 * MySQL password (only needed with 'config' auth_type)
257 * @global string $cfg['Servers'][$i]['password']
259 $cfg['Servers'][$i]['password'] = '';
262 * Session to use for 'signon' authentication method
264 * @global string $cfg['Servers'][$i]['SignonSession']
266 $cfg['Servers'][$i]['SignonSession'] = '';
269 * PHP script to use for 'signon' authentication method
271 * @global string $cfg['Servers'][$i]['SignonScript']
273 $cfg['Servers'][$i]['SignonScript'] = '';
276 * URL where to redirect user to login for 'signon' authentication method
278 * @global string $cfg['Servers'][$i]['SignonURL']
280 $cfg['Servers'][$i]['SignonURL'] = '';
283 * URL where to redirect user after logout
285 * @global string $cfg['Servers'][$i]['LogoutURL']
287 $cfg['Servers'][$i]['LogoutURL'] = '';
290 * Whether to try to connect without password
292 * @global boolean $cfg['Servers'][$i]['nopassword']
294 $cfg['Servers'][$i]['nopassword'] = false;
297 * If set to a db-name, only this db is displayed in navigation panel
298 * It may also be an array of db-names
300 * @global string $cfg['Servers'][$i]['only_db']
302 $cfg['Servers'][$i]['only_db'] = '';
305 * Database name to be hidden from listings
307 * @global string $cfg['Servers'][$i]['hide_db']
309 $cfg['Servers'][$i]['hide_db'] = '';
312 * Verbose name for this host - leave blank to show the hostname
313 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
315 * @global string $cfg['Servers'][$i]['verbose']
317 $cfg['Servers'][$i]['verbose'] = '';
320 * Database used for Relation, Bookmark and PDF Features
321 * (see examples/create_tables.sql)
322 * - leave blank for no support
323 * SUGGESTED: 'phpmyadmin'
325 * @global string $cfg['Servers'][$i]['pmadb']
327 $cfg['Servers'][$i]['pmadb'] = '';
331 * - leave blank for no bookmark support
332 * SUGGESTED: 'pma__bookmark'
334 * @global string $cfg['Servers'][$i]['bookmarktable']
336 $cfg['Servers'][$i]['bookmarktable'] = '';
339 * table to describe the relation between links (see doc)
340 * - leave blank for no relation-links support
341 * SUGGESTED: 'pma__relation'
343 * @global string $cfg['Servers'][$i]['relation']
345 $cfg['Servers'][$i]['relation'] = '';
348 * table to describe the display fields
349 * - leave blank for no display fields support
350 * SUGGESTED: 'pma__table_info'
352 * @global string $cfg['Servers'][$i]['table_info']
354 $cfg['Servers'][$i]['table_info'] = '';
357 * table to describe the tables position for the PDF schema
358 * - leave blank for no PDF schema support
359 * SUGGESTED: 'pma__table_coords'
361 * @global string $cfg['Servers'][$i]['table_coords']
363 $cfg['Servers'][$i]['table_coords'] = '';
366 * table to describe pages of relationpdf
367 * - leave blank if you don't want to use this
368 * SUGGESTED: 'pma__pdf_pages'
370 * @global string $cfg['Servers'][$i]['pdf_pages']
372 $cfg['Servers'][$i]['pdf_pages'] = '';
375 * table to store column information
376 * - leave blank for no column comments/mime types
377 * SUGGESTED: 'pma__column_info'
379 * @global string $cfg['Servers'][$i]['column_info']
381 $cfg['Servers'][$i]['column_info'] = '';
384 * table to store SQL history
385 * - leave blank for no SQL query history
386 * SUGGESTED: 'pma__history'
388 * @global string $cfg['Servers'][$i]['history']
390 $cfg['Servers'][$i]['history'] = '';
393 * table to store the coordinates for Designer
394 * - leave blank for no Designer feature
395 * SUGGESTED: 'pma__designer_coords'
397 * @global string $cfg['Servers'][$i]['designer_coords']
399 $cfg['Servers'][$i]['designer_coords'] = '';
402 * table to store recently used tables
403 * - leave blank for no "persistent" recently used tables
404 * SUGGESTED: 'pma__recent'
406 $cfg['Servers'][$i]['recent'] = '';
409 * table to store favorite tables
410 * - leave blank for no favorite tables
411 * SUGGESTED: 'pma__favorite'
413 $cfg['Servers'][$i]['favorite'] = '';
416 * table to store UI preferences for tables
417 * - leave blank for no "persistent" UI preferences
418 * SUGGESTED: 'pma__table_uiprefs'
420 $cfg['Servers'][$i]['table_uiprefs'] = '';
423 * table to store SQL tracking
424 * - leave blank for no SQL tracking
425 * SUGGESTED: 'pma__tracking'
427 * @global string $cfg['Servers'][$i]['tracking']
429 $cfg['Servers'][$i]['tracking'] = '';
432 * table to store user preferences
433 * - leave blank to disable server storage
434 * SUGGESTED: 'pma__userconfig'
436 * @global string $cfg['Servers'][$i]['userconfig']
438 $cfg['Servers'][$i]['userconfig'] = '';
441 * table to store users and their assignment to user groups
442 * - leave blank to disable configurable menus feature
443 * SUGGESTED: 'pma__users'
445 * @global string $cfg['Servers'][$i]['users']
447 $cfg['Servers'][$i]['users'] = '';
450 * table to store allowed menu items for each user group
451 * - leave blank to disable configurable menus feature
452 * SUGGESTED: 'pma__usergroups'
454 * @global string $cfg['Servers'][$i]['usergroups']
456 $cfg['Servers'][$i]['usergroups'] = '';
459 * table to store information about item hidden from navigation tree
460 * - leave blank to disable hide/show navigation items feature
461 * SUGGESTED: 'pma__navigationhiding'
463 * @global string $cfg['Servers'][$i]['navigationhiding']
465 $cfg['Servers'][$i]['navigationhiding'] = '';
468 * table to store information about saved searches from query-by-example on a db
469 * - leave blank to disable saved searches feature
470 * SUGGESTED: 'pma__savedsearches'
472 * @global string $cfg['Servers'][$i]['savedsearches']
474 $cfg['Servers'][$i]['savedsearches'] = '';
477 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
479 * In case where tables in databases is modified (e.g. dropped or renamed),
480 * table_uiprefs may contains invalid data (referring to tables which are not
482 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
483 * newest record in table_uiprefs and automatically delete older records.
485 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
487 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
490 * whether to allow root login
492 * @global boolean $cfg['Servers'][$i]['AllowRoot']
494 $cfg['Servers'][$i]['AllowRoot'] = true;
497 * whether to allow login of any user without a password
499 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
501 $cfg['Servers'][$i]['AllowNoPassword'] = false;
504 * Host authentication order, leave blank to not use
506 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
508 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
511 * Host authentication rules, leave blank for defaults
513 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
515 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
518 * Whether the tracking mechanism creates
519 * versions for tables and views automatically.
521 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
524 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
527 * Defines the list of statements
528 * the auto-creation uses for new versions.
530 * @global string $cfg['Servers'][$i]['tracking_default_statements']
533 $cfg['Servers'][$i]['tracking_default_statements']
534 = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
535 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
536 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
539 * Whether a DROP VIEW IF EXISTS statement will be added
540 * as first line to the log when creating a view.
542 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
545 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
548 * Whether a DROP TABLE IF EXISTS statement will be added
549 * as first line to the log when creating a table.
551 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
554 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
557 * Whether a DROP DATABASE IF EXISTS statement will be added
558 * as first line to the log when creating a database.
560 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
563 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
566 * Enables caching of TABLE STATUS outputs for specific databases on this server
567 * (in some cases TABLE STATUS can be very slow, so you may want to cache it).
568 * APC is used (if the PHP extension is available, if not, this setting is ignored
569 * silently). You have to provide StatusCacheLifetime.
571 * @global array $cfg['Servers'][$i]['StatusCacheDatabases']
573 $cfg['Servers'][$i]['StatusCacheDatabases'] = array();
576 * Lifetime in seconds of the TABLE STATUS cache if StatusCacheDatabases is used
578 * @global integer $cfg['Servers'][$i]['StatusCacheLifetime']
580 $cfg['Servers'][$i]['StatusCacheLifetime'] = 0;
583 * Default server (0 = no default server)
585 * If you have more than one server configured, you can set $cfg['ServerDefault']
586 * to any one of them to auto-connect to that server when phpMyAdmin is started,
587 * or set it to 0 to be given a list of servers without logging in
588 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
589 * set to that server.
591 * @global integer $cfg['ServerDefault']
593 $cfg['ServerDefault'] = 1;
596 * Other core phpMyAdmin settings
600 * whether version check is active
602 * @global boolean $cfg['VersionCheck']
604 if (defined('VERSION_CHECK_DEFAULT')) {
605 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT
;
607 $cfg['VersionCheck'] = true;
611 * The url of the proxy to be used when retrieving the information about
612 * the latest version of phpMyAdmin or error reporting. You need this if
613 * the server where phpMyAdmin is installed does not have direct access to
615 * The format is: "hostname:portnumber"
617 * @global string $cfg['ProxyUrl']
619 $cfg['ProxyUrl'] = "";
622 * The username for authenticating with the proxy. By default, no
623 * authentication is performed. If a username is supplied, Basic
624 * Authentication will be performed. No other types of authentication
625 * are currently supported.
627 * @global string $cfg['ProxyUser']
629 $cfg['ProxyUser'] = "";
632 * The password for authenticating with the proxy.
634 * @global string $cfg['ProxyPass']
636 $cfg['ProxyPass'] = "";
639 * maximum number of db's displayed in database list
641 * @global integer $cfg['MaxDbList']
643 $cfg['MaxDbList'] = 100;
646 * maximum number of tables displayed in table list
648 * @global integer $cfg['MaxTableList']
650 $cfg['MaxTableList'] = 250;
653 * whether to show hint or not
655 * @global boolean $cfg['ShowHint']
657 $cfg['ShowHint'] = true;
660 * maximum number of characters when a SQL query is displayed
662 * @global integer $cfg['MaxCharactersInDisplayedSQL']
664 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
667 * use GZIP output buffering if possible (true|false|'auto')
669 * @global string $cfg['OBGzip']
671 $cfg['OBGzip'] = 'auto';
674 * use persistent connections to MySQL database
676 * @global boolean $cfg['PersistentConnections']
678 $cfg['PersistentConnections'] = false;
681 * whether to force using HTTPS
683 * @global boolean $cfg['ForceSSL']
685 $cfg['ForceSSL'] = false;
688 * maximum execution time in seconds (0 for no limit)
690 * @global integer $cfg['ExecTimeLimit']
692 $cfg['ExecTimeLimit'] = 300;
695 * Path for storing session data (session_save_path PHP parameter).
697 * @global integer $cfg['SessionSavePath']
699 $cfg['SessionSavePath'] = '';
702 * maximum allocated bytes ('-1' for no limit)
703 * this is a string because '16M' is a valid value; we must put here
704 * a string as the default value so that /setup accepts strings
706 * @global string $cfg['MemoryLimit']
708 $cfg['MemoryLimit'] = '-1';
711 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
712 * Is ignored for Drizzle.
714 * @global boolean $cfg['SkipLockedTables']
716 $cfg['SkipLockedTables'] = false;
719 * show SQL queries as run
721 * @global boolean $cfg['ShowSQL']
723 $cfg['ShowSQL'] = true;
726 * retain SQL input on Ajax execute
728 * @global boolean $cfg['RetainQueryEditor']
730 $cfg['RetainQueryBox'] = false;
733 * use CodeMirror syntax highlighting for editing SQL
735 * @global boolean $cfg['CodemirrorEnable']
737 $cfg['CodemirrorEnable'] = true;
740 * show a 'Drop database' link to normal users
742 * @global boolean $cfg['AllowUserDropDatabase']
744 $cfg['AllowUserDropDatabase'] = false;
747 * confirm some commands that can result in loss of data
749 * @global boolean $cfg['Confirm']
751 $cfg['Confirm'] = true;
754 * recall previous login in cookie authentication mode or not
756 * @global boolean $cfg['LoginCookieRecall']
758 $cfg['LoginCookieRecall'] = true;
761 * validity of cookie login (in seconds; 1440 matches php.ini's
762 * session.gc_maxlifetime)
764 * @global integer $cfg['LoginCookieValidity']
766 $cfg['LoginCookieValidity'] = 1440;
769 * how long login cookie should be stored (in seconds)
771 * @global integer $cfg['LoginCookieStore']
773 $cfg['LoginCookieStore'] = 0;
776 * whether to delete all login cookies on logout
778 * @global boolean $cfg['LoginCookieDeleteAll']
780 $cfg['LoginCookieDeleteAll'] = true;
783 * whether to enable the "database search" feature or not
785 * @global boolean $cfg['UseDbSearch']
787 $cfg['UseDbSearch'] = true;
790 * if set to true, PMA continues computing multiple-statement queries
791 * even if one of the queries failed
793 * @global boolean $cfg['IgnoreMultiSubmitErrors']
795 $cfg['IgnoreMultiSubmitErrors'] = false;
798 * allow login to any user entered server in cookie based authentication
800 * @global boolean $cfg['AllowArbitraryServer']
802 $cfg['AllowArbitraryServer'] = false;
805 * if reCaptcha is enabled it needs public key to connect with the service
807 * @global string $cfg['CaptchaLoginPublicKey']
809 $cfg['CaptchaLoginPublicKey'] = '';
812 * if reCaptcha is enabled it needs private key to connect with the service
814 * @global string $cfg['CaptchaLoginPrivateKey']
816 $cfg['CaptchaLoginPrivateKey'] = '';
818 /*******************************************************************************
819 * Error handler configuration
821 * this configures phpMyAdmin's own error handler, it is used to avoid information
822 * disclosure, gather errors for logging, reporting and displaying
824 * @global array $cfg['Error_Handler']
826 $cfg['Error_Handler'] = array();
829 * whether to display errors or not
831 * this does not affect errors of type E_USER_*
833 * @global boolean $cfg['Error_Handler']['display']
835 $cfg['Error_Handler']['display'] = false;
838 /*******************************************************************************
839 * Navigation panel setup
843 * maximum number of first level databases displayed in navigation panel
845 * @global integer $cfg['FirstLevelNavigationItems']
847 $cfg['FirstLevelNavigationItems'] = 250;
850 * maximum number of items displayed in navigation panel
852 * @global integer $cfg['MaxNavigationItems']
854 $cfg['MaxNavigationItems'] = 50;
857 * turn the select-based light menu into a tree
859 * @global boolean $cfg['NavigationTreeEnableGrouping']
861 $cfg['NavigationTreeEnableGrouping'] = true;
864 * the separator to sub-tree the select-based light menu tree
866 * @global string $cfg['NavigationTreeDbSeparator']
868 $cfg['NavigationTreeDbSeparator'] = '_';
871 * Which string will be used to generate table prefixes
872 * to split/nest tables into multiple categories
874 * @global string $cfg['NavigationTreeTableSeparator']
876 $cfg['NavigationTreeTableSeparator'] = '__';
879 * How many sublevels should be displayed when splitting up tables
880 * by the above Separator
882 * @global integer $cfg['NavigationTreeTableLevel']
884 $cfg['NavigationTreeTableLevel'] = 1;
887 * display logo at top of navigation panel
889 * @global boolean $cfg['NavigationDisplayLogo']
891 $cfg['NavigationDisplayLogo'] = true;
894 * where should logo link point to (can also contain an external URL)
896 * @global string $cfg['NavigationLogoLink']
898 $cfg['NavigationLogoLink'] = 'index.php';
901 * whether to open the linked page in the main window ('main') or
902 * in a new window ('new')
904 * @global string $cfg['NavigationLogoLinkWindow']
906 $cfg['NavigationLogoLinkWindow'] = 'main';
909 * number of recently used tables displayed in the navigation panel
911 * @global integer $cfg['NumRecentTables']
913 $cfg['NumRecentTables'] = 10;
916 * number of favorite tables displayed in the navigation panel
918 * @global integer $cfg['NumFavoriteTables']
920 $cfg['NumFavoriteTables'] = 10;
923 * display a JavaScript table filter in the navigation panel
924 * when more then x tables are present
926 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
928 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
931 * display server choice at top of navigation panel
933 * @global boolean $cfg['NavigationDisplayServers']
935 $cfg['NavigationDisplayServers'] = true;
938 * server choice as links
940 * @global boolean $cfg['DisplayServersList']
942 $cfg['DisplayServersList'] = false;
945 * display a JavaScript database filter in the navigation panel
946 * when more then x databases are present
948 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
950 $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
953 * target of the navigation panel quick access icon
956 * 'tbl_structure.php' = fields list
957 * 'tbl_sql.php' = SQL form
958 * 'tbl_select.php' = search page
959 * 'tbl_change.php' = insert row page
960 * 'sql.php' = browse page
962 * @global string $cfg['NavigationTreeDefaultTabTable']
964 $cfg['NavigationTreeDefaultTabTable'] = 'tbl_structure.php';
967 * Disables the possibility of database expansion
969 * @global boolean $cfg['DisableDatabaseExpansion']
971 $cfg['NavigationTreeDisableDatabaseExpansion'] = false;
973 /*******************************************************************************
974 * In the main panel, at startup...
978 * allow to display statistics and space usage in the pages about database
979 * details and table properties
981 * @global boolean $cfg['ShowStats']
983 $cfg['ShowStats'] = true;
988 * @global boolean $cfg['ShowPhpInfo']
990 $cfg['ShowPhpInfo'] = false;
993 * show MySQL server and web server information
995 * @global boolean $cfg['ShowServerInfo']
997 $cfg['ShowServerInfo'] = true;
1000 * show change password link
1002 * @global boolean $cfg['ShowChgPassword']
1004 $cfg['ShowChgPassword'] = true;
1007 * show create database form
1009 * @global boolean $cfg['ShowCreateDb']
1011 $cfg['ShowCreateDb'] = true;
1014 /*******************************************************************************
1015 * Database structure
1019 * show creation timestamp column in database structure (true|false)?
1021 * @global boolean $cfg['ShowDbStructureCreation']
1023 $cfg['ShowDbStructureCreation'] = false;
1026 * show last update timestamp column in database structure (true|false)?
1028 * @global boolean $cfg['ShowDbStructureLastUpdate']
1030 $cfg['ShowDbStructureLastUpdate'] = false;
1033 * show last check timestamp column in database structure (true|false)?
1035 * @global boolean $cfg['ShowDbStructureLastCheck']
1037 $cfg['ShowDbStructureLastCheck'] = false;
1040 * allow hide action columns to drop down menu in database structure (true|false)?
1042 * @global boolean $cfg['HideStructureActions']
1044 $cfg['HideStructureActions'] = true;
1047 /*******************************************************************************
1052 * Use icons instead of text for the navigation bar buttons (table browse)
1053 * ('text'|'icons'|'both')
1055 * @global string $cfg['TableNavigationLinksMode']
1057 $cfg['TableNavigationLinksMode'] = 'icons';
1060 * Defines whether a user should be displayed a "show all (records)"
1061 * button in browse mode or not.
1063 * @global boolean $cfg['ShowAll']
1065 $cfg['ShowAll'] = false;
1068 * Number of rows displayed when browsing a result set. If the result
1069 * set contains more rows, "Previous" and "Next".
1070 * Possible values: 25,50,100,250,500
1072 * @global integer $cfg['MaxRows']
1074 $cfg['MaxRows'] = 25;
1077 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1078 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1079 * ascending order else-)
1081 * @global string $cfg['Order']
1083 $cfg['Order'] = 'SMART';
1086 * default for 'Show binary contents as HEX'
1088 * @global string $cfg['DisplayBinaryAsHex']
1090 $cfg['DisplayBinaryAsHex'] = true;
1093 * grid editing: save edited cell(s) in browse-mode at once
1095 * @global boolean $cfg['SaveCellsAtOnce']
1098 $cfg['SaveCellsAtOnce'] = false;
1101 * grid editing: which action triggers it, or completely disable the feature
1108 * @global string $cfg['GridEditing']
1110 $cfg['GridEditing'] ='double-click';
1113 /*******************************************************************************
1118 * disallow editing of binary fields
1120 * false allow editing
1121 * 'blob' allow editing except for BLOB fields
1122 * 'noblob' disallow editing except for BLOB fields
1123 * 'all' disallow editing
1125 * @global string $cfg['ProtectBinary']
1127 $cfg['ProtectBinary'] = 'blob';
1130 * Display the function fields in edit/insert mode
1132 * @global boolean $cfg['ShowFunctionFields']
1134 $cfg['ShowFunctionFields'] = true;
1137 * Display the type fields in edit/insert mode
1139 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1141 $cfg['ShowFieldTypesInDataEditView'] = true;
1144 * Which editor should be used for CHAR/VARCHAR fields:
1145 * input - allows limiting of input length
1146 * textarea - allows newlines in fields
1148 * @global string $cfg['CharEditing']
1150 $cfg['CharEditing'] = 'input';
1153 * The minimum size for character input fields
1155 * @global integer $cfg['MinSizeForInputField']
1157 $cfg['MinSizeForInputField'] = 4;
1160 * The maximum size for character input fields
1162 * @global integer $cfg['MinSizeForInputField']
1164 $cfg['MaxSizeForInputField'] = 60;
1167 * How many rows can be inserted at one time
1169 * @global integer $cfg['InsertRows']
1171 $cfg['InsertRows'] = 2;
1174 * Sort order for items in a foreign-key drop-down list.
1175 * 'content' is the referenced data, 'id' is the key value.
1177 * @global array $cfg['ForeignKeyDropdownOrder']
1179 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
1182 * A drop-down list will be used if fewer items are present
1184 * @global integer $cfg['ForeignKeyMaxLimit']
1186 $cfg['ForeignKeyMaxLimit'] = 100;
1189 /*******************************************************************************
1190 * For the export features...
1194 * Allow for the use of zip compression (requires zip support to be enabled)
1196 * @global boolean $cfg['ZipDump']
1198 $cfg['ZipDump'] = true;
1201 * Allow for the use of gzip compression (requires zlib)
1203 * @global boolean $cfg['GZipDump']
1205 $cfg['GZipDump'] = true;
1208 * Allow for the use of bzip2 decompression (requires bz2 extension)
1210 * @global boolean $cfg['BZipDump']
1212 $cfg['BZipDump'] = true;
1215 * Will compress gzip exports on the fly without the need for much memory.
1216 * If you encounter problems with created gzip files disable this feature.
1218 * @global boolean $cfg['CompressOnFly']
1220 $cfg['CompressOnFly'] = true;
1223 /*******************************************************************************
1224 * Tabs display settings
1228 * How to display the menu tabs ('icons'|'text'|'both')
1230 * @global boolean $cfg['TabsMode']
1232 $cfg['TabsMode'] = 'both';
1235 * How to display various action links ('icons'|'text'|'both')
1237 * @global boolean $cfg['ActionLinksMode']
1239 $cfg['ActionLinksMode'] = 'both';
1242 * How many columns should be used for table display of a database?
1243 * (a value larger than 1 results in some information being hidden)
1245 * @global integer $cfg['PropertiesNumColumns']
1247 $cfg['PropertiesNumColumns'] = 1;
1251 * 'index.php' = the welcome page
1252 * (recommended for multiuser setups)
1253 * 'server_databases.php' = list of databases
1254 * 'server_status.php' = runtime information
1255 * 'server_variables.php' = MySQL server variables
1256 * 'server_privileges.php' = user management
1258 * @global string $cfg['DefaultTabServer']
1260 $cfg['DefaultTabServer'] = 'index.php';
1264 * 'db_structure.php' = tables list
1265 * 'db_sql.php' = SQL form
1266 * 'db_search.php' = search query
1267 * 'db_operations.php' = operations on database
1269 * @global string $cfg['DefaultTabDatabase']
1271 $cfg['DefaultTabDatabase'] = 'db_structure.php';
1275 * 'tbl_structure.php' = fields list
1276 * 'tbl_sql.php' = SQL form
1277 * 'tbl_select.php' = search page
1278 * 'tbl_change.php' = insert row page
1279 * 'sql.php' = browse page
1281 * @global string $cfg['DefaultTabTable']
1283 $cfg['DefaultTabTable'] = 'sql.php';
1286 * Whether to display image or text or both image and text in table row
1287 * action segment. Value can be either of ``image``, ``text`` or ``both``.
1289 $cfg['RowActionType'] = 'both';
1291 /*******************************************************************************
1294 $cfg['Export'] = array();
1297 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xls/xml/yaml
1299 * @global string $cfg['Export']['format']
1301 $cfg['Export']['format'] = 'sql';
1304 * quick/custom/custom-no-form
1306 * @global string $cfg['Export']['format']
1308 $cfg['Export']['method'] = 'quick';
1313 * @global string $cfg['Export']['compression']
1315 $cfg['Export']['compression'] = 'none';
1320 * @global boolean $cfg['Export']['asfile']
1322 $cfg['Export']['asfile'] = true;
1327 * @global string $cfg['Export']['charset']
1329 $cfg['Export']['charset'] = '';
1334 * @global boolean $cfg['Export']['onserver']
1336 $cfg['Export']['onserver'] = false;
1341 * @global boolean $cfg['Export']['onserver_overwrite']
1343 $cfg['Export']['onserver_overwrite'] = false;
1348 * @global boolean $cfg['Export']['quick_export_onserver']
1350 $cfg['Export']['quick_export_onserver'] = false;
1355 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1357 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1362 * @global boolean $cfg['Export']['remember_file_template']
1364 $cfg['Export']['remember_file_template'] = true;
1369 * @global string $cfg['Export']['file_template_table']
1371 $cfg['Export']['file_template_table'] = '@TABLE@';
1376 * @global string $cfg['Export']['file_template_database']
1378 $cfg['Export']['file_template_database'] = '@DATABASE@';
1383 * @global string $cfg['Export']['file_template_server']
1385 $cfg['Export']['file_template_server'] = '@SERVER@';
1390 * @global string $cfg['Export']['codegen_structure_or_data']
1392 $cfg['Export']['codegen_structure_or_data'] = 'data';
1397 * @global $cfg['Export']['codegen_format']
1399 $cfg['Export']['codegen_format'] = 0;
1404 * @global boolean $cfg['Export']['ods_columns']
1406 $cfg['Export']['ods_columns'] = false;
1411 * @global string $cfg['Export']['ods_null']
1413 $cfg['Export']['ods_null'] = 'NULL';
1418 * @global string $cfg['Export']['odt_structure_or_data']
1420 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1425 * @global boolean $cfg['Export']['odt_columns']
1427 $cfg['Export']['odt_columns'] = true;
1432 * @global boolean $cfg['Export']['odt_relation']
1434 $cfg['Export']['odt_relation'] = true;
1439 * @global boolean $cfg['Export']['odt_comments']
1441 $cfg['Export']['odt_comments'] = true;
1446 * @global boolean $cfg['Export']['odt_mime']
1448 $cfg['Export']['odt_mime'] = true;
1453 * @global string $cfg['Export']['odt_null']
1455 $cfg['Export']['odt_null'] = 'NULL';
1460 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1462 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1467 * @global boolean $cfg['Export']['htmlword_columns']
1469 $cfg['Export']['htmlword_columns'] = false;
1474 * @global string $cfg['Export']['htmlword_null']
1476 $cfg['Export']['htmlword_null'] = 'NULL';
1481 * @global string $cfg['Export']['texytext_structure_or_data']
1483 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1488 * @global boolean $cfg['Export']['texytext_columns']
1490 $cfg['Export']['texytext_columns'] = false;
1495 * @global string $cfg['Export']['texytext_null']
1497 $cfg['Export']['texytext_null'] = 'NULL';
1502 * @global boolean $cfg['Export']['xls_columns']
1504 $cfg['Export']['xls_columns'] = false;
1509 * @global string $cfg['Export']['xls_structure_or_data']
1511 $cfg['Export']['xls_structure_or_data'] = 'data';
1516 * @global string $cfg['Export']['xls_null']
1518 $cfg['Export']['xls_null'] = 'NULL';
1523 * @global boolean $cfg['Export']['xlsx_columns']
1525 $cfg['Export']['xlsx_columns'] = false;
1530 * @global string $cfg['Export']['xlsx_structure_or_data']
1532 $cfg['Export']['xlsx_structure_or_data'] = 'data';
1537 * @global string $cfg['Export']['xlsx_null']
1539 $cfg['Export']['xlsx_null'] = 'NULL';
1544 * @global boolean $cfg['Export']['csv_columns']
1546 $cfg['Export']['csv_columns'] = false;
1551 * @global string $cfg['Export']['csv_structure_or_data']
1553 $cfg['Export']['csv_structure_or_data'] = 'data';
1558 * @global string $cfg['Export']['csv_null']
1560 $cfg['Export']['csv_null'] = 'NULL';
1565 * @global string $cfg['Export']['csv_separator']
1567 $cfg['Export']['csv_separator'] = ',';
1572 * @global string $cfg['Export']['csv_enclosed']
1574 $cfg['Export']['csv_enclosed'] = '"';
1579 * @global string $cfg['Export']['csv_escaped']
1581 $cfg['Export']['csv_escaped'] = '"';
1586 * @global string $cfg['Export']['csv_terminated']
1588 $cfg['Export']['csv_terminated'] = 'AUTO';
1593 * @global string $cfg['Export']['csv_removeCRLF']
1595 $cfg['Export']['csv_removeCRLF'] = false;
1600 * @global boolean $cfg['Export']['excel_columns']
1602 $cfg['Export']['excel_columns'] = false;
1607 * @global string $cfg['Export']['excel_null']
1609 $cfg['Export']['excel_null'] = 'NULL';
1614 * @global string $cfg['Export']['excel_edition']
1616 $cfg['Export']['excel_edition'] = 'win';
1621 * @global string $cfg['Export']['excel_removeCRLF']
1623 $cfg['Export']['excel_removeCRLF'] = false;
1628 * @global string $cfg['Export']['excel_structure_or_data']
1630 $cfg['Export']['excel_structure_or_data'] = 'data';
1635 * @global string $cfg['Export']['latex_structure_or_data']
1637 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1642 * @global boolean $cfg['Export']['latex_columns']
1644 $cfg['Export']['latex_columns'] = true;
1649 * @global boolean $cfg['Export']['latex_relation']
1651 $cfg['Export']['latex_relation'] = true;
1656 * @global boolean $cfg['Export']['latex_comments']
1658 $cfg['Export']['latex_comments'] = true;
1663 * @global boolean $cfg['Export']['latex_mime']
1665 $cfg['Export']['latex_mime'] = true;
1670 * @global string $cfg['Export']['latex_null']
1672 $cfg['Export']['latex_null'] = '\textit{NULL}';
1677 * @global boolean $cfg['Export']['latex_caption']
1679 $cfg['Export']['latex_caption'] = true;
1684 * @global string $cfg['Export']['latex_structure_caption']
1686 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1691 * @global string $cfg['Export']['latex_structure_continued_caption']
1693 $cfg['Export']['latex_structure_continued_caption']
1694 = 'strLatexStructure strLatexContinued';
1699 * @global string $cfg['Export']['latex_data_caption']
1701 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1706 * @global string $cfg['Export']['latex_data_continued_caption']
1708 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1713 * @global string $cfg['Export']['latex_data_label']
1715 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1720 * @global string $cfg['Export']['latex_structure_label']
1722 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1727 * @global string $cfg['Export']['mediawiki_structure_or_data']
1729 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1734 * @global boolean $cfg['Export']['mediawiki_caption']
1737 $cfg['Export']['mediawiki_caption'] = true;
1741 * @global boolean $cfg['Export']['mediawiki_headers']
1743 $cfg['Export']['mediawiki_headers'] = true;
1748 * @global string $cfg['Export']['ods_structure_or_data']
1750 $cfg['Export']['ods_structure_or_data'] = 'data';
1755 * @global string $cfg['Export']['pdf_structure_or_data']
1757 $cfg['Export']['pdf_structure_or_data'] = 'data';
1762 * @global string $cfg['Export']['phparray_structure_or_data']
1764 $cfg['Export']['phparray_structure_or_data'] = 'data';
1769 * @global string $cfg['Export']['json_structure_or_data']
1771 $cfg['Export']['json_structure_or_data'] = 'data';
1776 * @global string $cfg['Export']['sql_structure_or_data']
1778 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1783 * @global string $cfg['Export']['sql_compatibility']
1785 $cfg['Export']['sql_compatibility'] = 'NONE';
1788 * Whether to include comments in SQL export.
1790 * @global string $cfg['Export']['sql_include_comments']
1792 $cfg['Export']['sql_include_comments'] = true;
1797 * @global boolean $cfg['Export']['sql_disable_fk']
1799 $cfg['Export']['sql_disable_fk'] = false;
1803 * @global boolean $cfg['Export']['sql_views_as_tables']
1805 $cfg['Export']['sql_views_as_tables'] = false;
1810 * @global boolean $cfg['Export']['sql_use_transaction']
1812 $cfg['Export']['sql_use_transaction'] = false;
1817 * @global boolean $cfg['Export']['sql_create_database']
1819 $cfg['Export']['sql_create_database'] = false;
1824 * @global boolean $cfg['Export']['sql_drop_database']
1826 $cfg['Export']['sql_drop_database'] = false;
1831 * @global boolean $cfg['Export']['sql_drop_table']
1833 $cfg['Export']['sql_drop_table'] = false;
1838 * true by default for correct behavior when dealing with exporting
1839 * of VIEWs and the stand-in table
1840 * @global boolean $cfg['Export']['sql_if_not_exists']
1842 $cfg['Export']['sql_if_not_exists'] = true;
1847 * @global boolean $cfg['Export']['sql_procedure_function']
1849 $cfg['Export']['sql_procedure_function'] = true;
1854 * @global boolean $cfg['Export']['sql_create_table']
1856 $cfg['Export']['sql_create_table'] = true;
1861 * @global boolean $cfg['Export']['sql_create_view']
1863 $cfg['Export']['sql_create_view'] = true;
1868 * @global boolean $cfg['Export']['sql_create_trigger']
1870 $cfg['Export']['sql_create_trigger'] = true;
1875 * @global boolean $cfg['Export']['sql_auto_increment']
1877 $cfg['Export']['sql_auto_increment'] = true;
1882 * @global boolean $cfg['Export']['sql_backquotes']
1884 $cfg['Export']['sql_backquotes'] = true;
1889 * @global boolean $cfg['Export']['sql_dates']
1891 $cfg['Export']['sql_dates'] = false;
1896 * @global boolean $cfg['Export']['sql_relation']
1898 $cfg['Export']['sql_relation'] = false;
1903 * @global boolean $cfg['Export']['sql_truncate']
1905 $cfg['Export']['sql_truncate'] = false;
1910 * @global boolean $cfg['Export']['sql_delayed']
1912 $cfg['Export']['sql_delayed'] = false;
1917 * @global boolean $cfg['Export']['sql_ignore']
1919 $cfg['Export']['sql_ignore'] = false;
1922 * Export time in UTC.
1924 * @global boolean $cfg['Export']['sql_utc_time']
1926 $cfg['Export']['sql_utc_time'] = true;
1931 * @global boolean $cfg['Export']['sql_hex_for_binary']
1933 $cfg['Export']['sql_hex_for_binary'] = true;
1936 * insert/update/replace
1938 * @global string $cfg['Export']['sql_type']
1940 $cfg['Export']['sql_type'] = 'INSERT';
1945 * @global integer $cfg['Export']['sql_max_query_size']
1947 $cfg['Export']['sql_max_query_size'] = 50000;
1952 * @global boolean $cfg['Export']['sql_mime']
1954 $cfg['Export']['sql_mime'] = false;
1957 * \n is replaced by new line
1959 * @global string $cfg['Export']['sql_header_comment']
1961 $cfg['Export']['sql_header_comment'] = '';
1966 * @global boolean $cfg['Export']['sql_create_table_statements']
1968 $cfg['Export']['sql_create_table_statements'] = true;
1971 * Whether to use complete inserts, extended inserts, both, or neither
1973 * @global string $cfg['Export']['sql_insert_syntax']
1975 $cfg['Export']['sql_insert_syntax'] = 'both';
1980 * @global string $cfg['Export']['pdf_report_title']
1982 $cfg['Export']['pdf_report_title'] = '';
1987 *@global string $cfg['Export']['xml_structure_or_data']
1989 $cfg['Export']['xml_structure_or_data'] = 'data';
1992 * Export schema for each structure
1994 * @global string $cfg['Export']['xml_export_struc']
1996 $cfg['Export']['xml_export_struc'] = true;
2001 * @global string $cfg['Export']['xml_export_functions']
2003 $cfg['Export']['xml_export_functions'] = true;
2008 * @global string $cfg['Export']['xml_export_procedures']
2010 $cfg['Export']['xml_export_procedures'] = true;
2013 * Export schema for each table
2015 * @global string $cfg['Export']['xml_export_tables']
2017 $cfg['Export']['xml_export_tables'] = true;
2022 * @global string $cfg['Export']['xml_export_triggers']
2024 $cfg['Export']['xml_export_triggers'] = true;
2029 * @global string $cfg['Export']['xml_export_views']
2031 $cfg['Export']['xml_export_views'] = true;
2034 * Export contents data
2036 * @global string $cfg['Export']['xml_export_contents']
2038 $cfg['Export']['xml_export_contents'] = true;
2043 * @global string $cfg['Export']['yaml_structure_or_data']
2045 $cfg['Export']['yaml_structure_or_data'] = 'data';
2047 /*******************************************************************************
2050 $cfg['Import'] = array();
2055 * @global string $cfg['Import']['format']
2057 $cfg['Import']['format'] = 'sql';
2060 * Default charset for import.
2062 * @global string $cfg['Import']['charset']
2064 $cfg['Import']['charset'] = '';
2069 * @global boolean $cfg['Import']['allow_interrupt']
2071 $cfg['Import']['allow_interrupt'] = true;
2076 * @global integer $cfg['Import']['skip_queries']
2078 $cfg['Import']['skip_queries'] = 0;
2083 * @global string $cfg['Import']['sql_compatibility']
2085 $cfg['Import']['sql_compatibility'] = 'NONE';
2090 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
2092 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
2097 * @global boolean $cfg['Import']['csv_replace']
2099 $cfg['Import']['csv_replace'] = false;
2104 * @global boolean $cfg['Import']['csv_ignore']
2106 $cfg['Import']['csv_ignore'] = false;
2111 * @global string $cfg['Import']['csv_terminated']
2113 $cfg['Import']['csv_terminated'] = ',';
2118 * @global string $cfg['Import']['csv_enclosed']
2120 $cfg['Import']['csv_enclosed'] = '"';
2125 * @global string $cfg['Import']['csv_escaped']
2127 $cfg['Import']['csv_escaped'] = '"';
2132 * @global string $cfg['Import']['csv_new_line']
2134 $cfg['Import']['csv_new_line'] = 'auto';
2139 * @global string $cfg['Import']['csv_columns']
2141 $cfg['Import']['csv_columns'] = '';
2146 * @global string $cfg['Import']['csv_col_names']
2148 $cfg['Import']['csv_col_names'] = false;
2153 * @global boolean $cfg['Import']['ldi_replace']
2155 $cfg['Import']['ldi_replace'] = false;
2160 * @global boolean $cfg['Import']['ldi_ignore']
2162 $cfg['Import']['ldi_ignore'] = false;
2167 * @global string $cfg['Import']['ldi_terminated']
2169 $cfg['Import']['ldi_terminated'] = ';';
2174 * @global string $cfg['Import']['ldi_enclosed']
2176 $cfg['Import']['ldi_enclosed'] = '"';
2181 * @global string $cfg['Import']['ldi_escaped']
2183 $cfg['Import']['ldi_escaped'] = '\\';
2188 * @global string $cfg['Import']['ldi_new_line']
2190 $cfg['Import']['ldi_new_line'] = 'auto';
2195 * @global string $cfg['Import']['ldi_columns']
2197 $cfg['Import']['ldi_columns'] = '';
2200 * 'auto' for auto-detection, true or false for forcing
2202 * @global string $cfg['Import']['ldi_local_option']
2204 $cfg['Import']['ldi_local_option'] = 'auto';
2209 * @global string $cfg['Import']['ods_col_names']
2211 $cfg['Import']['ods_col_names'] = false;
2216 * @global string $cfg['Import']['ods_empty_rows']
2218 $cfg['Import']['ods_empty_rows'] = true;
2223 * @global string $cfg['Import']['ods_recognize_percentages']
2225 $cfg['Import']['ods_recognize_percentages'] = true;
2230 * @global string $cfg['Import']['ods_recognize_currency']
2232 $cfg['Import']['ods_recognize_currency'] = true;
2237 * @global string $cfg['Import']['xml_col_names']
2239 $cfg['Import']['xls_col_names'] = false;
2244 * @global string $cfg['Import']['xml_empty_rows']
2246 $cfg['Import']['xls_empty_rows'] = true;
2251 * @global string $cfg['Import']['xlsx_col_names']
2253 $cfg['Import']['xlsx_col_names'] = false;
2255 /*******************************************************************************
2262 * @global array $cfg['PDFPageSizes']
2264 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
2269 * @global string $cfg['PDFDefaultPageSize']
2271 $cfg['PDFDefaultPageSize'] = 'A4';
2274 /*******************************************************************************
2275 * Language and character set conversion settings
2279 * Default language to use, if not browser-defined or user-defined
2281 * @global string $cfg['DefaultLang']
2283 $cfg['DefaultLang'] = 'en';
2286 * Default connection collation
2288 * @global string $cfg['DefaultConnectionCollation']
2290 $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
2293 * Force: always use this language
2294 * $cfg['Lang'] = 'en';
2296 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2299 * @global string $cfg['FilterLanguages']
2301 $cfg['FilterLanguages'] = '';
2304 * You can select here which functions will be used for character set conversion.
2305 * Possible values are:
2306 * auto - automatically use available one (first is tested iconv, then
2308 * iconv - use iconv or libiconv functions
2309 * recode - use recode_string function
2310 * mb - use mbstring extension
2311 * none - disable encoding conversion
2313 * @global string $cfg['RecodingEngine']
2315 $cfg['RecodingEngine'] = 'auto';
2318 * Specify some parameters for iconv used in character set conversion. See iconv
2319 * documentation for details:
2320 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
2322 * @global string $cfg['IconvExtraParams']
2324 $cfg['IconvExtraParams'] = '//TRANSLIT';
2327 * Available character sets for MySQL conversion. currently contains all which could
2328 * be found in lang/* files and few more.
2329 * Character sets will be shown in same order as here listed, so if you frequently
2330 * use some of these move them to the top.
2332 * @global array $cfg['AvailableCharsets']
2334 $cfg['AvailableCharsets'] = array(
2369 /*******************************************************************************
2370 * Customization & design
2372 * The graphical settings are now located in themes/theme-name/layout.inc.php
2376 * enable the left panel pointer
2377 * see also LeftPointerColor
2380 * @global boolean $cfg['NavigationTreePointerEnable']
2382 $cfg['NavigationTreePointerEnable'] = true;
2385 * enable the browse pointer
2386 * see also BrowsePointerColor
2389 * @global boolean $cfg['BrowsePointerEnable']
2391 $cfg['BrowsePointerEnable'] = true;
2394 * enable the browse marker
2395 * see also BrowseMarkerColor
2398 * @global boolean $cfg['BrowseMarkerEnable']
2400 $cfg['BrowseMarkerEnable'] = true;
2403 * textarea size (columns) in edit mode
2404 * (this value will be emphasized (*2) for SQL
2405 * query textareas and (*1.25) for query window)
2407 * @global integer $cfg['TextareaCols']
2409 $cfg['TextareaCols'] = 40;
2412 * textarea size (rows) in edit mode
2414 * @global integer $cfg['TextareaRows']
2416 $cfg['TextareaRows'] = 15;
2419 * double size of textarea size for LONGTEXT columns
2421 * @global boolean $cfg['LongtextDoubleTextarea']
2423 $cfg['LongtextDoubleTextarea'] = true;
2426 * auto-select when clicking in the textarea of the query-box
2428 * @global boolean $cfg['TextareaAutoSelect']
2430 $cfg['TextareaAutoSelect'] = false;
2433 * textarea size (columns) for CHAR/VARCHAR
2435 * @global integer $cfg['CharTextareaCols']
2437 $cfg['CharTextareaCols'] = 40;
2440 * textarea size (rows) for CHAR/VARCHAR
2442 * @global integer $cfg['CharTextareaRows']
2444 $cfg['CharTextareaRows'] = 2;
2447 * Max field data length in browse mode for all non-numeric fields
2449 * @global integer $cfg['LimitChars']
2451 $cfg['LimitChars'] = 50;
2454 * Where to show the edit/copy/delete links in browse mode
2455 * Possible values are 'left', 'right', 'both' and 'none';
2456 * which will be interpreted as 'top', 'bottom', 'both' and 'none'
2457 * respectively for vertical display mode
2459 * @global string $cfg['RowActionLinks']
2461 $cfg['RowActionLinks'] = 'left';
2464 * default display direction (horizontal|vertical|horizontalflipped)
2466 * @global string $cfg['DefaultDisplay']
2468 $cfg['DefaultDisplay'] = 'horizontal';
2471 * remember the last way a table sorted
2473 * @global string $cfg['RememberSorting']
2475 $cfg['RememberSorting'] = true;
2478 * table-header rotation via faking or CSS? (css|fake|auto)
2479 * NOTE: CSS only works in IE browsers!
2481 * @global string $cfg['HeaderFlipType']
2483 $cfg['HeaderFlipType'] = 'auto';
2486 * shows stored relation-comments in 'browse' mode.
2488 * @global boolean $cfg['ShowBrowseComments']
2490 $cfg['ShowBrowseComments'] = true;
2493 * shows stored relation-comments in 'table property' mode.
2495 * @global boolean $cfg['ShowPropertyComments']
2497 $cfg['ShowPropertyComments']= true;
2500 * shows table display direction.
2502 $cfg['ShowDisplayDirection'] = false;
2505 * repeat header names every X cells? (0 = deactivate)
2507 * @global integer $cfg['RepeatCells']
2509 $cfg['RepeatCells'] = 100;
2512 * Set to true if Edit link should open the query to edit in the query window
2513 * and to false if we should edit in the right panel
2515 * @global boolean $cfg['EditInWindow']
2517 $cfg['EditInWindow'] = true;
2520 * Width of Query window
2522 * @global integer $cfg['QueryWindowWidth']
2524 $cfg['QueryWindowWidth'] = 550;
2527 * Height of Query window
2529 * @global integer $cfg['QueryWindowHeight']
2531 $cfg['QueryWindowHeight'] = 310;
2534 * Set to true if you want DB-based query history.If false, this utilizes
2535 * JS-routines to display query history (lost by window close)
2537 * @global boolean $cfg['QueryHistoryDB']
2539 $cfg['QueryHistoryDB'] = false;
2542 * which tab to display in the querywindow on startup
2543 * (sql|files|history|full)
2545 * @global string $cfg['QueryWindowDefTab']
2547 $cfg['QueryWindowDefTab'] = 'sql';
2550 * When using DB-based query history, how many entries should be kept?
2552 * @global integer $cfg['QueryHistoryMax']
2554 $cfg['QueryHistoryMax'] = 25;
2557 * Use MIME-Types (stored in column comments table) for
2559 * @global boolean $cfg['BrowseMIME']
2561 $cfg['BrowseMIME'] = true;
2564 * When approximate count < this, PMA will get exact count for table rows.
2566 * @global integer $cfg['MaxExactCount']
2568 $cfg['MaxExactCount'] = 0;
2571 * Zero means that no row count is done for views; see the doc
2573 * @global integer $cfg['MaxExactCountViews']
2575 $cfg['MaxExactCountViews'] = 0;
2578 * Sort table and database in natural order
2580 * @global boolean $cfg['NaturalOrder']
2582 $cfg['NaturalOrder'] = true;
2585 * Initial state for sliders
2586 * (open | closed | disabled)
2588 * @global string $cfg['InitialSlidersState']
2590 $cfg['InitialSlidersState'] = 'closed';
2593 * User preferences: disallow these settings
2594 * For possible setting names look in libraries/config/user_preferences.forms.php
2596 * @global array $cfg['UserprefsDisallow']
2598 $cfg['UserprefsDisallow'] = array();
2601 * User preferences: enable the Developer tab
2603 $cfg['UserprefsDeveloperTab'] = false;
2605 /*******************************************************************************
2606 * Window title settings
2610 * title of browser window when a table is selected
2612 * @global string $cfg['TitleTable']
2614 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2617 * title of browser window when a database is selected
2619 * @global string $cfg['TitleDatabase']
2621 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2624 * title of browser window when a server is selected
2626 * @global string $cfg['TitleServer']
2628 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2631 * title of browser window when nothing is selected
2632 * @global string $cfg['TitleDefault']
2634 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2637 /*******************************************************************************
2642 * using themes manager please set up here the path to 'themes' else leave empty
2644 * @global string $cfg['ThemePath']
2646 $cfg['ThemePath'] = './themes';
2649 * if you want to use selectable themes and if ThemesPath not empty
2650 * set it to true, else set it to false (default is false);
2652 * @global boolean $cfg['ThemeManager']
2654 $cfg['ThemeManager'] = true;
2657 * set up default theme, if ThemePath not empty you can set up here an valid
2658 * path to themes or 'original' for the original pma-theme
2660 * @global string $cfg['ThemeDefault']
2662 $cfg['ThemeDefault'] = 'pmahomme';
2665 * allow different theme for each configured server
2667 * @global boolean $cfg['ThemePerServer']
2669 $cfg['ThemePerServer'] = false;
2672 /*******************************************************************************
2677 * Default query for table
2679 * @global string $cfg['DefaultQueryTable']
2681 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2684 * Default query for database
2686 * @global string $cfg['DefaultQueryDatabase']
2688 $cfg['DefaultQueryDatabase'] = '';
2691 /*******************************************************************************
2692 * SQL Query box settings
2693 * These are the links display in all of the SQL Query boxes
2695 * @global array $cfg['SQLQuery']
2697 $cfg['SQLQuery'] = array();
2700 * Edit link to change a query
2702 * @global boolean $cfg['SQLQuery']['Edit']
2704 $cfg['SQLQuery']['Edit'] = true;
2707 * EXPLAIN on SELECT queries
2709 * @global boolean $cfg['SQLQuery']['Explain']
2711 $cfg['SQLQuery']['Explain'] = true;
2714 * Wrap a query in PHP
2716 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2718 $cfg['SQLQuery']['ShowAsPHP'] = true;
2721 * Refresh the results page
2723 * @global boolean $cfg['SQLQuery']['Refresh']
2725 $cfg['SQLQuery']['Refresh'] = true;
2728 /*******************************************************************************
2729 * Web server upload/save/import directories
2733 * Directory for uploaded files that can be executed by phpMyAdmin.
2734 * For example './upload'. Leave empty for no upload directory support.
2735 * Use %u for username inclusion.
2737 * @global string $cfg['UploadDir']
2739 $cfg['UploadDir'] = '';
2742 * Directory where phpMyAdmin can save exported data on server.
2743 * For example './save'. Leave empty for no save directory support.
2744 * Use %u for username inclusion.
2746 * @global string $cfg['SaveDir']
2748 $cfg['SaveDir'] = '';
2751 * Directory where phpMyAdmin can save temporary files.
2753 * @global string $cfg['TempDir']
2755 $cfg['TempDir'] = '';
2763 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2764 * which is the only safe way to determine GD version.
2766 * @global string $cfg['GD2Available']
2768 $cfg['GD2Available'] = 'auto';
2771 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2773 * @global array $cfg['TrustedProxies']
2775 $cfg['TrustedProxies'] = array();
2778 * We normally check the permissions on the configuration file to ensure
2779 * it's not world writable. However, phpMyAdmin could be installed on
2780 * a NTFS filesystem mounted on a non-Windows server, in which case the
2781 * permissions seems wrong but in fact cannot be detected. In this case
2782 * a sysadmin would set the following to false.
2784 $cfg['CheckConfigurationPermissions'] = true;
2787 * Limit for length of URL in links. When length would be above this limit, it
2788 * is replaced by form with button.
2789 * This is required as some web servers (IIS) have problems with long URLs.
2790 * The recommended limit is 2000
2791 * (see http://www.boutell.com/newfaq/misc/urllength.html) but we put
2792 * 1000 to accommodate Suhosin, see bug #3358750.
2794 $cfg['LinkLengthLimit'] = 1000;
2797 * Additional string to allow in CSP headers.
2799 $cfg['CSPAllow'] = '';
2802 * Disable the table maintenance mass operations, like optimizing or
2803 * repairing the selected tables of a database. An accidental execution
2804 * of such a maintenance task can enormously slow down a bigger database.
2806 $cfg['DisableMultiTableMaintenance'] = false;
2809 * Whether or not to query the user before sending the error report to
2810 * the phpMyAdmin team when a JavaScript error occurs
2813 * (ask | always | never)
2815 * @global string $cfg['SendErrorReports']
2817 $cfg['SendErrorReports'] = 'ask';
2820 /*******************************************************************************
2823 * @global array $cfg['DBG']
2825 $cfg['DBG'] = array();
2828 * Output executed queries and their execution times
2830 * @global boolean $cfg['DBG']['sql']
2832 $cfg['DBG']['sql'] = false;
2835 * Enable to let server present itself as demo server.
2837 * @global boolean $cfg['DBG']['demo']
2839 $cfg['DBG']['demo'] = false;
2842 /*******************************************************************************
2847 * Default functions for above defined groups
2849 * @global array $cfg['DefaultFunctions']
2851 $cfg['DefaultFunctions'] = array(
2854 'FUNC_NUMBER' => '',
2855 'FUNC_SPATIAL' => 'GeomFromText',
2856 'FUNC_UUID' => 'UUID',
2857 'first_timestamp' => 'NOW',
2861 * Max rows retreived for zoom search
2863 $cfg['maxRowPlotLimit'] = 500;