Translated using Weblate (Slovenian)
[phpmyadmin.git] / libraries / config.default.php
blobf55029314a922a51dcd021cfa31cf59510b2498f
1 <?php
2 /**
3 * <code>
4 * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
5 * NN N O O !! D D O O NN N O O T E D D I T !!
6 * N N N O O !! D D O O N N N O O T EEEE D D I T !!
7 * N NN O O D D O O N NN O O T E D D I T
8 * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
9 * </code>
11 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
13 * phpMyAdmin default configuration, you can copy values from here to your
14 * config.inc.php
16 * All directives are explained in the documentation
19 declare(strict_types=1);
21 /**
22 * Your phpMyAdmin URL.
24 * Complete the variable below with the full URL ie
25 * https://example.com/path_to_your_phpMyAdmin_directory/
27 * It must contain characters that are valid for a URL, and the path is
28 * case sensitive on some Web servers, for example Unix-based servers.
30 * In most cases you can leave this variable empty, as the correct value
31 * will be detected automatically. However, we recommend that you do
32 * test to see that the auto-detection code works in your system. A good
33 * test is to browse a table, then edit a row and save it. There will be
34 * an error message if phpMyAdmin cannot auto-detect the correct value.
36 * @global string $cfg['PmaAbsoluteUri']
38 $cfg['PmaAbsoluteUri'] = '';
40 /**
41 * Configure authentication logging destination
43 * @global string $cfg['AuthLog']
45 $cfg['AuthLog'] = 'auto';
47 /**
48 * Whether to log successful authentication attempts
50 * @global boolean $cfg['AuthLogSuccess']
52 $cfg['AuthLogSuccess'] = false;
54 /**
55 * Disable the default warning that is displayed on the DB Details Structure page if
56 * any of the required Tables for the configuration storage could not be found
58 * @global boolean $cfg['PmaNoRelation_DisableWarning']
60 $cfg['PmaNoRelation_DisableWarning'] = false;
62 /**
63 * Disable the default warning that is displayed if Suhosin is detected
65 * @global boolean $cfg['SuhosinDisableWarning']
67 $cfg['SuhosinDisableWarning'] = false;
69 /**
70 * Disable the default warning that is displayed if session.gc_maxlifetime
71 * is less than `LoginCookieValidity`
73 * @global boolean $cfg['LoginCookieValidityDisableWarning']
75 $cfg['LoginCookieValidityDisableWarning'] = false;
77 /**
78 * Disable the default warning about MySQL reserved words in column names
80 * @global boolean $cfg['ReservedWordDisableWarning']
82 $cfg['ReservedWordDisableWarning'] = false;
84 /**
85 * Show warning about incomplete translations on certain threshold.
87 * @global boolean $cfg['TranslationWarningThreshold']
89 $cfg['TranslationWarningThreshold'] = 80;
91 /**
92 * Allows phpMyAdmin to be included from a other document in a frame;
93 * setting this to true is a potential security hole. Setting this to
94 * 'sameorigin' prevents phpMyAdmin to be included from another document
95 * in a frame, unless that document belongs to the same domain.
97 * @global boolean|string $cfg['AllowThirdPartyFraming']
99 $cfg['AllowThirdPartyFraming'] = false;
102 * The 'cookie' auth_type uses AES algorithm to encrypt the password. If
103 * at least one server configuration uses 'cookie' auth_type, enter here a
104 * pass phrase that will be used by AES. The maximum length seems to be 46
105 * characters.
107 * @global string $cfg['blowfish_secret']
109 $cfg['blowfish_secret'] = '';
112 /*******************************************************************************
113 * Server(s) configuration
115 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
116 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
117 * to ''. If you want more than one server, just copy following section
118 * (including $i incrementation) several times. There is no need to define
119 * full server array, just define values you need to change.
121 * @global array $cfg['Servers']
123 $cfg['Servers'] = [];
125 $i = 1;
128 * MySQL hostname or IP address
130 * @global string $cfg['Servers'][$i]['host']
132 $cfg['Servers'][$i]['host'] = 'localhost';
135 * MySQL port - leave blank for default port
137 * @global string $cfg['Servers'][$i]['port']
139 $cfg['Servers'][$i]['port'] = '';
142 * Path to the socket - leave blank for default socket
144 * @global string $cfg['Servers'][$i]['socket']
146 $cfg['Servers'][$i]['socket'] = '';
149 * Use SSL for connecting to MySQL server?
151 * @global boolean $cfg['Servers'][$i]['ssl']
153 $cfg['Servers'][$i]['ssl'] = false;
156 * Path to the key file when using SSL for connecting to the MySQL server
158 * @global string $cfg['Servers'][$i]['ssl_key']
160 $cfg['Servers'][$i]['ssl_key'] = null;
163 * Path to the cert file when using SSL for connecting to the MySQL server
165 * @global string $cfg['Servers'][$i]['ssl_cert']
167 $cfg['Servers'][$i]['ssl_cert'] = null;
170 * Path to the CA file when using SSL for connecting to the MySQL server
172 * @global string $cfg['Servers'][$i]['ssl_ca']
174 $cfg['Servers'][$i]['ssl_ca'] = null;
177 * Directory containing trusted SSL CA certificates in PEM format
179 * @global string $cfg['Servers'][$i]['ssl_ca_path']
181 $cfg['Servers'][$i]['ssl_ca_path'] = null;
184 * List of allowable ciphers for SSL connections to the MySQL server
186 * @global string $cfg['Servers'][$i]['ssl_ciphers']
188 $cfg['Servers'][$i]['ssl_ciphers'] = null;
191 * MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
192 * peer_name of the SSL certifcate
193 * For most self-signed certificates this is a problem. Setting this to false
194 * will disable the check and allow the connection (PHP 5.6.16 or later)
196 * @link https://bugs.php.net/68344
198 * @global string $cfg['Servers'][$i]['ssl_verify']
200 $cfg['Servers'][$i]['ssl_verify'] = true;
203 * Use compressed protocol for the MySQL connection
205 * @global boolean $cfg['Servers'][$i]['compress']
207 $cfg['Servers'][$i]['compress'] = false;
210 * MySQL control host. This permits to use a host different than the
211 * main host, for the phpMyAdmin configuration storage. If left empty,
212 * $cfg['Servers'][$i]['host'] is used instead.
214 * @global string $cfg['Servers'][$i]['controlhost']
216 $cfg['Servers'][$i]['controlhost'] = '';
219 * MySQL control port. This permits to use a port different than the
220 * main port, for the phpMyAdmin configuration storage. If left empty,
221 * $cfg['Servers'][$i]['port'] is used instead.
223 * @global string $cfg['Servers'][$i]['controlport']
225 $cfg['Servers'][$i]['controlport'] = '';
228 * MySQL control user settings (this user must have read-only
229 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
230 * used for all relational features (pmadb)
232 * @global string $cfg['Servers'][$i]['controluser']
234 $cfg['Servers'][$i]['controluser'] = '';
237 * MySQL control user settings (this user must have read-only
238 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
239 * used for all relational features (pmadb)
241 * @global string $cfg['Servers'][$i]['controlpass']
243 $cfg['Servers'][$i]['controlpass'] = '';
246 * Authentication method (valid choices: config, http, signon or cookie)
248 * @global string $cfg['Servers'][$i]['auth_type']
250 $cfg['Servers'][$i]['auth_type'] = 'cookie';
253 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
255 * @global string $cfg['Servers'][$i]['auth_http_realm']
257 $cfg['Servers'][$i]['auth_http_realm'] = '';
260 * MySQL user
262 * @global string $cfg['Servers'][$i]['user']
264 $cfg['Servers'][$i]['user'] = 'root';
267 * MySQL password (only needed with 'config' auth_type)
269 * @global string $cfg['Servers'][$i]['password']
271 $cfg['Servers'][$i]['password'] = '';
274 * Session to use for 'signon' authentication method
276 * @global string $cfg['Servers'][$i]['SignonSession']
278 $cfg['Servers'][$i]['SignonSession'] = '';
281 * Cookie params to match session to use for 'signon' authentication method
282 * It should be an associative array matching result of session_get_cookie_params() in other system
284 * @global array $cfg['Servers'][$i]['SignonCookieParams']
286 $cfg['Servers'][$i]['SignonCookieParams'] = [];
289 * PHP script to use for 'signon' authentication method
291 * @global string $cfg['Servers'][$i]['SignonScript']
293 $cfg['Servers'][$i]['SignonScript'] = '';
296 * URL where to redirect user to login for 'signon' authentication method
298 * @global string $cfg['Servers'][$i]['SignonURL']
300 $cfg['Servers'][$i]['SignonURL'] = '';
303 * URL where to redirect user after logout
305 * @global string $cfg['Servers'][$i]['LogoutURL']
307 $cfg['Servers'][$i]['LogoutURL'] = '';
310 * If set to a db-name, only this db is displayed in navigation panel
311 * It may also be an array of db-names
313 * @global string $cfg['Servers'][$i]['only_db']
315 $cfg['Servers'][$i]['only_db'] = '';
318 * Database name to be hidden from listings
320 * @global string $cfg['Servers'][$i]['hide_db']
322 $cfg['Servers'][$i]['hide_db'] = '';
325 * Verbose name for this host - leave blank to show the hostname
326 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
328 * @global string $cfg['Servers'][$i]['verbose']
330 $cfg['Servers'][$i]['verbose'] = '';
333 * Database used for Relation, Bookmark and PDF Features
334 * (see sql/create_tables.sql)
335 * - leave blank for no support
336 * SUGGESTED: 'phpmyadmin'
338 * @global string $cfg['Servers'][$i]['pmadb']
340 $cfg['Servers'][$i]['pmadb'] = '';
343 * Bookmark table
344 * - leave blank for no bookmark support
345 * SUGGESTED: 'pma__bookmark'
347 * @global string $cfg['Servers'][$i]['bookmarktable']
349 $cfg['Servers'][$i]['bookmarktable'] = '';
352 * table to describe the relation between links (see doc)
353 * - leave blank for no relation-links support
354 * SUGGESTED: 'pma__relation'
356 * @global string $cfg['Servers'][$i]['relation']
358 $cfg['Servers'][$i]['relation'] = '';
361 * table to describe the display fields
362 * - leave blank for no display fields support
363 * SUGGESTED: 'pma__table_info'
365 * @global string $cfg['Servers'][$i]['table_info']
367 $cfg['Servers'][$i]['table_info'] = '';
370 * table to describe the tables position for the designer and PDF schema
371 * - leave blank for no PDF schema support
372 * SUGGESTED: 'pma__table_coords'
374 * @global string $cfg['Servers'][$i]['table_coords']
376 $cfg['Servers'][$i]['table_coords'] = '';
379 * table to describe pages of relationpdf
380 * - leave blank if you don't want to use this
381 * SUGGESTED: 'pma__pdf_pages'
383 * @global string $cfg['Servers'][$i]['pdf_pages']
385 $cfg['Servers'][$i]['pdf_pages'] = '';
388 * table to store column information
389 * - leave blank for no column comments/mime types
390 * SUGGESTED: 'pma__column_info'
392 * @global string $cfg['Servers'][$i]['column_info']
394 $cfg['Servers'][$i]['column_info'] = '';
397 * table to store SQL history
398 * - leave blank for no SQL query history
399 * SUGGESTED: 'pma__history'
401 * @global string $cfg['Servers'][$i]['history']
403 $cfg['Servers'][$i]['history'] = '';
406 * table to store recently used tables
407 * - leave blank for no "persistent" recently used tables
408 * SUGGESTED: 'pma__recent'
410 $cfg['Servers'][$i]['recent'] = '';
413 * table to store favorite tables
414 * - leave blank for no favorite tables
415 * SUGGESTED: 'pma__favorite'
417 $cfg['Servers'][$i]['favorite'] = '';
420 * table to store UI preferences for tables
421 * - leave blank for no "persistent" UI preferences
422 * SUGGESTED: 'pma__table_uiprefs'
424 $cfg['Servers'][$i]['table_uiprefs'] = '';
427 * table to store SQL tracking
428 * - leave blank for no SQL tracking
429 * SUGGESTED: 'pma__tracking'
431 * @global string $cfg['Servers'][$i]['tracking']
433 $cfg['Servers'][$i]['tracking'] = '';
436 * table to store user preferences
437 * - leave blank to disable server storage
438 * SUGGESTED: 'pma__userconfig'
440 * @global string $cfg['Servers'][$i]['userconfig']
442 $cfg['Servers'][$i]['userconfig'] = '';
445 * table to store users and their assignment to user groups
446 * - leave blank to disable configurable menus feature
447 * SUGGESTED: 'pma__users'
449 * @global string $cfg['Servers'][$i]['users']
451 $cfg['Servers'][$i]['users'] = '';
454 * table to store allowed menu items for each user group
455 * - leave blank to disable configurable menus feature
456 * SUGGESTED: 'pma__usergroups'
458 * @global string $cfg['Servers'][$i]['usergroups']
460 $cfg['Servers'][$i]['usergroups'] = '';
463 * table to store information about item hidden from navigation tree
464 * - leave blank to disable hide/show navigation items feature
465 * SUGGESTED: 'pma__navigationhiding'
467 * @global string $cfg['Servers'][$i]['navigationhiding']
469 $cfg['Servers'][$i]['navigationhiding'] = '';
472 * table to store information about saved searches from query-by-example on a db
473 * - leave blank to disable saved searches feature
474 * SUGGESTED: 'pma__savedsearches'
476 * @global string $cfg['Servers'][$i]['savedsearches']
478 $cfg['Servers'][$i]['savedsearches'] = '';
481 * table to store central list of columns per database
482 * - leave blank to disable central list of columns feature
483 * SUGGESTED: 'pma__central_columns'
485 * @global string $cfg['Servers'][$i]['central_columns']
487 $cfg['Servers'][$i]['central_columns'] = '';
490 * table to store designer settings
491 * - leave blank to disable the storage of designer settings
492 * SUGGESTED: 'pma__designer_settings'
494 * @global string $cfg['Servers'][$i]['designer_settings']
496 $cfg['Servers'][$i]['designer_settings'] = '';
499 * table to store export templates
500 * - leave blank to disable saved searches feature
501 * SUGGESTED: 'pma__export_templates'
503 * @global string $cfg['Servers'][$i]['export_templates']
505 $cfg['Servers'][$i]['export_templates'] = '';
508 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
510 * In case where tables in databases is modified (e.g. dropped or renamed),
511 * table_uiprefs may contains invalid data (referring to tables which are not
512 * exist anymore).
513 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
514 * newest record in table_uiprefs and automatically delete older records.
516 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
518 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
521 * Sets the time zone used by phpMyAdmin. Possible values are explained at
522 * https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
524 * @global string $cfg['Servers'][$i]['SessionTimeZone'] = ''
526 $cfg['Servers'][$i]['SessionTimeZone'] = '';
529 * whether to allow root login
531 * @global boolean $cfg['Servers'][$i]['AllowRoot']
533 $cfg['Servers'][$i]['AllowRoot'] = true;
536 * whether to allow login of any user without a password
538 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
540 $cfg['Servers'][$i]['AllowNoPassword'] = false;
543 * Host authentication order, leave blank to not use
545 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
547 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
550 * Host authentication rules, leave blank for defaults
552 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
554 $cfg['Servers'][$i]['AllowDeny']['rules'] = [];
557 * Disable use of INFORMATION_SCHEMA.
559 * @see https://github.com/phpmyadmin/phpmyadmin/issues/8970
560 * @see https://bugs.mysql.com/19588
562 * @global boolean $cfg['Servers'][$i]['DisableIS']
564 $cfg['Servers'][$i]['DisableIS'] = false;
567 * Whether the tracking mechanism creates
568 * versions for tables and views automatically.
570 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
572 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
575 * Defines the list of statements
576 * the auto-creation uses for new versions.
578 * @global string $cfg['Servers'][$i]['tracking_default_statements']
580 $cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
581 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
582 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
585 * Whether a DROP VIEW IF EXISTS statement will be added
586 * as first line to the log when creating a view.
588 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
590 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
593 * Whether a DROP TABLE IF EXISTS statement will be added
594 * as first line to the log when creating a table.
596 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
598 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
601 * Whether a DROP DATABASE IF EXISTS statement will be added
602 * as first line to the log when creating a database.
604 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
606 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
609 * Default server (0 = no default server)
611 * If you have more than one server configured, you can set $cfg['ServerDefault']
612 * to any one of them to auto-connect to that server when phpMyAdmin is started,
613 * or set it to 0 to be given a list of servers without logging in
614 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
615 * set to that server.
617 * @global integer $cfg['ServerDefault']
619 $cfg['ServerDefault'] = 1;
622 * Other core phpMyAdmin settings
626 * whether version check is active
628 * @global boolean $cfg['VersionCheck']
630 if (defined('VERSION_CHECK_DEFAULT')) {
631 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
632 } else {
633 $cfg['VersionCheck'] = true;
637 * The url of the proxy to be used when retrieving the information about
638 * the latest version of phpMyAdmin or error reporting. You need this if
639 * the server where phpMyAdmin is installed does not have direct access to
640 * the internet.
641 * The format is: "hostname:portnumber"
643 * @global string $cfg['ProxyUrl']
645 $cfg['ProxyUrl'] = '';
648 * The username for authenticating with the proxy. By default, no
649 * authentication is performed. If a username is supplied, Basic
650 * Authentication will be performed. No other types of authentication
651 * are currently supported.
653 * @global string $cfg['ProxyUser']
655 $cfg['ProxyUser'] = '';
658 * The password for authenticating with the proxy.
660 * @global string $cfg['ProxyPass']
662 $cfg['ProxyPass'] = '';
665 * maximum number of db's displayed in database list
667 * @global integer $cfg['MaxDbList']
669 $cfg['MaxDbList'] = 100;
672 * maximum number of tables displayed in table list
674 * @global integer $cfg['MaxTableList']
676 $cfg['MaxTableList'] = 250;
679 * whether to show hint or not
681 * @global boolean $cfg['ShowHint']
683 $cfg['ShowHint'] = true;
686 * maximum number of characters when a SQL query is displayed
688 * @global integer $cfg['MaxCharactersInDisplayedSQL']
690 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
693 * use GZIP output buffering if possible (true|false|'auto')
695 * @global string $cfg['OBGzip']
697 $cfg['OBGzip'] = 'auto';
700 * use persistent connections to MySQL database
702 * @global boolean $cfg['PersistentConnections']
704 $cfg['PersistentConnections'] = false;
707 * maximum execution time in seconds (0 for no limit)
709 * @global integer $cfg['ExecTimeLimit']
711 $cfg['ExecTimeLimit'] = 300;
714 * Path for storing session data (session_save_path PHP parameter).
716 * @global integer $cfg['SessionSavePath']
718 $cfg['SessionSavePath'] = '';
721 * Hosts or IPs to consider safe when checking if SSL is used or not
723 * @global array $cfg['MysqlSslWarningSafeHosts']
725 $cfg['MysqlSslWarningSafeHosts'] = ['127.0.0.1', 'localhost'];
728 * maximum allocated bytes ('-1' for no limit, '0' for no change)
729 * this is a string because '16M' is a valid value; we must put here
730 * a string as the default value so that /setup accepts strings
732 * @global string $cfg['MemoryLimit']
734 $cfg['MemoryLimit'] = '-1';
737 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
739 * @global boolean $cfg['SkipLockedTables']
741 $cfg['SkipLockedTables'] = false;
744 * show SQL queries as run
746 * @global boolean $cfg['ShowSQL']
748 $cfg['ShowSQL'] = true;
751 * retain SQL input on Ajax execute
753 * @global boolean $cfg['RetainQueryEditor']
755 $cfg['RetainQueryBox'] = false;
758 * use CodeMirror syntax highlighting for editing SQL
760 * @global boolean $cfg['CodemirrorEnable']
762 $cfg['CodemirrorEnable'] = true;
765 * use the parser to find any errors in the query before executing
767 * @global boolean $cfg['LintEnable']
769 $cfg['LintEnable'] = true;
772 * show a 'Drop database' link to normal users
774 * @global boolean $cfg['AllowUserDropDatabase']
776 $cfg['AllowUserDropDatabase'] = false;
779 * confirm some commands that can result in loss of data
781 * @global boolean $cfg['Confirm']
783 $cfg['Confirm'] = true;
786 * sets SameSite attribute of the Set-Cookie HTTP response header
788 * @global boolean $cfg['CookieSameSite']
790 $cfg['CookieSameSite'] = 'Strict';
793 * recall previous login in cookie authentication mode or not
795 * @global boolean $cfg['LoginCookieRecall']
797 $cfg['LoginCookieRecall'] = true;
800 * validity of cookie login (in seconds; 1440 matches php.ini's
801 * session.gc_maxlifetime)
803 * @global integer $cfg['LoginCookieValidity']
805 $cfg['LoginCookieValidity'] = 1440;
808 * how long login cookie should be stored (in seconds)
810 * @global integer $cfg['LoginCookieStore']
812 $cfg['LoginCookieStore'] = 0;
815 * whether to delete all login cookies on logout
817 * @global boolean $cfg['LoginCookieDeleteAll']
819 $cfg['LoginCookieDeleteAll'] = true;
822 * whether to enable the "database search" feature or not
824 * @global boolean $cfg['UseDbSearch']
826 $cfg['UseDbSearch'] = true;
829 * if set to true, PMA continues computing multiple-statement queries
830 * even if one of the queries failed
832 * @global boolean $cfg['IgnoreMultiSubmitErrors']
834 $cfg['IgnoreMultiSubmitErrors'] = false;
837 * allow login to any user entered server in cookie based authentication
839 * @global boolean $cfg['AllowArbitraryServer']
841 $cfg['AllowArbitraryServer'] = false;
844 * restrict by IP (with regular expression) the MySQL servers the user can enter
845 * when $cfg['AllowArbitraryServer'] = true
847 * @global string $cfg['ArbitraryServerRegexp']
849 $cfg['ArbitraryServerRegexp'] = '';
852 * To enable reCaptcha v2 checkbox mode if necessary
854 * @global string $cfg['CaptchaMethod']
856 $cfg['CaptchaMethod'] = 'invisible';
859 * URL for the reCaptcha v2 compatible API to use
861 * @global string $cfg['CaptchaApi']
863 $cfg['CaptchaApi'] = 'https://www.google.com/recaptcha/api.js';
866 * Content-Security-Policy snippet for the reCaptcha v2 compatible API
868 * @global string $cfg['CaptchaCsp']
870 $cfg['CaptchaCsp'] = 'https://apis.google.com https://www.google.com/recaptcha/'
871 . ' https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/';
874 * reCaptcha API's request parameter name
876 * @global string $cfg['CaptchaRequestParam']
878 $cfg['CaptchaRequestParam'] = 'g-recaptcha';
881 * reCaptcha API's response parameter name
883 * @global string $cfg['CaptchaResponseParam']
885 $cfg['CaptchaResponseParam'] = 'g-recaptcha-response';
888 * if reCaptcha is enabled it needs public key to connect with the service
890 * @global string $cfg['CaptchaLoginPublicKey']
892 $cfg['CaptchaLoginPublicKey'] = '';
895 * if reCaptcha is enabled it needs private key to connect with the service
897 * @global string $cfg['CaptchaLoginPrivateKey']
899 $cfg['CaptchaLoginPrivateKey'] = '';
902 * if reCaptcha is enabled may need an URL for site verify
904 * @global string $cfg['CaptchaSiteVerifyURL']
906 $cfg['CaptchaSiteVerifyURL'] = '';
909 * Enable drag and drop import
911 * @see feature request : https://github.com/phpmyadmin/phpmyadmin/issues/13155
913 * @global bool $cfg['enable_drag_drop_import']
915 $cfg['enable_drag_drop_import'] = true;
917 /*******************************************************************************
918 * Navigation panel setup
922 * In the navigation panel, replaces the database tree with a selector
924 * @global boolean $cfg['ShowDatabasesNavigationAsTree']
926 $cfg['ShowDatabasesNavigationAsTree'] = true;
929 * maximum number of first level databases displayed in navigation panel
931 * @global integer $cfg['FirstLevelNavigationItems']
933 $cfg['FirstLevelNavigationItems'] = 100;
936 * maximum number of items displayed in navigation panel
938 * @global integer $cfg['MaxNavigationItems']
940 $cfg['MaxNavigationItems'] = 50;
943 * turn the select-based light menu into a tree
945 * @global boolean $cfg['NavigationTreeEnableGrouping']
947 $cfg['NavigationTreeEnableGrouping'] = true;
950 * the separator to sub-tree the select-based light menu tree
952 * @global string $cfg['NavigationTreeDbSeparator']
954 $cfg['NavigationTreeDbSeparator'] = '_';
957 * Which string will be used to generate table prefixes
958 * to split/nest tables into multiple categories
960 * @global string $cfg['NavigationTreeTableSeparator']
962 $cfg['NavigationTreeTableSeparator'] = '__';
965 * How many sublevels should be displayed when splitting up tables
966 * by the above Separator
968 * @global integer $cfg['NavigationTreeTableLevel']
970 $cfg['NavigationTreeTableLevel'] = 1;
973 * link with main panel by highlighting the current db/table
975 * @global boolean $cfg['NavigationLinkWithMainPanel']
977 $cfg['NavigationLinkWithMainPanel'] = true;
980 * display logo at top of navigation panel
982 * @global boolean $cfg['NavigationDisplayLogo']
984 $cfg['NavigationDisplayLogo'] = true;
987 * where should logo link point to (can also contain an external URL)
989 * @global string $cfg['NavigationLogoLink']
991 $cfg['NavigationLogoLink'] = 'index.php';
994 * whether to open the linked page in the main window ('main') or
995 * in a new window ('new')
997 * @global string $cfg['NavigationLogoLinkWindow']
999 $cfg['NavigationLogoLinkWindow'] = 'main';
1002 * number of recently used tables displayed in the navigation panel
1004 * @global integer $cfg['NumRecentTables']
1006 $cfg['NumRecentTables'] = 10;
1009 * number of favorite tables displayed in the navigation panel
1011 * @global integer $cfg['NumFavoriteTables']
1013 $cfg['NumFavoriteTables'] = 10;
1016 * display a JavaScript table filter in the navigation panel
1017 * when more then x tables are present
1019 * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
1021 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
1024 * display server choice at top of navigation panel
1026 * @global boolean $cfg['NavigationDisplayServers']
1028 $cfg['NavigationDisplayServers'] = true;
1031 * server choice as links
1033 * @global boolean $cfg['DisplayServersList']
1035 $cfg['DisplayServersList'] = false;
1038 * display a JavaScript database filter in the navigation panel
1039 * when more then x databases are present
1041 * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
1043 $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
1046 * target of the navigation panel quick access icon
1048 * Possible values:
1049 * 'structure' = fields list
1050 * 'sql' = SQL form
1051 * 'search' = search page
1052 * 'insert' = insert row page
1053 * 'browse' = browse page
1055 * @global string $cfg['NavigationTreeDefaultTabTable']
1057 $cfg['NavigationTreeDefaultTabTable'] = 'structure';
1060 * target of the navigation panel quick second access icon
1062 * Possible values:
1063 * 'structure' = fields list
1064 * 'sql' = SQL form
1065 * 'search' = search page
1066 * 'insert' = insert row page
1067 * 'browse' = browse page
1068 * '' = no link
1070 * @global string $cfg['NavigationTreeDefaultTabTable2']
1072 $cfg['NavigationTreeDefaultTabTable2'] = '';
1075 * Enables the possibility of navigation tree expansion
1077 * @global boolean $cfg['NavigationTreeEnableExpansion']
1079 $cfg['NavigationTreeEnableExpansion'] = true;
1082 * Show tables in navigation panel
1084 * @global boolean $cfg['NavigationTreeShowTables']
1086 $cfg['NavigationTreeShowTables'] = true;
1089 * Show views in navigation panel
1091 * @global boolean $cfg['NavigationTreeShowViews']
1093 $cfg['NavigationTreeShowViews'] = true;
1096 * Show functions in navigation panel
1098 * @global boolean $cfg['NavigationTreeShowFunctions']
1100 $cfg['NavigationTreeShowFunctions'] = true;
1103 * Show procedures in navigation panel
1105 * @global boolean $cfg['NavigationTreeShowProcedures']
1107 $cfg['NavigationTreeShowProcedures'] = true;
1110 * Show events in navigation panel
1112 * @global boolean $cfg['NavigationTreeShowEvents']
1114 $cfg['NavigationTreeShowEvents'] = true;
1117 * Width of navigation panel
1119 * @global integer $cfg['NavigationWidth']
1121 $cfg['NavigationWidth'] = 240;
1124 * Automatically expands single database in navigation panel
1126 * @global boolean $cfg['NavigationAutoexpandSingleDb']
1128 $cfg['NavigationTreeAutoexpandSingleDb'] = true;
1130 /*******************************************************************************
1131 * In the main panel, at startup...
1135 * allow to display statistics and space usage in the pages about database
1136 * details and table properties
1138 * @global boolean $cfg['ShowStats']
1140 $cfg['ShowStats'] = true;
1143 * show PHP info link
1145 * @global boolean $cfg['ShowPhpInfo']
1147 $cfg['ShowPhpInfo'] = false;
1150 * show MySQL server and web server information
1152 * @global boolean $cfg['ShowServerInfo']
1154 $cfg['ShowServerInfo'] = true;
1157 * show change password link
1159 * @global boolean $cfg['ShowChgPassword']
1161 $cfg['ShowChgPassword'] = true;
1164 * show create database form
1166 * @global boolean $cfg['ShowCreateDb']
1168 $cfg['ShowCreateDb'] = true;
1171 /*******************************************************************************
1172 * Database structure
1176 * show charset column in database structure (true|false)?
1178 * @global boolean $cfg['ShowDbStructureCharset']
1180 $cfg['ShowDbStructureCharset'] = false;
1183 * show comment column in database structure (true|false)?
1185 * @global boolean $cfg['ShowDbStructureComment']
1187 $cfg['ShowDbStructureComment'] = false;
1190 * show creation timestamp column in database structure (true|false)?
1192 * @global boolean $cfg['ShowDbStructureCreation']
1194 $cfg['ShowDbStructureCreation'] = false;
1197 * show last update timestamp column in database structure (true|false)?
1199 * @global boolean $cfg['ShowDbStructureLastUpdate']
1201 $cfg['ShowDbStructureLastUpdate'] = false;
1204 * show last check timestamp column in database structure (true|false)?
1206 * @global boolean $cfg['ShowDbStructureLastCheck']
1208 $cfg['ShowDbStructureLastCheck'] = false;
1211 * allow hide action columns to drop down menu in database structure (true|false)?
1213 * @global boolean $cfg['HideStructureActions']
1215 $cfg['HideStructureActions'] = true;
1218 * Show column comments in table structure view (true|false)?
1220 * @global boolean $cfg['ShowColumnComments']
1222 $cfg['ShowColumnComments'] = true;
1225 /*******************************************************************************
1226 * In browse mode...
1230 * Use icons instead of text for the navigation bar buttons (table browse)
1231 * ('text'|'icons'|'both')
1233 * @global string $cfg['TableNavigationLinksMode']
1235 $cfg['TableNavigationLinksMode'] = 'icons';
1238 * Defines whether a user should be displayed a "show all (records)"
1239 * button in browse mode or not.
1241 * @global boolean $cfg['ShowAll']
1243 $cfg['ShowAll'] = false;
1246 * Number of rows displayed when browsing a result set. If the result
1247 * set contains more rows, "Previous" and "Next".
1248 * Possible values: 25,50,100,250,500
1250 * @global integer $cfg['MaxRows']
1252 $cfg['MaxRows'] = 25;
1255 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
1256 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
1257 * ascending order else-)
1259 * @global string $cfg['Order']
1261 $cfg['Order'] = 'SMART';
1264 * grid editing: save edited cell(s) in browse-mode at once
1266 * @global boolean $cfg['SaveCellsAtOnce']
1268 $cfg['SaveCellsAtOnce'] = false;
1271 * grid editing: which action triggers it, or completely disable the feature
1273 * Possible values:
1274 * 'click'
1275 * 'double-click'
1276 * 'disabled'
1278 * @global string $cfg['GridEditing']
1280 $cfg['GridEditing'] = 'double-click';
1283 * Options > Relational display
1285 * Possible values:
1286 * 'K' for key value
1287 * 'D' for display column
1289 * @global string $cfg['RelationalDisplay']
1291 $cfg['RelationalDisplay'] = 'K';
1294 /*******************************************************************************
1295 * In edit mode...
1299 * disallow editing of binary fields
1300 * valid values are:
1301 * false allow editing
1302 * 'blob' allow editing except for BLOB fields
1303 * 'noblob' disallow editing except for BLOB fields
1304 * 'all' disallow editing
1306 * @global string $cfg['ProtectBinary']
1308 $cfg['ProtectBinary'] = 'blob';
1311 * Display the function fields in edit/insert mode
1313 * @global boolean $cfg['ShowFunctionFields']
1315 $cfg['ShowFunctionFields'] = true;
1318 * Display the type fields in edit/insert mode
1320 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1322 $cfg['ShowFieldTypesInDataEditView'] = true;
1325 * Which editor should be used for CHAR/VARCHAR fields:
1326 * input - allows limiting of input length
1327 * textarea - allows newlines in fields
1329 * @global string $cfg['CharEditing']
1331 $cfg['CharEditing'] = 'input';
1334 * The minimum size for character input fields
1336 * @global integer $cfg['MinSizeForInputField']
1338 $cfg['MinSizeForInputField'] = 4;
1341 * The maximum size for character input fields
1343 * @global integer $cfg['MinSizeForInputField']
1345 $cfg['MaxSizeForInputField'] = 60;
1348 * How many rows can be inserted at one time
1350 * @global integer $cfg['InsertRows']
1352 $cfg['InsertRows'] = 2;
1355 * Sort order for items in a foreign-key drop-down list.
1356 * 'content' is the referenced data, 'id' is the key value.
1358 * @global array $cfg['ForeignKeyDropdownOrder']
1360 $cfg['ForeignKeyDropdownOrder'] = [
1361 'content-id',
1362 'id-content',
1366 * A drop-down list will be used if fewer items are present
1368 * @global integer $cfg['ForeignKeyMaxLimit']
1370 $cfg['ForeignKeyMaxLimit'] = 100;
1373 * Whether to disable foreign key checks while importing
1375 * @global boolean $cfg['DefaultForeignKeyChecks']
1377 $cfg['DefaultForeignKeyChecks'] = 'default';
1379 /*******************************************************************************
1380 * For the export features...
1384 * Allow for the use of zip compression (requires zip support to be enabled)
1386 * @global boolean $cfg['ZipDump']
1388 $cfg['ZipDump'] = true;
1391 * Allow for the use of gzip compression (requires zlib)
1393 * @global boolean $cfg['GZipDump']
1395 $cfg['GZipDump'] = true;
1398 * Allow for the use of bzip2 decompression (requires bz2 extension)
1400 * @global boolean $cfg['BZipDump']
1402 $cfg['BZipDump'] = true;
1405 * Will compress gzip exports on the fly without the need for much memory.
1406 * If you encounter problems with created gzip files disable this feature.
1408 * @global boolean $cfg['CompressOnFly']
1410 $cfg['CompressOnFly'] = true;
1413 /*******************************************************************************
1414 * Tabs display settings
1418 * How to display the menu tabs ('icons'|'text'|'both')
1420 * @global boolean $cfg['TabsMode']
1422 $cfg['TabsMode'] = 'both';
1425 * How to display various action links ('icons'|'text'|'both')
1427 * @global boolean $cfg['ActionLinksMode']
1429 $cfg['ActionLinksMode'] = 'both';
1432 * How many columns should be used for table display of a database?
1433 * (a value larger than 1 results in some information being hidden)
1435 * @global integer $cfg['PropertiesNumColumns']
1437 $cfg['PropertiesNumColumns'] = 1;
1440 * Possible values:
1441 * 'welcome' = the welcome page
1442 * (recommended for multiuser setups)
1443 * 'databases' = list of databases
1444 * 'status' = runtime information
1445 * 'variables' = MySQL server variables
1446 * 'privileges' = user management
1448 * @global string $cfg['DefaultTabServer']
1450 $cfg['DefaultTabServer'] = 'welcome';
1453 * Possible values:
1454 * 'structure' = tables list
1455 * 'sql' = SQL form
1456 * 'search' = search query
1457 * 'operations' = operations on database
1459 * @global string $cfg['DefaultTabDatabase']
1461 $cfg['DefaultTabDatabase'] = 'structure';
1464 * Possible values:
1465 * 'structure' = fields list
1466 * 'sql' = SQL form
1467 * 'search' = search page
1468 * 'insert' = insert row page
1469 * 'browse' = browse page
1471 * @global string $cfg['DefaultTabTable']
1473 $cfg['DefaultTabTable'] = 'browse';
1476 * Whether to display image or text or both image and text in table row
1477 * action segment. Value can be either of ``image``, ``text`` or ``both``.
1479 $cfg['RowActionType'] = 'both';
1481 /*******************************************************************************
1482 * Export defaults
1484 $cfg['Export'] = [];
1487 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml
1489 * @global string $cfg['Export']['format']
1491 $cfg['Export']['format'] = 'sql';
1494 * quick/custom/custom-no-form
1496 * @global string $cfg['Export']['format']
1498 $cfg['Export']['method'] = 'quick';
1501 * none/zip/gzip
1503 * @global string $cfg['Export']['compression']
1505 $cfg['Export']['compression'] = 'none';
1508 * Whether to LOCK TABLES before exporting
1510 * @global boolean $cfg['Export']['lock_tables']
1512 $cfg['Export']['lock_tables'] = false;
1515 * Whether to export databases/tables as separate files
1517 * @global boolean $cfg['Export']['as_separate_files']
1519 $cfg['Export']['as_separate_files'] = false;
1522 * @global boolean $cfg['Export']['asfile']
1524 $cfg['Export']['asfile'] = true;
1527 * @global string $cfg['Export']['charset']
1529 $cfg['Export']['charset'] = '';
1532 * @global boolean $cfg['Export']['onserver']
1534 $cfg['Export']['onserver'] = false;
1537 * @global boolean $cfg['Export']['onserver_overwrite']
1539 $cfg['Export']['onserver_overwrite'] = false;
1542 * @global boolean $cfg['Export']['quick_export_onserver']
1544 $cfg['Export']['quick_export_onserver'] = false;
1547 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1549 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1552 * @global boolean $cfg['Export']['remember_file_template']
1554 $cfg['Export']['remember_file_template'] = true;
1557 * @global string $cfg['Export']['file_template_table']
1559 $cfg['Export']['file_template_table'] = '@TABLE@';
1562 * @global string $cfg['Export']['file_template_database']
1564 $cfg['Export']['file_template_database'] = '@DATABASE@';
1567 * @global string $cfg['Export']['file_template_server']
1569 $cfg['Export']['file_template_server'] = '@SERVER@';
1572 * @global string $cfg['Export']['codegen_structure_or_data']
1574 $cfg['Export']['codegen_structure_or_data'] = 'data';
1577 * @global $cfg['Export']['codegen_format']
1579 $cfg['Export']['codegen_format'] = 0;
1582 * @global boolean $cfg['Export']['ods_columns']
1584 $cfg['Export']['ods_columns'] = false;
1587 * @global string $cfg['Export']['ods_null']
1589 $cfg['Export']['ods_null'] = 'NULL';
1592 * @global string $cfg['Export']['odt_structure_or_data']
1594 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1597 * @global boolean $cfg['Export']['odt_columns']
1599 $cfg['Export']['odt_columns'] = true;
1602 * @global boolean $cfg['Export']['odt_relation']
1604 $cfg['Export']['odt_relation'] = true;
1607 * @global boolean $cfg['Export']['odt_comments']
1609 $cfg['Export']['odt_comments'] = true;
1612 * @global boolean $cfg['Export']['odt_mime']
1614 $cfg['Export']['odt_mime'] = true;
1617 * @global string $cfg['Export']['odt_null']
1619 $cfg['Export']['odt_null'] = 'NULL';
1622 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1624 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1627 * @global boolean $cfg['Export']['htmlword_columns']
1629 $cfg['Export']['htmlword_columns'] = false;
1632 * @global string $cfg['Export']['htmlword_null']
1634 $cfg['Export']['htmlword_null'] = 'NULL';
1637 * @global string $cfg['Export']['texytext_structure_or_data']
1639 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1642 * @global boolean $cfg['Export']['texytext_columns']
1644 $cfg['Export']['texytext_columns'] = false;
1647 * @global string $cfg['Export']['texytext_null']
1649 $cfg['Export']['texytext_null'] = 'NULL';
1652 * @global boolean $cfg['Export']['csv_columns']
1654 $cfg['Export']['csv_columns'] = false;
1657 * @global string $cfg['Export']['csv_structure_or_data']
1659 $cfg['Export']['csv_structure_or_data'] = 'data';
1662 * @global string $cfg['Export']['csv_null']
1664 $cfg['Export']['csv_null'] = 'NULL';
1667 * @global string $cfg['Export']['csv_separator']
1669 $cfg['Export']['csv_separator'] = ',';
1672 * @global string $cfg['Export']['csv_enclosed']
1674 $cfg['Export']['csv_enclosed'] = '"';
1677 * @global string $cfg['Export']['csv_escaped']
1679 $cfg['Export']['csv_escaped'] = '"';
1682 * @global string $cfg['Export']['csv_terminated']
1684 $cfg['Export']['csv_terminated'] = 'AUTO';
1687 * @global string $cfg['Export']['csv_removeCRLF']
1689 $cfg['Export']['csv_removeCRLF'] = false;
1692 * @global boolean $cfg['Export']['excel_columns']
1694 $cfg['Export']['excel_columns'] = true;
1697 * @global string $cfg['Export']['excel_null']
1699 $cfg['Export']['excel_null'] = 'NULL';
1702 * win/mac
1704 * @global string $cfg['Export']['excel_edition']
1706 $cfg['Export']['excel_edition'] = 'win';
1709 * @global string $cfg['Export']['excel_removeCRLF']
1711 $cfg['Export']['excel_removeCRLF'] = false;
1714 * @global string $cfg['Export']['excel_structure_or_data']
1716 $cfg['Export']['excel_structure_or_data'] = 'data';
1719 * @global string $cfg['Export']['latex_structure_or_data']
1721 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1724 * @global boolean $cfg['Export']['latex_columns']
1726 $cfg['Export']['latex_columns'] = true;
1729 * @global boolean $cfg['Export']['latex_relation']
1731 $cfg['Export']['latex_relation'] = true;
1734 * @global boolean $cfg['Export']['latex_comments']
1736 $cfg['Export']['latex_comments'] = true;
1739 * @global boolean $cfg['Export']['latex_mime']
1741 $cfg['Export']['latex_mime'] = true;
1744 * @global string $cfg['Export']['latex_null']
1746 $cfg['Export']['latex_null'] = '\textit{NULL}';
1749 * @global boolean $cfg['Export']['latex_caption']
1751 $cfg['Export']['latex_caption'] = true;
1754 * @global string $cfg['Export']['latex_structure_caption']
1756 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1759 * @global string $cfg['Export']['latex_structure_continued_caption']
1761 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
1764 * @global string $cfg['Export']['latex_data_caption']
1766 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1769 * @global string $cfg['Export']['latex_data_continued_caption']
1771 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1774 * @global string $cfg['Export']['latex_data_label']
1776 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1779 * @global string $cfg['Export']['latex_structure_label']
1781 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1784 * @global string $cfg['Export']['mediawiki_structure_or_data']
1786 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1789 * @global boolean $cfg['Export']['mediawiki_caption']
1791 $cfg['Export']['mediawiki_caption'] = true;
1794 * @global boolean $cfg['Export']['mediawiki_headers']
1796 $cfg['Export']['mediawiki_headers'] = true;
1799 * @global string $cfg['Export']['ods_structure_or_data']
1801 $cfg['Export']['ods_structure_or_data'] = 'data';
1804 * @global string $cfg['Export']['pdf_structure_or_data']
1806 $cfg['Export']['pdf_structure_or_data'] = 'data';
1809 * @global string $cfg['Export']['phparray_structure_or_data']
1811 $cfg['Export']['phparray_structure_or_data'] = 'data';
1814 * @global string $cfg['Export']['json_structure_or_data']
1816 $cfg['Export']['json_structure_or_data'] = 'data';
1819 * Export functions
1821 * @global string $cfg['Export']['json_pretty_print']
1823 $cfg['Export']['json_pretty_print'] = false;
1826 * Export functions
1828 * @global string $cfg['Export']['json_unicode']
1830 $cfg['Export']['json_unicode'] = true;
1833 * @global string $cfg['Export']['sql_structure_or_data']
1835 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1838 * @global string $cfg['Export']['sql_compatibility']
1840 $cfg['Export']['sql_compatibility'] = 'NONE';
1843 * Whether to include comments in SQL export.
1845 * @global string $cfg['Export']['sql_include_comments']
1847 $cfg['Export']['sql_include_comments'] = true;
1850 * @global boolean $cfg['Export']['sql_disable_fk']
1852 $cfg['Export']['sql_disable_fk'] = false;
1855 * @global boolean $cfg['Export']['sql_views_as_tables']
1857 $cfg['Export']['sql_views_as_tables'] = false;
1860 * @global boolean $cfg['Export']['sql_metadata']
1862 $cfg['Export']['sql_metadata'] = false;
1865 * @global boolean $cfg['Export']['sql_use_transaction']
1867 $cfg['Export']['sql_use_transaction'] = true;
1870 * @global boolean $cfg['Export']['sql_create_database']
1872 $cfg['Export']['sql_create_database'] = false;
1875 * @global boolean $cfg['Export']['sql_drop_database']
1877 $cfg['Export']['sql_drop_database'] = false;
1880 * @global boolean $cfg['Export']['sql_drop_table']
1882 $cfg['Export']['sql_drop_table'] = false;
1885 * true by default for correct behavior when dealing with exporting
1886 * of VIEWs and the stand-in table
1888 * @global boolean $cfg['Export']['sql_if_not_exists']
1890 $cfg['Export']['sql_if_not_exists'] = false;
1893 * @global boolean $cfg['Export']['sql_view_current_user']
1895 $cfg['Export']['sql_view_current_user'] = false;
1898 * @global boolean $cfg['Export']['sql_or_replace']
1900 $cfg['Export']['sql_or_replace_view'] = false;
1903 * @global boolean $cfg['Export']['sql_procedure_function']
1905 $cfg['Export']['sql_procedure_function'] = true;
1908 * @global boolean $cfg['Export']['sql_create_table']
1910 $cfg['Export']['sql_create_table'] = true;
1913 * @global boolean $cfg['Export']['sql_create_view']
1915 $cfg['Export']['sql_create_view'] = true;
1918 * @global boolean $cfg['Export']['sql_create_trigger']
1920 $cfg['Export']['sql_create_trigger'] = true;
1923 * @global boolean $cfg['Export']['sql_auto_increment']
1925 $cfg['Export']['sql_auto_increment'] = true;
1928 * @global boolean $cfg['Export']['sql_backquotes']
1930 $cfg['Export']['sql_backquotes'] = true;
1933 * @global boolean $cfg['Export']['sql_dates']
1935 $cfg['Export']['sql_dates'] = false;
1938 * @global boolean $cfg['Export']['sql_relation']
1940 $cfg['Export']['sql_relation'] = false;
1943 * @global boolean $cfg['Export']['sql_truncate']
1945 $cfg['Export']['sql_truncate'] = false;
1948 * @global boolean $cfg['Export']['sql_delayed']
1950 $cfg['Export']['sql_delayed'] = false;
1953 * @global boolean $cfg['Export']['sql_ignore']
1955 $cfg['Export']['sql_ignore'] = false;
1958 * Export time in UTC.
1960 * @global boolean $cfg['Export']['sql_utc_time']
1962 $cfg['Export']['sql_utc_time'] = true;
1965 * @global boolean $cfg['Export']['sql_hex_for_binary']
1967 $cfg['Export']['sql_hex_for_binary'] = true;
1970 * insert/update/replace
1972 * @global string $cfg['Export']['sql_type']
1974 $cfg['Export']['sql_type'] = 'INSERT';
1977 * @global integer $cfg['Export']['sql_max_query_size']
1979 $cfg['Export']['sql_max_query_size'] = 50000;
1982 * @global boolean $cfg['Export']['sql_mime']
1984 $cfg['Export']['sql_mime'] = false;
1987 * \n is replaced by new line
1989 * @global string $cfg['Export']['sql_header_comment']
1991 $cfg['Export']['sql_header_comment'] = '';
1994 * Whether to use complete inserts, extended inserts, both, or neither
1996 * @global string $cfg['Export']['sql_insert_syntax']
1998 $cfg['Export']['sql_insert_syntax'] = 'both';
2001 * @global string $cfg['Export']['pdf_report_title']
2003 $cfg['Export']['pdf_report_title'] = '';
2006 * @global string $cfg['Export']['xml_structure_or_data']
2008 $cfg['Export']['xml_structure_or_data'] = 'data';
2011 * Export schema for each structure
2013 * @global string $cfg['Export']['xml_export_struc']
2015 $cfg['Export']['xml_export_struc'] = true;
2018 * Export events
2020 * @global string $cfg['Export']['xml_export_events']
2022 $cfg['Export']['xml_export_events'] = true;
2025 * Export functions
2027 * @global string $cfg['Export']['xml_export_functions']
2029 $cfg['Export']['xml_export_functions'] = true;
2032 * Export procedures
2034 * @global string $cfg['Export']['xml_export_procedures']
2036 $cfg['Export']['xml_export_procedures'] = true;
2039 * Export schema for each table
2041 * @global string $cfg['Export']['xml_export_tables']
2043 $cfg['Export']['xml_export_tables'] = true;
2046 * Export triggers
2048 * @global string $cfg['Export']['xml_export_triggers']
2050 $cfg['Export']['xml_export_triggers'] = true;
2053 * Export views
2055 * @global string $cfg['Export']['xml_export_views']
2057 $cfg['Export']['xml_export_views'] = true;
2060 * Export contents data
2062 * @global string $cfg['Export']['xml_export_contents']
2064 $cfg['Export']['xml_export_contents'] = true;
2067 * @global string $cfg['Export']['yaml_structure_or_data']
2069 $cfg['Export']['yaml_structure_or_data'] = 'data';
2071 /*******************************************************************************
2072 * Import defaults
2074 $cfg['Import'] = [];
2077 * @global string $cfg['Import']['format']
2079 $cfg['Import']['format'] = 'sql';
2082 * Default charset for import.
2084 * @global string $cfg['Import']['charset']
2086 $cfg['Import']['charset'] = '';
2089 * @global boolean $cfg['Import']['allow_interrupt']
2091 $cfg['Import']['allow_interrupt'] = true;
2094 * @global integer $cfg['Import']['skip_queries']
2096 $cfg['Import']['skip_queries'] = 0;
2099 * @global string $cfg['Import']['sql_compatibility']
2101 $cfg['Import']['sql_compatibility'] = 'NONE';
2104 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
2106 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
2109 * @global string $cfg['Import']['sql_read_as_multibytes']
2111 $cfg['Import']['sql_read_as_multibytes'] = false;
2114 * @global boolean $cfg['Import']['csv_replace']
2116 $cfg['Import']['csv_replace'] = false;
2119 * @global boolean $cfg['Import']['csv_ignore']
2121 $cfg['Import']['csv_ignore'] = false;
2124 * @global string $cfg['Import']['csv_terminated']
2126 $cfg['Import']['csv_terminated'] = ',';
2129 * @global string $cfg['Import']['csv_enclosed']
2131 $cfg['Import']['csv_enclosed'] = '"';
2134 * @global string $cfg['Import']['csv_escaped']
2136 $cfg['Import']['csv_escaped'] = '"';
2139 * @global string $cfg['Import']['csv_new_line']
2141 $cfg['Import']['csv_new_line'] = 'auto';
2144 * @global string $cfg['Import']['csv_columns']
2146 $cfg['Import']['csv_columns'] = '';
2149 * @global string $cfg['Import']['csv_col_names']
2151 $cfg['Import']['csv_col_names'] = false;
2154 * @global boolean $cfg['Import']['ldi_replace']
2156 $cfg['Import']['ldi_replace'] = false;
2159 * @global boolean $cfg['Import']['ldi_ignore']
2161 $cfg['Import']['ldi_ignore'] = false;
2164 * @global string $cfg['Import']['ldi_terminated']
2166 $cfg['Import']['ldi_terminated'] = ';';
2169 * @global string $cfg['Import']['ldi_enclosed']
2171 $cfg['Import']['ldi_enclosed'] = '"';
2174 * @global string $cfg['Import']['ldi_escaped']
2176 $cfg['Import']['ldi_escaped'] = '\\';
2179 * @global string $cfg['Import']['ldi_new_line']
2181 $cfg['Import']['ldi_new_line'] = 'auto';
2184 * @global string $cfg['Import']['ldi_columns']
2186 $cfg['Import']['ldi_columns'] = '';
2189 * 'auto' for auto-detection, true or false for forcing
2191 * @global string $cfg['Import']['ldi_local_option']
2193 $cfg['Import']['ldi_local_option'] = 'auto';
2196 * @global string $cfg['Import']['ods_col_names']
2198 $cfg['Import']['ods_col_names'] = false;
2201 * @global string $cfg['Import']['ods_empty_rows']
2203 $cfg['Import']['ods_empty_rows'] = true;
2206 * @global string $cfg['Import']['ods_recognize_percentages']
2208 $cfg['Import']['ods_recognize_percentages'] = true;
2211 * @global string $cfg['Import']['ods_recognize_currency']
2213 $cfg['Import']['ods_recognize_currency'] = true;
2215 /*******************************************************************************
2216 * Schema export defaults
2218 $cfg['Schema'] = [];
2221 * pdf/eps/dia/svg
2223 * @global string $cfg['Schema']['format']
2225 $cfg['Schema']['format'] = 'pdf';
2228 * @global string $cfg['Schema']['pdf_show_color']
2230 $cfg['Schema']['pdf_show_color'] = true;
2233 * @global string $cfg['Schema']['pdf_show_keys']
2235 $cfg['Schema']['pdf_show_keys'] = false;
2238 * @global string $cfg['Schema']['pdf_all_tables_same_width']
2240 $cfg['Schema']['pdf_all_tables_same_width'] = false;
2243 * L/P
2245 * @global string $cfg['Schema']['pdf_orientation']
2247 $cfg['Schema']['pdf_orientation'] = 'L';
2250 * @global string $cfg['Schema']['pdf_paper']
2252 $cfg['Schema']['pdf_paper'] = 'A4';
2255 * @global string $cfg['Schema']['pdf_show_grid']
2257 $cfg['Schema']['pdf_show_grid'] = false;
2260 * @global string $cfg['Schema']['pdf_with_doc']
2262 $cfg['Schema']['pdf_with_doc'] = true;
2265 * @global string $cfg['Schema']['pdf_table_order']
2267 $cfg['Schema']['pdf_table_order'] = '';
2270 * @global string $cfg['Schema']['dia_show_color']
2272 $cfg['Schema']['dia_show_color'] = true;
2275 * @global string $cfg['Schema']['dia_show_keys']
2277 $cfg['Schema']['dia_show_keys'] = false;
2280 * L/P
2282 * @global string $cfg['Schema']['dia_orientation']
2284 $cfg['Schema']['dia_orientation'] = 'L';
2287 * @global string $cfg['Schema']['dia_paper']
2289 $cfg['Schema']['dia_paper'] = 'A4';
2292 * @global string $cfg['Schema']['eps_show_color']
2294 $cfg['Schema']['eps_show_color'] = true;
2297 * @global string $cfg['Schema']['eps_show_keys']
2299 $cfg['Schema']['eps_show_keys'] = false;
2302 * @global string $cfg['Schema']['eps_all_tables_same_width']
2304 $cfg['Schema']['eps_all_tables_same_width'] = false;
2307 * L/P
2309 * @global string $cfg['Schema']['eps_orientation']
2311 $cfg['Schema']['eps_orientation'] = 'L';
2314 * @global string $cfg['Schema']['svg_show_color']
2316 $cfg['Schema']['svg_show_color'] = true;
2319 * @global string $cfg['Schema']['svg_show_keys']
2321 $cfg['Schema']['svg_show_keys'] = false;
2324 * @global string $cfg['Schema']['svg_all_tables_same_width']
2326 $cfg['Schema']['svg_all_tables_same_width'] = false;
2328 /*******************************************************************************
2329 * PDF options
2333 * @global array $cfg['PDFPageSizes']
2335 $cfg['PDFPageSizes'] = [
2336 'A3',
2337 'A4',
2338 'A5',
2339 'letter',
2340 'legal',
2344 * @global string $cfg['PDFDefaultPageSize']
2346 $cfg['PDFDefaultPageSize'] = 'A4';
2349 /*******************************************************************************
2350 * Language and character set conversion settings
2354 * Default language to use, if not browser-defined or user-defined
2356 * @global string $cfg['DefaultLang']
2358 $cfg['DefaultLang'] = 'en';
2361 * Default connection collation
2363 * @global string $cfg['DefaultConnectionCollation']
2365 $cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci';
2368 * Force: always use this language, e.g. 'en'
2370 * @global string $cfg['Lang']
2372 $cfg['Lang'] = '';
2375 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2376 * English only
2378 * @global string $cfg['FilterLanguages']
2380 $cfg['FilterLanguages'] = '';
2383 * You can select here which functions will be used for character set conversion.
2384 * Possible values are:
2385 * auto - automatically use available one (first is tested iconv, then
2386 * recode)
2387 * iconv - use iconv or libiconv functions
2388 * recode - use recode_string function
2389 * mb - use mbstring extension
2390 * none - disable encoding conversion
2392 * @global string $cfg['RecodingEngine']
2394 $cfg['RecodingEngine'] = 'auto';
2397 * Specify some parameters for iconv used in character set conversion. See iconv
2398 * documentation for details:
2399 * https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html
2401 * @global string $cfg['IconvExtraParams']
2403 $cfg['IconvExtraParams'] = '//TRANSLIT';
2406 * Available character sets for MySQL conversion. currently contains all which could
2407 * be found in lang/* files and few more.
2408 * Character sets will be shown in same order as here listed, so if you frequently
2409 * use some of these move them to the top.
2411 * @global array $cfg['AvailableCharsets']
2413 $cfg['AvailableCharsets'] = [
2414 'iso-8859-1',
2415 'iso-8859-2',
2416 'iso-8859-3',
2417 'iso-8859-4',
2418 'iso-8859-5',
2419 'iso-8859-6',
2420 'iso-8859-7',
2421 'iso-8859-8',
2422 'iso-8859-9',
2423 'iso-8859-10',
2424 'iso-8859-11',
2425 'iso-8859-12',
2426 'iso-8859-13',
2427 'iso-8859-14',
2428 'iso-8859-15',
2429 'windows-1250',
2430 'windows-1251',
2431 'windows-1252',
2432 'windows-1256',
2433 'windows-1257',
2434 'koi8-r',
2435 'big5',
2436 'gb2312',
2437 'utf-16',
2438 'utf-8',
2439 'utf-7',
2440 'x-user-defined',
2441 'euc-jp',
2442 'ks_c_5601-1987',
2443 'tis-620',
2444 'SHIFT_JIS',
2445 'SJIS',
2446 'SJIS-win',
2450 /*******************************************************************************
2451 * Customization & design
2453 * The graphical settings are now located in themes/theme-name/scss/_variables.scss
2457 * enable the left panel pointer
2459 * @global boolean $cfg['NavigationTreePointerEnable']
2461 $cfg['NavigationTreePointerEnable'] = true;
2464 * enable the browse pointer
2466 * @global boolean $cfg['BrowsePointerEnable']
2468 $cfg['BrowsePointerEnable'] = true;
2471 * enable the browse marker
2473 * @global boolean $cfg['BrowseMarkerEnable']
2475 $cfg['BrowseMarkerEnable'] = true;
2478 * textarea size (columns) in edit mode
2479 * (this value will be emphasized (*2) for SQL
2480 * query textareas and (*1.25) for query window)
2482 * @global integer $cfg['TextareaCols']
2484 $cfg['TextareaCols'] = 40;
2487 * textarea size (rows) in edit mode
2489 * @global integer $cfg['TextareaRows']
2491 $cfg['TextareaRows'] = 15;
2494 * double size of textarea size for LONGTEXT columns
2496 * @global boolean $cfg['LongtextDoubleTextarea']
2498 $cfg['LongtextDoubleTextarea'] = true;
2501 * auto-select when clicking in the textarea of the query-box
2503 * @global boolean $cfg['TextareaAutoSelect']
2505 $cfg['TextareaAutoSelect'] = false;
2508 * textarea size (columns) for CHAR/VARCHAR
2510 * @global integer $cfg['CharTextareaCols']
2512 $cfg['CharTextareaCols'] = 40;
2515 * textarea size (rows) for CHAR/VARCHAR
2517 * @global integer $cfg['CharTextareaRows']
2519 $cfg['CharTextareaRows'] = 2;
2522 * Max field data length in browse mode for all non-numeric fields
2524 * @global integer $cfg['LimitChars']
2526 $cfg['LimitChars'] = 50;
2529 * Where to show the edit/copy/delete links in browse mode
2530 * Possible values are 'left', 'right', 'both' and 'none'.
2532 * @global string $cfg['RowActionLinks']
2534 $cfg['RowActionLinks'] = 'left';
2537 * Whether to show row links (Edit, Copy, Delete) and checkboxes for
2538 * multiple row operations even when the selection does not have a unique key.
2540 * @global boolean $cfg['RowActionLinksWithoutUnique']
2542 $cfg['RowActionLinksWithoutUnique'] = false;
2545 * Default sort order by primary key.
2547 * @global string $cfg['TablePrimaryKeyOrder']
2549 $cfg['TablePrimaryKeyOrder'] = 'NONE';
2552 * remember the last way a table sorted
2554 * @global string $cfg['RememberSorting']
2556 $cfg['RememberSorting'] = true;
2559 * shows column comments in 'browse' mode.
2561 * @global boolean $cfg['ShowBrowseComments']
2563 $cfg['ShowBrowseComments'] = true;
2566 * shows column comments in 'table property' mode.
2568 * @global boolean $cfg['ShowPropertyComments']
2570 $cfg['ShowPropertyComments'] = true;
2573 * repeat header names every X cells? (0 = deactivate)
2575 * @global integer $cfg['RepeatCells']
2577 $cfg['RepeatCells'] = 100;
2580 * Set to true if you want DB-based query history.If false, this utilizes
2581 * JS-routines to display query history (lost by window close)
2583 * @global boolean $cfg['QueryHistoryDB']
2585 $cfg['QueryHistoryDB'] = false;
2588 * When using DB-based query history, how many entries should be kept?
2590 * @global integer $cfg['QueryHistoryMax']
2592 $cfg['QueryHistoryMax'] = 25;
2595 * Use MIME-Types (stored in column comments table) for
2597 * @global boolean $cfg['BrowseMIME']
2599 $cfg['BrowseMIME'] = true;
2602 * When approximate count < this, PMA will get exact count for table rows.
2604 * @global integer $cfg['MaxExactCount']
2606 $cfg['MaxExactCount'] = 50000;
2609 * Zero means that no row count is done for views; see the doc
2611 * @global integer $cfg['MaxExactCountViews']
2613 $cfg['MaxExactCountViews'] = 0;
2616 * Sort table and database in natural order
2618 * @global boolean $cfg['NaturalOrder']
2620 $cfg['NaturalOrder'] = true;
2623 * Initial state for sliders
2624 * (open | closed | disabled)
2626 * @global string $cfg['InitialSlidersState']
2628 $cfg['InitialSlidersState'] = 'closed';
2631 * User preferences: disallow these settings
2632 * For possible setting names look in libraries/config/user_preferences.forms.php
2634 * @global array $cfg['UserprefsDisallow']
2636 $cfg['UserprefsDisallow'] = [];
2639 * User preferences: enable the Developer tab
2641 $cfg['UserprefsDeveloperTab'] = false;
2643 /*******************************************************************************
2644 * Window title settings
2648 * title of browser window when a table is selected
2650 * @global string $cfg['TitleTable']
2652 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2655 * title of browser window when a database is selected
2657 * @global string $cfg['TitleDatabase']
2659 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2662 * title of browser window when a server is selected
2664 * @global string $cfg['TitleServer']
2666 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2669 * title of browser window when nothing is selected
2671 * @global string $cfg['TitleDefault']
2673 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2676 /*******************************************************************************
2677 * theme manager
2681 * if you want to use selectable themes and if ThemesPath not empty
2682 * set it to true, else set it to false (default is false);
2684 * @global boolean $cfg['ThemeManager']
2686 $cfg['ThemeManager'] = true;
2689 * set up default theme, you can set up here an valid
2690 * path to themes or 'original' for the original pma-theme
2692 * @global string $cfg['ThemeDefault']
2694 $cfg['ThemeDefault'] = 'pmahomme';
2697 * allow different theme for each configured server
2699 * @global boolean $cfg['ThemePerServer']
2701 $cfg['ThemePerServer'] = false;
2705 * Default query for table
2707 * @global string $cfg['DefaultQueryTable']
2709 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2712 * Default query for database
2714 * @global string $cfg['DefaultQueryDatabase']
2716 $cfg['DefaultQueryDatabase'] = '';
2719 /*******************************************************************************
2720 * SQL Query box settings
2721 * These are the links display in all of the SQL Query boxes
2723 * @global array $cfg['SQLQuery']
2725 $cfg['SQLQuery'] = [];
2728 * Display an "Edit" link on the results page to change a query
2730 * @global boolean $cfg['SQLQuery']['Edit']
2732 $cfg['SQLQuery']['Edit'] = true;
2735 * Display an "Explain SQL" link on the results page
2737 * @global boolean $cfg['SQLQuery']['Explain']
2739 $cfg['SQLQuery']['Explain'] = true;
2742 * Display a "Create PHP code" link on the results page to wrap a query in PHP
2744 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2746 $cfg['SQLQuery']['ShowAsPHP'] = true;
2749 * Display a "Refresh" link on the results page
2751 * @global boolean $cfg['SQLQuery']['Refresh']
2753 $cfg['SQLQuery']['Refresh'] = true;
2756 * Enables autoComplete for table & column names in SQL queries
2758 * default = 'true'
2760 $cfg['EnableAutocompleteForTablesAndColumns'] = true;
2763 /*******************************************************************************
2764 * Web server upload/save/import directories
2768 * Directory for uploaded files that can be executed by phpMyAdmin.
2769 * For example './upload'. Leave empty for no upload directory support.
2770 * Use %u for username inclusion.
2772 * @global string $cfg['UploadDir']
2774 $cfg['UploadDir'] = '';
2777 * Directory where phpMyAdmin can save exported data on server.
2778 * For example './save'. Leave empty for no save directory support.
2779 * Use %u for username inclusion.
2781 * @global string $cfg['SaveDir']
2783 $cfg['SaveDir'] = '';
2786 * Directory where phpMyAdmin can save temporary files.
2788 * @global string $cfg['TempDir']
2790 if (defined('TEMP_DIR')) {
2791 $cfg['TempDir'] = TEMP_DIR;
2792 } else {
2793 $cfg['TempDir'] = ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR;
2797 * Misc. settings
2801 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2802 * which is the only safe way to determine GD version.
2804 * @global string $cfg['GD2Available']
2806 $cfg['GD2Available'] = 'auto';
2809 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2811 * @global array $cfg['TrustedProxies']
2813 $cfg['TrustedProxies'] = [];
2816 * We normally check the permissions on the configuration file to ensure
2817 * it's not world writable. However, phpMyAdmin could be installed on
2818 * a NTFS filesystem mounted on a non-Windows server, in which case the
2819 * permissions seems wrong but in fact cannot be detected. In this case
2820 * a sysadmin would set the following to false.
2822 $cfg['CheckConfigurationPermissions'] = true;
2825 * Limit for length of URL in links. When length would be above this limit, it
2826 * is replaced by form with button.
2827 * This is required as some web servers (IIS) have problems with long URLs.
2828 * The recommended limit is 2000
2829 * (see https://www.boutell.com/newfaq/misc/urllength.html) but we put
2830 * 1000 to accommodate Suhosin, see bug #3358750.
2832 $cfg['LinkLengthLimit'] = 1000;
2835 * Additional string to allow in CSP headers.
2837 $cfg['CSPAllow'] = '';
2840 * Disable the table maintenance mass operations, like optimizing or
2841 * repairing the selected tables of a database. An accidental execution
2842 * of such a maintenance task can enormously slow down a bigger database.
2844 $cfg['DisableMultiTableMaintenance'] = false;
2847 * Whether or not to query the user before sending the error report to
2848 * the phpMyAdmin team when a JavaScript error occurs
2850 * Available options
2851 * (ask | always | never)
2853 * @global string $cfg['SendErrorReports']
2855 $cfg['SendErrorReports'] = 'ask';
2858 * Whether Enter or Ctrl+Enter executes queries in the console.
2860 * @global boolean $cfg['ConsoleEnterExecutes']
2862 $cfg['ConsoleEnterExecutes'] = false;
2865 * Zero Configuration mode.
2867 * @global boolean $cfg['ZeroConf']
2869 $cfg['ZeroConf'] = true;
2871 /*******************************************************************************
2872 * Developers ONLY!
2874 * @global array $cfg['DBG']
2876 $cfg['DBG'] = [];
2879 * Output executed queries and their execution times
2881 * @global boolean $cfg['DBG']['sql']
2883 $cfg['DBG']['sql'] = false;
2886 * Log executed queries and their execution times to syslog
2888 * @global boolean $cfg['DBG']['sqllog']
2890 $cfg['DBG']['sqllog'] = false;
2893 * Enable to let server present itself as demo server.
2895 * @global boolean $cfg['DBG']['demo']
2897 $cfg['DBG']['demo'] = false;
2900 * Enable Simple two-factor authentication
2902 * @global boolean $cfg['DBG']['simple2fa']
2904 $cfg['DBG']['simple2fa'] = false;
2907 * Sets the working environment
2909 * This only needs to be changed when you are developing phpMyAdmin itself.
2910 * The development mode may display debug information in some places.
2912 * Possible values are 'production' or 'development'
2914 $cfg['environment'] = 'production';
2916 /*******************************************************************************
2917 * MySQL settings
2921 * Default functions for above defined groups
2923 * @global array $cfg['DefaultFunctions']
2925 $cfg['DefaultFunctions'] = [
2926 'FUNC_CHAR' => '',
2927 'FUNC_DATE' => '',
2928 'FUNC_NUMBER' => '',
2929 'FUNC_SPATIAL' => 'GeomFromText',
2930 'FUNC_UUID' => 'UUID',
2931 'first_timestamp' => 'NOW',
2935 * Max rows retrieved for zoom search
2937 $cfg['maxRowPlotLimit'] = 500;
2940 * Show Git revision if applicable
2942 * @global boolean $cfg['ShowGitRevision']
2944 $cfg['ShowGitRevision'] = true;
2947 * MySQL minimal version required
2949 * @global array $cfg['MysqlMinVersion']
2951 $cfg['MysqlMinVersion'] = [
2952 'internal' => 50500,
2953 'human' => '5.5.0',
2957 * Disable shortcuts
2959 * @global array $cfg['DisableShortcutKeys']
2961 $cfg['DisableShortcutKeys'] = false;
2964 * Console configuration
2966 * This is mostly meant for user preferences.
2968 $cfg['Console'] = [
2969 'StartHistory' => false,
2970 'AlwaysExpand' => false,
2971 'CurrentQuery' => true,
2972 'EnterExecutes' => false,
2973 'DarkTheme' => false,
2974 'Mode' => 'info',
2975 'Height' => 92,
2976 'GroupQueries' => false,
2977 'OrderBy' => 'exec',
2978 'Order' => 'asc',
2982 /*******************************************************************************
2983 * Default options for transformations
2987 * Initialize default transformations array
2989 * @global array $cfg['DefaultTransformations']
2991 $cfg['DefaultTransformations'] = [];
2994 * Default transformations for Substring
2996 * @global array $cfg['DefaultTransformations']['Substring']
2998 $cfg['DefaultTransformations']['Substring'] = [
3000 'all',
3001 '…',
3005 * Default transformations for Bool2Text
3007 * @global array $cfg['DefaultTransformations']['Bool2Text']
3009 $cfg['DefaultTransformations']['Bool2Text'] = [
3010 'T',
3011 'F',
3015 * Default transformations for External
3017 * @global array $cfg['DefaultTransformations']['External']
3019 $cfg['DefaultTransformations']['External'] = [
3021 '-f /dev/null -i -wrap -q',
3027 * Default transformations for PreApPend
3029 * @global array $cfg['DefaultTransformations']['PreApPend']
3031 $cfg['DefaultTransformations']['PreApPend'] = [
3037 * Default transformations for Hex
3039 * @global array $cfg['DefaultTransformations']['Hex']
3041 $cfg['DefaultTransformations']['Hex'] = ['2'];
3044 * Default transformations for DateFormat
3046 * @global array $cfg['DefaultTransformations']['DateFormat']
3048 $cfg['DefaultTransformations']['DateFormat'] = [
3051 'local',
3055 * Set default for FirstDayOfCalendar
3057 * @global integer $cfg['FirstDayOfCalendar']
3059 $cfg['FirstDayOfCalendar'] = 0;
3062 * Default transformations for Inline
3064 * @global array $cfg['DefaultTransformations']['Inline']
3066 $cfg['DefaultTransformations']['Inline'] = [
3067 '100',
3068 100,
3070 $cfg['DefaultTransformations']['Inline']['wrapper_link'] = null;
3071 $cfg['DefaultTransformations']['Inline']['wrapper_params'] = [];
3074 * Default transformations for TextImageLink
3076 * @global array $cfg['DefaultTransformations']['TextImageLink']
3078 $cfg['DefaultTransformations']['TextImageLink'] = [
3079 null,
3080 100,
3085 * Default transformations for TextLink
3087 * @global array $cfg['DefaultTransformations']['TextLink']
3089 $cfg['DefaultTransformations']['TextLink'] = [
3090 null,
3091 null,
3092 null,