You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
3125 lines
71 KiB
3125 lines
71 KiB
<?php |
|
/** |
|
* <code> |
|
* N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !! |
|
* NN N O O !! D D O O NN N O O T E D D I T !! |
|
* N N N O O !! D D O O N N N O O T EEEE D D I T !! |
|
* N NN O O D D O O N NN O O T E D D I T |
|
* N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !! |
|
* </code> |
|
* |
|
* DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! |
|
* |
|
* phpMyAdmin default configuration, you can copy values from here to your |
|
* config.inc.php |
|
* |
|
* All directives are explained in the documentation |
|
*/ |
|
|
|
declare(strict_types=1); |
|
|
|
/** |
|
* Your phpMyAdmin URL. |
|
* |
|
* Complete the variable below with the full URL ie |
|
* https://example.com/path_to_your_phpMyAdmin_directory/ |
|
* |
|
* It must contain characters that are valid for a URL, and the path is |
|
* case sensitive on some Web servers, for example Unix-based servers. |
|
* |
|
* In most cases you can leave this variable empty, as the correct value |
|
* will be detected automatically. However, we recommend that you do |
|
* test to see that the auto-detection code works in your system. A good |
|
* test is to browse a table, then edit a row and save it. There will be |
|
* an error message if phpMyAdmin cannot auto-detect the correct value. |
|
* |
|
* @global string $cfg['PmaAbsoluteUri'] |
|
* @psalm-suppress PossiblyUndefinedGlobalVariable |
|
*/ |
|
$cfg['PmaAbsoluteUri'] = ''; |
|
|
|
/** |
|
* Configure authentication logging destination |
|
* |
|
* @global string $cfg['AuthLog'] |
|
*/ |
|
$cfg['AuthLog'] = 'auto'; |
|
|
|
/** |
|
* Whether to log successful authentication attempts |
|
* |
|
* @global boolean $cfg['AuthLogSuccess'] |
|
*/ |
|
$cfg['AuthLogSuccess'] = false; |
|
|
|
/** |
|
* Disable the default warning that is displayed on the DB Details Structure page if |
|
* any of the required Tables for the configuration storage could not be found |
|
* |
|
* @global boolean $cfg['PmaNoRelation_DisableWarning'] |
|
*/ |
|
$cfg['PmaNoRelation_DisableWarning'] = false; |
|
|
|
/** |
|
* Disable the default warning that is displayed if Suhosin is detected |
|
* |
|
* @global boolean $cfg['SuhosinDisableWarning'] |
|
*/ |
|
$cfg['SuhosinDisableWarning'] = false; |
|
|
|
/** |
|
* Disable the default warning that is displayed if session.gc_maxlifetime |
|
* is less than `LoginCookieValidity` |
|
* |
|
* @global boolean $cfg['LoginCookieValidityDisableWarning'] |
|
*/ |
|
$cfg['LoginCookieValidityDisableWarning'] = false; |
|
|
|
/** |
|
* Disable the default warning about MySQL reserved words in column names |
|
* |
|
* @global boolean $cfg['ReservedWordDisableWarning'] |
|
*/ |
|
$cfg['ReservedWordDisableWarning'] = false; |
|
|
|
/** |
|
* Show warning about incomplete translations on certain threshold. |
|
* |
|
* @global boolean $cfg['TranslationWarningThreshold'] |
|
*/ |
|
$cfg['TranslationWarningThreshold'] = 80; |
|
|
|
/** |
|
* Allows phpMyAdmin to be included from a other document in a frame; |
|
* setting this to true is a potential security hole. Setting this to |
|
* 'sameorigin' prevents phpMyAdmin to be included from another document |
|
* in a frame, unless that document belongs to the same domain. |
|
* |
|
* @global boolean|string $cfg['AllowThirdPartyFraming'] |
|
*/ |
|
$cfg['AllowThirdPartyFraming'] = false; |
|
|
|
/** |
|
* The 'cookie' auth_type uses AES algorithm to encrypt the password. If |
|
* at least one server configuration uses 'cookie' auth_type, enter here a |
|
* pass phrase that will be used by AES. The maximum length seems to be 46 |
|
* characters. |
|
* |
|
* @global string $cfg['blowfish_secret'] |
|
*/ |
|
$cfg['blowfish_secret'] = ''; |
|
|
|
|
|
/******************************************************************************* |
|
* Server(s) configuration |
|
* |
|
* The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use |
|
* $cfg['Servers'][0]. You can disable a server configuration entry by setting host |
|
* to ''. If you want more than one server, just copy following section |
|
* (including $i incrementation) several times. There is no need to define |
|
* full server array, just define values you need to change. |
|
* |
|
* @global array $cfg['Servers'] |
|
*/ |
|
$cfg['Servers'] = []; |
|
|
|
$i = 1; |
|
|
|
/** |
|
* MySQL hostname or IP address |
|
* |
|
* @global string $cfg['Servers'][$i]['host'] |
|
*/ |
|
$cfg['Servers'][$i]['host'] = 'localhost'; |
|
|
|
/** |
|
* MySQL port - leave blank for default port |
|
* |
|
* @global string $cfg['Servers'][$i]['port'] |
|
*/ |
|
$cfg['Servers'][$i]['port'] = ''; |
|
|
|
/** |
|
* Path to the socket - leave blank for default socket |
|
* |
|
* @global string $cfg['Servers'][$i]['socket'] |
|
*/ |
|
$cfg['Servers'][$i]['socket'] = ''; |
|
|
|
/** |
|
* Use SSL for connecting to MySQL server? |
|
* |
|
* @global boolean $cfg['Servers'][$i]['ssl'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl'] = false; |
|
|
|
/** |
|
* Path to the key file when using SSL for connecting to the MySQL server |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_key'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_key'] = null; |
|
|
|
/** |
|
* Path to the cert file when using SSL for connecting to the MySQL server |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_cert'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_cert'] = null; |
|
|
|
/** |
|
* Path to the CA file when using SSL for connecting to the MySQL server |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_ca'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_ca'] = null; |
|
|
|
/** |
|
* Directory containing trusted SSL CA certificates in PEM format |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_ca_path'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_ca_path'] = null; |
|
|
|
/** |
|
* List of allowable ciphers for SSL connections to the MySQL server |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_ciphers'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_ciphers'] = null; |
|
|
|
/** |
|
* MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the |
|
* peer_name of the SSL certifcate |
|
* For most self-signed certificates this is a problem. Setting this to false |
|
* will disable the check and allow the connection (PHP 5.6.16 or later) |
|
* |
|
* @link https://bugs.php.net/68344 |
|
* |
|
* @global string $cfg['Servers'][$i]['ssl_verify'] |
|
*/ |
|
$cfg['Servers'][$i]['ssl_verify'] = true; |
|
|
|
/** |
|
* Use compressed protocol for the MySQL connection |
|
* |
|
* @global boolean $cfg['Servers'][$i]['compress'] |
|
*/ |
|
$cfg['Servers'][$i]['compress'] = false; |
|
|
|
/** |
|
* MySQL control host. This permits to use a host different than the |
|
* main host, for the phpMyAdmin configuration storage. If left empty, |
|
* $cfg['Servers'][$i]['host'] is used instead. |
|
* |
|
* @global string $cfg['Servers'][$i]['controlhost'] |
|
*/ |
|
$cfg['Servers'][$i]['controlhost'] = ''; |
|
|
|
/** |
|
* MySQL control port. This permits to use a port different than the |
|
* main port, for the phpMyAdmin configuration storage. If left empty, |
|
* $cfg['Servers'][$i]['port'] is used instead. |
|
* |
|
* @global string $cfg['Servers'][$i]['controlport'] |
|
*/ |
|
$cfg['Servers'][$i]['controlport'] = ''; |
|
|
|
/** |
|
* MySQL control user settings (this user must have read-only |
|
* access to the "mysql/user" and "mysql/db" tables). The controluser is also |
|
* used for all relational features (pmadb) |
|
* |
|
* @global string $cfg['Servers'][$i]['controluser'] |
|
*/ |
|
$cfg['Servers'][$i]['controluser'] = ''; |
|
|
|
/** |
|
* MySQL control user settings (this user must have read-only |
|
* access to the "mysql/user" and "mysql/db" tables). The controluser is also |
|
* used for all relational features (pmadb) |
|
* |
|
* @global string $cfg['Servers'][$i]['controlpass'] |
|
*/ |
|
$cfg['Servers'][$i]['controlpass'] = ''; |
|
|
|
/** |
|
* Authentication method (valid choices: config, http, signon or cookie) |
|
* |
|
* @global string $cfg['Servers'][$i]['auth_type'] |
|
*/ |
|
$cfg['Servers'][$i]['auth_type'] = 'cookie'; |
|
|
|
/** |
|
* HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type) |
|
* |
|
* @global string $cfg['Servers'][$i]['auth_http_realm'] |
|
*/ |
|
$cfg['Servers'][$i]['auth_http_realm'] = ''; |
|
|
|
/** |
|
* MySQL user |
|
* |
|
* @global string $cfg['Servers'][$i]['user'] |
|
*/ |
|
$cfg['Servers'][$i]['user'] = 'root'; |
|
|
|
/** |
|
* MySQL password (only needed with 'config' auth_type) |
|
* |
|
* @global string $cfg['Servers'][$i]['password'] |
|
*/ |
|
$cfg['Servers'][$i]['password'] = ''; |
|
|
|
/** |
|
* Session to use for 'signon' authentication method |
|
* |
|
* @global string $cfg['Servers'][$i]['SignonSession'] |
|
*/ |
|
$cfg['Servers'][$i]['SignonSession'] = ''; |
|
|
|
/** |
|
* Cookie params to match session to use for 'signon' authentication method |
|
* It should be an associative array matching result of session_get_cookie_params() in other system |
|
* |
|
* @global array $cfg['Servers'][$i]['SignonCookieParams'] |
|
*/ |
|
$cfg['Servers'][$i]['SignonCookieParams'] = []; |
|
|
|
/** |
|
* PHP script to use for 'signon' authentication method |
|
* |
|
* @global string $cfg['Servers'][$i]['SignonScript'] |
|
*/ |
|
$cfg['Servers'][$i]['SignonScript'] = ''; |
|
|
|
/** |
|
* URL where to redirect user to login for 'signon' authentication method |
|
* |
|
* @global string $cfg['Servers'][$i]['SignonURL'] |
|
*/ |
|
$cfg['Servers'][$i]['SignonURL'] = ''; |
|
|
|
/** |
|
* URL where to redirect user after logout |
|
* |
|
* @global string $cfg['Servers'][$i]['LogoutURL'] |
|
*/ |
|
$cfg['Servers'][$i]['LogoutURL'] = ''; |
|
|
|
/** |
|
* If set to a db-name, only this db is displayed in navigation panel |
|
* It may also be an array of db-names |
|
* |
|
* @global string $cfg['Servers'][$i]['only_db'] |
|
*/ |
|
$cfg['Servers'][$i]['only_db'] = ''; |
|
|
|
/** |
|
* Database name to be hidden from listings |
|
* |
|
* @global string $cfg['Servers'][$i]['hide_db'] |
|
*/ |
|
$cfg['Servers'][$i]['hide_db'] = ''; |
|
|
|
/** |
|
* Verbose name for this host - leave blank to show the hostname |
|
* (for HTTP authentication, all non-US-ASCII characters will be stripped) |
|
* |
|
* @global string $cfg['Servers'][$i]['verbose'] |
|
*/ |
|
$cfg['Servers'][$i]['verbose'] = ''; |
|
|
|
/** |
|
* Database used for Relation, Bookmark and PDF Features |
|
* (see sql/create_tables.sql) |
|
* - leave blank for no support |
|
* SUGGESTED: 'phpmyadmin' |
|
* |
|
* @global string $cfg['Servers'][$i]['pmadb'] |
|
*/ |
|
$cfg['Servers'][$i]['pmadb'] = ''; |
|
|
|
/** |
|
* Bookmark table |
|
* - leave blank for no bookmark support |
|
* SUGGESTED: 'pma__bookmark' |
|
* |
|
* @global string $cfg['Servers'][$i]['bookmarktable'] |
|
*/ |
|
$cfg['Servers'][$i]['bookmarktable'] = ''; |
|
|
|
/** |
|
* table to describe the relation between links (see doc) |
|
* - leave blank for no relation-links support |
|
* SUGGESTED: 'pma__relation' |
|
* |
|
* @global string $cfg['Servers'][$i]['relation'] |
|
*/ |
|
$cfg['Servers'][$i]['relation'] = ''; |
|
|
|
/** |
|
* table to describe the display fields |
|
* - leave blank for no display fields support |
|
* SUGGESTED: 'pma__table_info' |
|
* |
|
* @global string $cfg['Servers'][$i]['table_info'] |
|
*/ |
|
$cfg['Servers'][$i]['table_info'] = ''; |
|
|
|
/** |
|
* table to describe the tables position for the designer and PDF schema |
|
* - leave blank for no PDF schema support |
|
* SUGGESTED: 'pma__table_coords' |
|
* |
|
* @global string $cfg['Servers'][$i]['table_coords'] |
|
*/ |
|
$cfg['Servers'][$i]['table_coords'] = ''; |
|
|
|
/** |
|
* table to describe pages of relationpdf |
|
* - leave blank if you don't want to use this |
|
* SUGGESTED: 'pma__pdf_pages' |
|
* |
|
* @global string $cfg['Servers'][$i]['pdf_pages'] |
|
*/ |
|
$cfg['Servers'][$i]['pdf_pages'] = ''; |
|
|
|
/** |
|
* table to store column information |
|
* - leave blank for no column comments/mime types |
|
* SUGGESTED: 'pma__column_info' |
|
* |
|
* @global string $cfg['Servers'][$i]['column_info'] |
|
*/ |
|
$cfg['Servers'][$i]['column_info'] = ''; |
|
|
|
/** |
|
* table to store SQL history |
|
* - leave blank for no SQL query history |
|
* SUGGESTED: 'pma__history' |
|
* |
|
* @global string $cfg['Servers'][$i]['history'] |
|
*/ |
|
$cfg['Servers'][$i]['history'] = ''; |
|
|
|
/** |
|
* table to store recently used tables |
|
* - leave blank for no "persistent" recently used tables |
|
* SUGGESTED: 'pma__recent' |
|
*/ |
|
$cfg['Servers'][$i]['recent'] = ''; |
|
|
|
/** |
|
* table to store favorite tables |
|
* - leave blank for no favorite tables |
|
* SUGGESTED: 'pma__favorite' |
|
*/ |
|
$cfg['Servers'][$i]['favorite'] = ''; |
|
|
|
/** |
|
* table to store UI preferences for tables |
|
* - leave blank for no "persistent" UI preferences |
|
* SUGGESTED: 'pma__table_uiprefs' |
|
*/ |
|
$cfg['Servers'][$i]['table_uiprefs'] = ''; |
|
|
|
/** |
|
* table to store SQL tracking |
|
* - leave blank for no SQL tracking |
|
* SUGGESTED: 'pma__tracking' |
|
* |
|
* @global string $cfg['Servers'][$i]['tracking'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking'] = ''; |
|
|
|
/** |
|
* table to store user preferences |
|
* - leave blank to disable server storage |
|
* SUGGESTED: 'pma__userconfig' |
|
* |
|
* @global string $cfg['Servers'][$i]['userconfig'] |
|
*/ |
|
$cfg['Servers'][$i]['userconfig'] = ''; |
|
|
|
/** |
|
* table to store users and their assignment to user groups |
|
* - leave blank to disable configurable menus feature |
|
* SUGGESTED: 'pma__users' |
|
* |
|
* @global string $cfg['Servers'][$i]['users'] |
|
*/ |
|
$cfg['Servers'][$i]['users'] = ''; |
|
|
|
/** |
|
* table to store allowed menu items for each user group |
|
* - leave blank to disable configurable menus feature |
|
* SUGGESTED: 'pma__usergroups' |
|
* |
|
* @global string $cfg['Servers'][$i]['usergroups'] |
|
*/ |
|
$cfg['Servers'][$i]['usergroups'] = ''; |
|
|
|
/** |
|
* table to store information about item hidden from navigation tree |
|
* - leave blank to disable hide/show navigation items feature |
|
* SUGGESTED: 'pma__navigationhiding' |
|
* |
|
* @global string $cfg['Servers'][$i]['navigationhiding'] |
|
*/ |
|
$cfg['Servers'][$i]['navigationhiding'] = ''; |
|
|
|
/** |
|
* table to store information about saved searches from query-by-example on a db |
|
* - leave blank to disable saved searches feature |
|
* SUGGESTED: 'pma__savedsearches' |
|
* |
|
* @global string $cfg['Servers'][$i]['savedsearches'] |
|
*/ |
|
$cfg['Servers'][$i]['savedsearches'] = ''; |
|
|
|
/** |
|
* table to store central list of columns per database |
|
* - leave blank to disable central list of columns feature |
|
* SUGGESTED: 'pma__central_columns' |
|
* |
|
* @global string $cfg['Servers'][$i]['central_columns'] |
|
*/ |
|
$cfg['Servers'][$i]['central_columns'] = ''; |
|
|
|
/** |
|
* table to store designer settings |
|
* - leave blank to disable the storage of designer settings |
|
* SUGGESTED: 'pma__designer_settings' |
|
* |
|
* @global string $cfg['Servers'][$i]['designer_settings'] |
|
*/ |
|
$cfg['Servers'][$i]['designer_settings'] = ''; |
|
|
|
/** |
|
* table to store export templates |
|
* - leave blank to disable saved searches feature |
|
* SUGGESTED: 'pma__export_templates' |
|
* |
|
* @global string $cfg['Servers'][$i]['export_templates'] |
|
*/ |
|
$cfg['Servers'][$i]['export_templates'] = ''; |
|
|
|
/** |
|
* Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table. |
|
* |
|
* In case where tables in databases is modified (e.g. dropped or renamed), |
|
* table_uiprefs may contains invalid data (referring to tables which are not |
|
* exist anymore). |
|
* This configuration make sure that we only keep N (N = MaxTableUiprefs) |
|
* newest record in table_uiprefs and automatically delete older records. |
|
* |
|
* @global integer $cfg['Servers'][$i]['userconfig'] = ''; |
|
*/ |
|
$cfg['Servers'][$i]['MaxTableUiprefs'] = 100; |
|
|
|
/** |
|
* Sets the time zone used by phpMyAdmin. Possible values are explained at |
|
* https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html |
|
* |
|
* @global string $cfg['Servers'][$i]['SessionTimeZone'] = '' |
|
*/ |
|
$cfg['Servers'][$i]['SessionTimeZone'] = ''; |
|
|
|
/** |
|
* whether to allow root login |
|
* |
|
* @global boolean $cfg['Servers'][$i]['AllowRoot'] |
|
*/ |
|
$cfg['Servers'][$i]['AllowRoot'] = true; |
|
|
|
/** |
|
* whether to allow login of any user without a password |
|
* |
|
* @global boolean $cfg['Servers'][$i]['AllowNoPassword'] |
|
*/ |
|
$cfg['Servers'][$i]['AllowNoPassword'] = false; |
|
|
|
/** |
|
* Host authentication order, leave blank to not use |
|
* |
|
* @global string $cfg['Servers'][$i]['AllowDeny']['order'] |
|
*/ |
|
$cfg['Servers'][$i]['AllowDeny']['order'] = ''; |
|
|
|
/** |
|
* Host authentication rules, leave blank for defaults |
|
* |
|
* @global array $cfg['Servers'][$i]['AllowDeny']['rules'] |
|
*/ |
|
$cfg['Servers'][$i]['AllowDeny']['rules'] = []; |
|
|
|
/** |
|
* Disable use of INFORMATION_SCHEMA. |
|
* |
|
* @see https://github.com/phpmyadmin/phpmyadmin/issues/8970 |
|
* @see https://bugs.mysql.com/19588 |
|
* |
|
* @global boolean $cfg['Servers'][$i]['DisableIS'] |
|
*/ |
|
$cfg['Servers'][$i]['DisableIS'] = false; |
|
|
|
/** |
|
* Whether the tracking mechanism creates |
|
* versions for tables and views automatically. |
|
* |
|
* @global bool $cfg['Servers'][$i]['tracking_version_auto_create'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking_version_auto_create'] = false; |
|
|
|
/** |
|
* Defines the list of statements |
|
* the auto-creation uses for new versions. |
|
* |
|
* @global string $cfg['Servers'][$i]['tracking_default_statements'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' . |
|
'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' . |
|
'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE'; |
|
|
|
/** |
|
* Whether a DROP VIEW IF EXISTS statement will be added |
|
* as first line to the log when creating a view. |
|
* |
|
* @global bool $cfg['Servers'][$i]['tracking_add_drop_view'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking_add_drop_view'] = true; |
|
|
|
/** |
|
* Whether a DROP TABLE IF EXISTS statement will be added |
|
* as first line to the log when creating a table. |
|
* |
|
* @global bool $cfg['Servers'][$i]['tracking_add_drop_table'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking_add_drop_table'] = true; |
|
|
|
/** |
|
* Whether a DROP DATABASE IF EXISTS statement will be added |
|
* as first line to the log when creating a database. |
|
* |
|
* @global bool $cfg['Servers'][$i]['tracking_add_drop_database'] |
|
*/ |
|
$cfg['Servers'][$i]['tracking_add_drop_database'] = true; |
|
|
|
/** |
|
* Whether to show or hide detailed MySQL/MariaDB connection errors on the login page. |
|
* |
|
* @global bool $cfg['Servers'][$i]['hide_connection_errors'] |
|
*/ |
|
$cfg['Servers'][$i]['hide_connection_errors'] = false; |
|
|
|
/** |
|
* Default server (0 = no default server) |
|
* |
|
* If you have more than one server configured, you can set $cfg['ServerDefault'] |
|
* to any one of them to auto-connect to that server when phpMyAdmin is started, |
|
* or set it to 0 to be given a list of servers without logging in |
|
* If you have only one server configured, $cfg['ServerDefault'] *MUST* be |
|
* set to that server. |
|
* |
|
* @global integer $cfg['ServerDefault'] |
|
*/ |
|
$cfg['ServerDefault'] = 1; |
|
|
|
/** |
|
* Other core phpMyAdmin settings |
|
*/ |
|
|
|
/** |
|
* whether version check is active |
|
* |
|
* @global boolean $cfg['VersionCheck'] |
|
*/ |
|
if (defined('VERSION_CHECK_DEFAULT')) { |
|
$cfg['VersionCheck'] = VERSION_CHECK_DEFAULT; |
|
} else { |
|
$cfg['VersionCheck'] = true; |
|
} |
|
|
|
/** |
|
* The url of the proxy to be used when retrieving the information about |
|
* the latest version of phpMyAdmin or error reporting. You need this if |
|
* the server where phpMyAdmin is installed does not have direct access to |
|
* the internet. |
|
* The format is: "hostname:portnumber" |
|
* |
|
* @global string $cfg['ProxyUrl'] |
|
*/ |
|
$cfg['ProxyUrl'] = ''; |
|
|
|
/** |
|
* The username for authenticating with the proxy. By default, no |
|
* authentication is performed. If a username is supplied, Basic |
|
* Authentication will be performed. No other types of authentication |
|
* are currently supported. |
|
* |
|
* @global string $cfg['ProxyUser'] |
|
*/ |
|
$cfg['ProxyUser'] = ''; |
|
|
|
/** |
|
* The password for authenticating with the proxy. |
|
* |
|
* @global string $cfg['ProxyPass'] |
|
*/ |
|
$cfg['ProxyPass'] = ''; |
|
|
|
/** |
|
* maximum number of db's displayed in database list |
|
* |
|
* @global integer $cfg['MaxDbList'] |
|
*/ |
|
$cfg['MaxDbList'] = 100; |
|
|
|
/** |
|
* maximum number of tables displayed in table list |
|
* |
|
* @global integer $cfg['MaxTableList'] |
|
*/ |
|
$cfg['MaxTableList'] = 250; |
|
|
|
/** |
|
* whether to show hint or not |
|
* |
|
* @global boolean $cfg['ShowHint'] |
|
*/ |
|
$cfg['ShowHint'] = true; |
|
|
|
/** |
|
* maximum number of characters when a SQL query is displayed |
|
* |
|
* @global integer $cfg['MaxCharactersInDisplayedSQL'] |
|
*/ |
|
$cfg['MaxCharactersInDisplayedSQL'] = 1000; |
|
|
|
/** |
|
* use GZIP output buffering if possible (true|false|'auto') |
|
* |
|
* @global string $cfg['OBGzip'] |
|
*/ |
|
$cfg['OBGzip'] = 'auto'; |
|
|
|
/** |
|
* use persistent connections to MySQL database |
|
* |
|
* @global boolean $cfg['PersistentConnections'] |
|
*/ |
|
$cfg['PersistentConnections'] = false; |
|
|
|
/** |
|
* maximum execution time in seconds (0 for no limit) |
|
* |
|
* @global integer $cfg['ExecTimeLimit'] |
|
*/ |
|
$cfg['ExecTimeLimit'] = 300; |
|
|
|
/** |
|
* Path for storing session data (session_save_path PHP parameter). |
|
* |
|
* @global integer $cfg['SessionSavePath'] |
|
*/ |
|
$cfg['SessionSavePath'] = ''; |
|
|
|
/** |
|
* Hosts or IPs to consider safe when checking if SSL is used or not |
|
* |
|
* @global array $cfg['MysqlSslWarningSafeHosts'] |
|
*/ |
|
$cfg['MysqlSslWarningSafeHosts'] = ['127.0.0.1', 'localhost']; |
|
|
|
/** |
|
* maximum allocated bytes ('-1' for no limit, '0' for no change) |
|
* this is a string because '16M' is a valid value; we must put here |
|
* a string as the default value so that /setup accepts strings |
|
* |
|
* @global string $cfg['MemoryLimit'] |
|
*/ |
|
$cfg['MemoryLimit'] = '-1'; |
|
|
|
/** |
|
* mark used tables, make possible to show locked tables (since MySQL 3.23.30) |
|
* |
|
* @global boolean $cfg['SkipLockedTables'] |
|
*/ |
|
$cfg['SkipLockedTables'] = false; |
|
|
|
/** |
|
* show SQL queries as run |
|
* |
|
* @global boolean $cfg['ShowSQL'] |
|
*/ |
|
$cfg['ShowSQL'] = true; |
|
|
|
/** |
|
* retain SQL input on Ajax execute |
|
* |
|
* @global boolean $cfg['RetainQueryEditor'] |
|
*/ |
|
$cfg['RetainQueryBox'] = false; |
|
|
|
/** |
|
* use CodeMirror syntax highlighting for editing SQL |
|
* |
|
* @global boolean $cfg['CodemirrorEnable'] |
|
*/ |
|
$cfg['CodemirrorEnable'] = true; |
|
|
|
/** |
|
* use the parser to find any errors in the query before executing |
|
* |
|
* @global boolean $cfg['LintEnable'] |
|
*/ |
|
$cfg['LintEnable'] = true; |
|
|
|
/** |
|
* show a 'Drop database' link to normal users |
|
* |
|
* @global boolean $cfg['AllowUserDropDatabase'] |
|
*/ |
|
$cfg['AllowUserDropDatabase'] = false; |
|
|
|
/** |
|
* confirm some commands that can result in loss of data |
|
* |
|
* @global boolean $cfg['Confirm'] |
|
*/ |
|
$cfg['Confirm'] = true; |
|
|
|
/** |
|
* sets SameSite attribute of the Set-Cookie HTTP response header |
|
* |
|
* Valid values are: |
|
* - Lax |
|
* - Strict |
|
* - None |
|
* |
|
* @global string $cfg['CookieSameSite'] |
|
*/ |
|
$cfg['CookieSameSite'] = 'Strict'; |
|
|
|
/** |
|
* recall previous login in cookie authentication mode or not |
|
* |
|
* @global boolean $cfg['LoginCookieRecall'] |
|
*/ |
|
$cfg['LoginCookieRecall'] = true; |
|
|
|
/** |
|
* validity of cookie login (in seconds; 1440 matches php.ini's |
|
* session.gc_maxlifetime) |
|
* |
|
* @global integer $cfg['LoginCookieValidity'] |
|
*/ |
|
$cfg['LoginCookieValidity'] = 1440; |
|
|
|
/** |
|
* how long login cookie should be stored (in seconds) |
|
* |
|
* @global integer $cfg['LoginCookieStore'] |
|
*/ |
|
$cfg['LoginCookieStore'] = 0; |
|
|
|
/** |
|
* whether to delete all login cookies on logout |
|
* |
|
* @global boolean $cfg['LoginCookieDeleteAll'] |
|
*/ |
|
$cfg['LoginCookieDeleteAll'] = true; |
|
|
|
/** |
|
* whether to enable the "database search" feature or not |
|
* |
|
* @global boolean $cfg['UseDbSearch'] |
|
*/ |
|
$cfg['UseDbSearch'] = true; |
|
|
|
/** |
|
* if set to true, PMA continues computing multiple-statement queries |
|
* even if one of the queries failed |
|
* |
|
* @global boolean $cfg['IgnoreMultiSubmitErrors'] |
|
*/ |
|
$cfg['IgnoreMultiSubmitErrors'] = false; |
|
|
|
/** |
|
* Define whether phpMyAdmin will encrypt sensitive data from the URL query string. |
|
* |
|
* @global bool $cfg['URLQueryEncryption'] |
|
*/ |
|
$cfg['URLQueryEncryption'] = false; |
|
|
|
/** |
|
* A secret key used to encrypt/decrypt the URL query string. Should be 32 bytes long. |
|
* |
|
* @global string $cfg['URLQueryEncryptionSecretKey'] |
|
*/ |
|
$cfg['URLQueryEncryptionSecretKey'] = ''; |
|
|
|
/** |
|
* allow login to any user entered server in cookie based authentication |
|
* |
|
* @global boolean $cfg['AllowArbitraryServer'] |
|
*/ |
|
$cfg['AllowArbitraryServer'] = false; |
|
|
|
/** |
|
* restrict by IP (with regular expression) the MySQL servers the user can enter |
|
* when $cfg['AllowArbitraryServer'] = true |
|
* |
|
* @global string $cfg['ArbitraryServerRegexp'] |
|
*/ |
|
$cfg['ArbitraryServerRegexp'] = ''; |
|
|
|
/** |
|
* To enable reCaptcha v2 checkbox mode if necessary |
|
* |
|
* @global string $cfg['CaptchaMethod'] |
|
*/ |
|
$cfg['CaptchaMethod'] = 'invisible'; |
|
|
|
/** |
|
* URL for the reCaptcha v2 compatible API to use |
|
* |
|
* @global string $cfg['CaptchaApi'] |
|
*/ |
|
$cfg['CaptchaApi'] = 'https://www.google.com/recaptcha/api.js'; |
|
|
|
/** |
|
* Content-Security-Policy snippet for the reCaptcha v2 compatible API |
|
* |
|
* @global string $cfg['CaptchaCsp'] |
|
*/ |
|
$cfg['CaptchaCsp'] = 'https://apis.google.com https://www.google.com/recaptcha/' |
|
. ' https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/'; |
|
|
|
/** |
|
* reCaptcha API's request parameter name |
|
* |
|
* @global string $cfg['CaptchaRequestParam'] |
|
*/ |
|
$cfg['CaptchaRequestParam'] = 'g-recaptcha'; |
|
|
|
/** |
|
* reCaptcha API's response parameter name |
|
* |
|
* @global string $cfg['CaptchaResponseParam'] |
|
*/ |
|
$cfg['CaptchaResponseParam'] = 'g-recaptcha-response'; |
|
|
|
/** |
|
* if reCaptcha is enabled it needs public key to connect with the service |
|
* |
|
* @global string $cfg['CaptchaLoginPublicKey'] |
|
*/ |
|
$cfg['CaptchaLoginPublicKey'] = ''; |
|
|
|
/** |
|
* if reCaptcha is enabled it needs private key to connect with the service |
|
* |
|
* @global string $cfg['CaptchaLoginPrivateKey'] |
|
*/ |
|
$cfg['CaptchaLoginPrivateKey'] = ''; |
|
|
|
/** |
|
* if reCaptcha is enabled may need an URL for site verify |
|
* |
|
* @global string $cfg['CaptchaSiteVerifyURL'] |
|
*/ |
|
$cfg['CaptchaSiteVerifyURL'] = ''; |
|
|
|
/** |
|
* Enable drag and drop import |
|
* |
|
* @see feature request : https://github.com/phpmyadmin/phpmyadmin/issues/13155 |
|
* |
|
* @global bool $cfg['enable_drag_drop_import'] |
|
*/ |
|
$cfg['enable_drag_drop_import'] = true; |
|
|
|
/******************************************************************************* |
|
* Navigation panel setup |
|
*/ |
|
|
|
/** |
|
* In the navigation panel, replaces the database tree with a selector |
|
* |
|
* @global boolean $cfg['ShowDatabasesNavigationAsTree'] |
|
*/ |
|
$cfg['ShowDatabasesNavigationAsTree'] = true; |
|
|
|
/** |
|
* maximum number of first level databases displayed in navigation panel |
|
* |
|
* @global integer $cfg['FirstLevelNavigationItems'] |
|
*/ |
|
$cfg['FirstLevelNavigationItems'] = 100; |
|
|
|
/** |
|
* maximum number of items displayed in navigation panel |
|
* |
|
* @global integer $cfg['MaxNavigationItems'] |
|
*/ |
|
$cfg['MaxNavigationItems'] = 50; |
|
|
|
/** |
|
* turn the select-based light menu into a tree |
|
* |
|
* @global boolean $cfg['NavigationTreeEnableGrouping'] |
|
*/ |
|
$cfg['NavigationTreeEnableGrouping'] = true; |
|
|
|
/** |
|
* the separator to sub-tree the select-based light menu tree |
|
* |
|
* @global string $cfg['NavigationTreeDbSeparator'] |
|
*/ |
|
$cfg['NavigationTreeDbSeparator'] = '_'; |
|
|
|
/** |
|
* Which string will be used to generate table prefixes |
|
* to split/nest tables into multiple categories |
|
* |
|
* @global string $cfg['NavigationTreeTableSeparator'] |
|
*/ |
|
$cfg['NavigationTreeTableSeparator'] = '__'; |
|
|
|
/** |
|
* How many sublevels should be displayed when splitting up tables |
|
* by the above Separator |
|
* |
|
* @global integer $cfg['NavigationTreeTableLevel'] |
|
*/ |
|
$cfg['NavigationTreeTableLevel'] = 1; |
|
|
|
/** |
|
* link with main panel by highlighting the current db/table |
|
* |
|
* @global boolean $cfg['NavigationLinkWithMainPanel'] |
|
*/ |
|
$cfg['NavigationLinkWithMainPanel'] = true; |
|
|
|
/** |
|
* display logo at top of navigation panel |
|
* |
|
* @global boolean $cfg['NavigationDisplayLogo'] |
|
*/ |
|
$cfg['NavigationDisplayLogo'] = true; |
|
|
|
/** |
|
* where should logo link point to (can also contain an external URL) |
|
* |
|
* @global string $cfg['NavigationLogoLink'] |
|
*/ |
|
$cfg['NavigationLogoLink'] = 'index.php'; |
|
|
|
/** |
|
* whether to open the linked page in the main window ('main') or |
|
* in a new window ('new') |
|
* |
|
* @global string $cfg['NavigationLogoLinkWindow'] |
|
*/ |
|
$cfg['NavigationLogoLinkWindow'] = 'main'; |
|
|
|
/** |
|
* number of recently used tables displayed in the navigation panel |
|
* |
|
* @global integer $cfg['NumRecentTables'] |
|
*/ |
|
$cfg['NumRecentTables'] = 10; |
|
|
|
/** |
|
* number of favorite tables displayed in the navigation panel |
|
* |
|
* @global integer $cfg['NumFavoriteTables'] |
|
*/ |
|
$cfg['NumFavoriteTables'] = 10; |
|
|
|
/** |
|
* display a JavaScript table filter in the navigation panel |
|
* when more then x tables are present |
|
* |
|
* @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum'] |
|
*/ |
|
$cfg['NavigationTreeDisplayItemFilterMinimum'] = 30; |
|
|
|
/** |
|
* display server choice at top of navigation panel |
|
* |
|
* @global boolean $cfg['NavigationDisplayServers'] |
|
*/ |
|
$cfg['NavigationDisplayServers'] = true; |
|
|
|
/** |
|
* server choice as links |
|
* |
|
* @global boolean $cfg['DisplayServersList'] |
|
*/ |
|
$cfg['DisplayServersList'] = false; |
|
|
|
/** |
|
* display a JavaScript database filter in the navigation panel |
|
* when more then x databases are present |
|
* |
|
* @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum'] |
|
*/ |
|
$cfg['NavigationTreeDisplayDbFilterMinimum'] = 30; |
|
|
|
/** |
|
* target of the navigation panel quick access icon |
|
* |
|
* Possible values: |
|
* 'structure' = fields list |
|
* 'sql' = SQL form |
|
* 'search' = search page |
|
* 'insert' = insert row page |
|
* 'browse' = browse page |
|
* |
|
* @global string $cfg['NavigationTreeDefaultTabTable'] |
|
*/ |
|
$cfg['NavigationTreeDefaultTabTable'] = 'structure'; |
|
|
|
/** |
|
* target of the navigation panel quick second access icon |
|
* |
|
* Possible values: |
|
* 'structure' = fields list |
|
* 'sql' = SQL form |
|
* 'search' = search page |
|
* 'insert' = insert row page |
|
* 'browse' = browse page |
|
* '' = no link |
|
* |
|
* @global string $cfg['NavigationTreeDefaultTabTable2'] |
|
*/ |
|
$cfg['NavigationTreeDefaultTabTable2'] = ''; |
|
|
|
/** |
|
* Enables the possibility of navigation tree expansion |
|
* |
|
* @global boolean $cfg['NavigationTreeEnableExpansion'] |
|
*/ |
|
$cfg['NavigationTreeEnableExpansion'] = true; |
|
|
|
/** |
|
* Show tables in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationTreeShowTables'] |
|
*/ |
|
$cfg['NavigationTreeShowTables'] = true; |
|
|
|
/** |
|
* Show views in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationTreeShowViews'] |
|
*/ |
|
$cfg['NavigationTreeShowViews'] = true; |
|
|
|
/** |
|
* Show functions in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationTreeShowFunctions'] |
|
*/ |
|
$cfg['NavigationTreeShowFunctions'] = true; |
|
|
|
/** |
|
* Show procedures in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationTreeShowProcedures'] |
|
*/ |
|
$cfg['NavigationTreeShowProcedures'] = true; |
|
|
|
/** |
|
* Show events in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationTreeShowEvents'] |
|
*/ |
|
$cfg['NavigationTreeShowEvents'] = true; |
|
|
|
/** |
|
* Width of navigation panel |
|
* |
|
* @global integer $cfg['NavigationWidth'] |
|
*/ |
|
$cfg['NavigationWidth'] = 240; |
|
|
|
/** |
|
* Automatically expands single database in navigation panel |
|
* |
|
* @global boolean $cfg['NavigationAutoexpandSingleDb'] |
|
*/ |
|
$cfg['NavigationTreeAutoexpandSingleDb'] = true; |
|
|
|
/******************************************************************************* |
|
* In the main panel, at startup... |
|
*/ |
|
|
|
/** |
|
* allow to display statistics and space usage in the pages about database |
|
* details and table properties |
|
* |
|
* @global boolean $cfg['ShowStats'] |
|
*/ |
|
$cfg['ShowStats'] = true; |
|
|
|
/** |
|
* show PHP info link |
|
* |
|
* @global boolean $cfg['ShowPhpInfo'] |
|
*/ |
|
$cfg['ShowPhpInfo'] = false; |
|
|
|
/** |
|
* show MySQL server and web server information |
|
* |
|
* @global boolean $cfg['ShowServerInfo'] |
|
*/ |
|
$cfg['ShowServerInfo'] = true; |
|
|
|
/** |
|
* show change password link |
|
* |
|
* @global boolean $cfg['ShowChgPassword'] |
|
*/ |
|
$cfg['ShowChgPassword'] = true; |
|
|
|
/** |
|
* show create database form |
|
* |
|
* @global boolean $cfg['ShowCreateDb'] |
|
*/ |
|
$cfg['ShowCreateDb'] = true; |
|
|
|
|
|
/******************************************************************************* |
|
* Database structure |
|
*/ |
|
|
|
/** |
|
* show charset column in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['ShowDbStructureCharset'] |
|
*/ |
|
$cfg['ShowDbStructureCharset'] = false; |
|
|
|
/** |
|
* show comment column in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['ShowDbStructureComment'] |
|
*/ |
|
$cfg['ShowDbStructureComment'] = false; |
|
|
|
/** |
|
* show creation timestamp column in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['ShowDbStructureCreation'] |
|
*/ |
|
$cfg['ShowDbStructureCreation'] = false; |
|
|
|
/** |
|
* show last update timestamp column in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['ShowDbStructureLastUpdate'] |
|
*/ |
|
$cfg['ShowDbStructureLastUpdate'] = false; |
|
|
|
/** |
|
* show last check timestamp column in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['ShowDbStructureLastCheck'] |
|
*/ |
|
$cfg['ShowDbStructureLastCheck'] = false; |
|
|
|
/** |
|
* allow hide action columns to drop down menu in database structure (true|false)? |
|
* |
|
* @global boolean $cfg['HideStructureActions'] |
|
*/ |
|
$cfg['HideStructureActions'] = true; |
|
|
|
/** |
|
* Show column comments in table structure view (true|false)? |
|
* |
|
* @global boolean $cfg['ShowColumnComments'] |
|
*/ |
|
$cfg['ShowColumnComments'] = true; |
|
|
|
|
|
/******************************************************************************* |
|
* In browse mode... |
|
*/ |
|
|
|
/** |
|
* Use icons instead of text for the navigation bar buttons (table browse) |
|
* ('text'|'icons'|'both') |
|
* |
|
* @global string $cfg['TableNavigationLinksMode'] |
|
*/ |
|
$cfg['TableNavigationLinksMode'] = 'icons'; |
|
|
|
/** |
|
* Defines whether a user should be displayed a "show all (records)" |
|
* button in browse mode or not. |
|
* |
|
* @global boolean $cfg['ShowAll'] |
|
*/ |
|
$cfg['ShowAll'] = false; |
|
|
|
/** |
|
* Number of rows displayed when browsing a result set. If the result |
|
* set contains more rows, "Previous" and "Next". |
|
* Possible values: 25,50,100,250,500 |
|
* |
|
* @global integer $cfg['MaxRows'] |
|
*/ |
|
$cfg['MaxRows'] = 25; |
|
|
|
/** |
|
* default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie |
|
* descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP, |
|
* ascending order else-) |
|
* |
|
* @global string $cfg['Order'] |
|
*/ |
|
$cfg['Order'] = 'SMART'; |
|
|
|
/** |
|
* grid editing: save edited cell(s) in browse-mode at once |
|
* |
|
* @global boolean $cfg['SaveCellsAtOnce'] |
|
*/ |
|
$cfg['SaveCellsAtOnce'] = false; |
|
|
|
/** |
|
* grid editing: which action triggers it, or completely disable the feature |
|
* |
|
* Possible values: |
|
* 'click' |
|
* 'double-click' |
|
* 'disabled' |
|
* |
|
* @global string $cfg['GridEditing'] |
|
*/ |
|
$cfg['GridEditing'] = 'double-click'; |
|
|
|
/** |
|
* Options > Relational display |
|
* |
|
* Possible values: |
|
* 'K' for key value |
|
* 'D' for display column |
|
* |
|
* @global string $cfg['RelationalDisplay'] |
|
*/ |
|
$cfg['RelationalDisplay'] = 'K'; |
|
|
|
|
|
/******************************************************************************* |
|
* In edit mode... |
|
*/ |
|
|
|
/** |
|
* disallow editing of binary fields |
|
* valid values are: |
|
* false allow editing |
|
* 'blob' allow editing except for BLOB fields |
|
* 'noblob' disallow editing except for BLOB fields |
|
* 'all' disallow editing |
|
* |
|
* @global string $cfg['ProtectBinary'] |
|
*/ |
|
$cfg['ProtectBinary'] = 'blob'; |
|
|
|
/** |
|
* Display the function fields in edit/insert mode |
|
* |
|
* @global boolean $cfg['ShowFunctionFields'] |
|
*/ |
|
$cfg['ShowFunctionFields'] = true; |
|
|
|
/** |
|
* Display the type fields in edit/insert mode |
|
* |
|
* @global boolean $cfg['ShowFieldTypesInDataEditView'] |
|
*/ |
|
$cfg['ShowFieldTypesInDataEditView'] = true; |
|
|
|
/** |
|
* Which editor should be used for CHAR/VARCHAR fields: |
|
* input - allows limiting of input length |
|
* textarea - allows newlines in fields |
|
* |
|
* @global string $cfg['CharEditing'] |
|
*/ |
|
$cfg['CharEditing'] = 'input'; |
|
|
|
/** |
|
* The minimum size for character input fields |
|
* |
|
* @global integer $cfg['MinSizeForInputField'] |
|
*/ |
|
$cfg['MinSizeForInputField'] = 4; |
|
|
|
/** |
|
* The maximum size for character input fields |
|
* |
|
* @global integer $cfg['MinSizeForInputField'] |
|
*/ |
|
$cfg['MaxSizeForInputField'] = 60; |
|
|
|
/** |
|
* How many rows can be inserted at one time |
|
* |
|
* @global integer $cfg['InsertRows'] |
|
*/ |
|
$cfg['InsertRows'] = 2; |
|
|
|
/** |
|
* Sort order for items in a foreign-key drop-down list. |
|
* 'content' is the referenced data, 'id' is the key value. |
|
* |
|
* @global array $cfg['ForeignKeyDropdownOrder'] |
|
*/ |
|
$cfg['ForeignKeyDropdownOrder'] = [ |
|
'content-id', |
|
'id-content', |
|
]; |
|
|
|
/** |
|
* A drop-down list will be used if fewer items are present |
|
* |
|
* @global integer $cfg['ForeignKeyMaxLimit'] |
|
*/ |
|
$cfg['ForeignKeyMaxLimit'] = 100; |
|
|
|
/** |
|
* Whether to disable foreign key checks while importing |
|
* |
|
* @global boolean $cfg['DefaultForeignKeyChecks'] |
|
*/ |
|
$cfg['DefaultForeignKeyChecks'] = 'default'; |
|
|
|
/******************************************************************************* |
|
* For the export features... |
|
*/ |
|
|
|
/** |
|
* Allow for the use of zip compression (requires zip support to be enabled) |
|
* |
|
* @global boolean $cfg['ZipDump'] |
|
*/ |
|
$cfg['ZipDump'] = true; |
|
|
|
/** |
|
* Allow for the use of gzip compression (requires zlib) |
|
* |
|
* @global boolean $cfg['GZipDump'] |
|
*/ |
|
$cfg['GZipDump'] = true; |
|
|
|
/** |
|
* Allow for the use of bzip2 decompression (requires bz2 extension) |
|
* |
|
* @global boolean $cfg['BZipDump'] |
|
*/ |
|
$cfg['BZipDump'] = true; |
|
|
|
/** |
|
* Will compress gzip exports on the fly without the need for much memory. |
|
* If you encounter problems with created gzip files disable this feature. |
|
* |
|
* @global boolean $cfg['CompressOnFly'] |
|
*/ |
|
$cfg['CompressOnFly'] = true; |
|
|
|
|
|
/******************************************************************************* |
|
* Tabs display settings |
|
*/ |
|
|
|
/** |
|
* How to display the menu tabs ('icons'|'text'|'both') |
|
* |
|
* @global boolean $cfg['TabsMode'] |
|
*/ |
|
$cfg['TabsMode'] = 'both'; |
|
|
|
/** |
|
* How to display various action links ('icons'|'text'|'both') |
|
* |
|
* @global boolean $cfg['ActionLinksMode'] |
|
*/ |
|
$cfg['ActionLinksMode'] = 'both'; |
|
|
|
/** |
|
* How many columns should be used for table display of a database? |
|
* (a value larger than 1 results in some information being hidden) |
|
* |
|
* @global integer $cfg['PropertiesNumColumns'] |
|
*/ |
|
$cfg['PropertiesNumColumns'] = 1; |
|
|
|
/** |
|
* Possible values: |
|
* 'welcome' = the welcome page |
|
* (recommended for multiuser setups) |
|
* 'databases' = list of databases |
|
* 'status' = runtime information |
|
* 'variables' = MySQL server variables |
|
* 'privileges' = user management |
|
* |
|
* @global string $cfg['DefaultTabServer'] |
|
*/ |
|
$cfg['DefaultTabServer'] = 'welcome'; |
|
|
|
/** |
|
* Possible values: |
|
* 'structure' = tables list |
|
* 'sql' = SQL form |
|
* 'search' = search query |
|
* 'operations' = operations on database |
|
* |
|
* @global string $cfg['DefaultTabDatabase'] |
|
*/ |
|
$cfg['DefaultTabDatabase'] = 'structure'; |
|
|
|
/** |
|
* Possible values: |
|
* 'structure' = fields list |
|
* 'sql' = SQL form |
|
* 'search' = search page |
|
* 'insert' = insert row page |
|
* 'browse' = browse page |
|
* |
|
* @global string $cfg['DefaultTabTable'] |
|
*/ |
|
$cfg['DefaultTabTable'] = 'browse'; |
|
|
|
/** |
|
* Whether to display image or text or both image and text in table row |
|
* action segment. Value can be either of ``image``, ``text`` or ``both``. |
|
*/ |
|
$cfg['RowActionType'] = 'both'; |
|
|
|
/******************************************************************************* |
|
* Export defaults |
|
*/ |
|
$cfg['Export'] = []; |
|
|
|
/** |
|
* codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml |
|
* |
|
* @global string $cfg['Export']['format'] |
|
*/ |
|
$cfg['Export']['format'] = 'sql'; |
|
|
|
/** |
|
* quick/custom/custom-no-form |
|
* |
|
* @global string $cfg['Export']['format'] |
|
*/ |
|
$cfg['Export']['method'] = 'quick'; |
|
|
|
/** |
|
* none/zip/gzip |
|
* |
|
* @global string $cfg['Export']['compression'] |
|
*/ |
|
$cfg['Export']['compression'] = 'none'; |
|
|
|
/** |
|
* Whether to LOCK TABLES before exporting |
|
* |
|
* @global boolean $cfg['Export']['lock_tables'] |
|
*/ |
|
$cfg['Export']['lock_tables'] = false; |
|
|
|
/** |
|
* Whether to export databases/tables as separate files |
|
* |
|
* @global boolean $cfg['Export']['as_separate_files'] |
|
*/ |
|
$cfg['Export']['as_separate_files'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['asfile'] |
|
*/ |
|
$cfg['Export']['asfile'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['charset'] |
|
*/ |
|
$cfg['Export']['charset'] = ''; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['onserver'] |
|
*/ |
|
$cfg['Export']['onserver'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['onserver_overwrite'] |
|
*/ |
|
$cfg['Export']['onserver_overwrite'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['quick_export_onserver'] |
|
*/ |
|
$cfg['Export']['quick_export_onserver'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['quick_export_onserver_overwrite'] |
|
*/ |
|
$cfg['Export']['quick_export_onserver_overwrite'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['remember_file_template'] |
|
*/ |
|
$cfg['Export']['remember_file_template'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['file_template_table'] |
|
*/ |
|
$cfg['Export']['file_template_table'] = '@TABLE@'; |
|
|
|
/** |
|
* @global string $cfg['Export']['file_template_database'] |
|
*/ |
|
$cfg['Export']['file_template_database'] = '@DATABASE@'; |
|
|
|
/** |
|
* @global string $cfg['Export']['file_template_server'] |
|
*/ |
|
$cfg['Export']['file_template_server'] = '@SERVER@'; |
|
|
|
/** |
|
* @global string $cfg['Export']['codegen_structure_or_data'] |
|
*/ |
|
$cfg['Export']['codegen_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global $cfg['Export']['codegen_format'] |
|
*/ |
|
$cfg['Export']['codegen_format'] = 0; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['ods_columns'] |
|
*/ |
|
$cfg['Export']['ods_columns'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['ods_null'] |
|
*/ |
|
$cfg['Export']['ods_null'] = 'NULL'; |
|
|
|
/** |
|
* @global string $cfg['Export']['odt_structure_or_data'] |
|
*/ |
|
$cfg['Export']['odt_structure_or_data'] = 'structure_and_data'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['odt_columns'] |
|
*/ |
|
$cfg['Export']['odt_columns'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['odt_relation'] |
|
*/ |
|
$cfg['Export']['odt_relation'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['odt_comments'] |
|
*/ |
|
$cfg['Export']['odt_comments'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['odt_mime'] |
|
*/ |
|
$cfg['Export']['odt_mime'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['odt_null'] |
|
*/ |
|
$cfg['Export']['odt_null'] = 'NULL'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['htmlword_structure_or_data'] |
|
*/ |
|
$cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['htmlword_columns'] |
|
*/ |
|
$cfg['Export']['htmlword_columns'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['htmlword_null'] |
|
*/ |
|
$cfg['Export']['htmlword_null'] = 'NULL'; |
|
|
|
/** |
|
* @global string $cfg['Export']['texytext_structure_or_data'] |
|
*/ |
|
$cfg['Export']['texytext_structure_or_data'] = 'structure_and_data'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['texytext_columns'] |
|
*/ |
|
$cfg['Export']['texytext_columns'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['texytext_null'] |
|
*/ |
|
$cfg['Export']['texytext_null'] = 'NULL'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['csv_columns'] |
|
*/ |
|
$cfg['Export']['csv_columns'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_structure_or_data'] |
|
*/ |
|
$cfg['Export']['csv_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_null'] |
|
*/ |
|
$cfg['Export']['csv_null'] = 'NULL'; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_separator'] |
|
*/ |
|
$cfg['Export']['csv_separator'] = ','; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_enclosed'] |
|
*/ |
|
$cfg['Export']['csv_enclosed'] = '"'; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_escaped'] |
|
*/ |
|
$cfg['Export']['csv_escaped'] = '"'; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_terminated'] |
|
*/ |
|
$cfg['Export']['csv_terminated'] = 'AUTO'; |
|
|
|
/** |
|
* @global string $cfg['Export']['csv_removeCRLF'] |
|
*/ |
|
$cfg['Export']['csv_removeCRLF'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['excel_columns'] |
|
*/ |
|
$cfg['Export']['excel_columns'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['excel_null'] |
|
*/ |
|
$cfg['Export']['excel_null'] = 'NULL'; |
|
|
|
/** |
|
* win/mac |
|
* |
|
* @global string $cfg['Export']['excel_edition'] |
|
*/ |
|
$cfg['Export']['excel_edition'] = 'win'; |
|
|
|
/** |
|
* @global string $cfg['Export']['excel_removeCRLF'] |
|
*/ |
|
$cfg['Export']['excel_removeCRLF'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['excel_structure_or_data'] |
|
*/ |
|
$cfg['Export']['excel_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_structure_or_data'] |
|
*/ |
|
$cfg['Export']['latex_structure_or_data'] = 'structure_and_data'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['latex_columns'] |
|
*/ |
|
$cfg['Export']['latex_columns'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['latex_relation'] |
|
*/ |
|
$cfg['Export']['latex_relation'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['latex_comments'] |
|
*/ |
|
$cfg['Export']['latex_comments'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['latex_mime'] |
|
*/ |
|
$cfg['Export']['latex_mime'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_null'] |
|
*/ |
|
$cfg['Export']['latex_null'] = '\textit{NULL}'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['latex_caption'] |
|
*/ |
|
$cfg['Export']['latex_caption'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_structure_caption'] |
|
*/ |
|
$cfg['Export']['latex_structure_caption'] = 'strLatexStructure'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_structure_continued_caption'] |
|
*/ |
|
$cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_data_caption'] |
|
*/ |
|
$cfg['Export']['latex_data_caption'] = 'strLatexContent'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_data_continued_caption'] |
|
*/ |
|
$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_data_label'] |
|
*/ |
|
$cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['latex_structure_label'] |
|
*/ |
|
$cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure'; |
|
|
|
/** |
|
* @global string $cfg['Export']['mediawiki_structure_or_data'] |
|
*/ |
|
$cfg['Export']['mediawiki_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['mediawiki_caption'] |
|
*/ |
|
$cfg['Export']['mediawiki_caption'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['mediawiki_headers'] |
|
*/ |
|
$cfg['Export']['mediawiki_headers'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['ods_structure_or_data'] |
|
*/ |
|
$cfg['Export']['ods_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['pdf_structure_or_data'] |
|
*/ |
|
$cfg['Export']['pdf_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['phparray_structure_or_data'] |
|
*/ |
|
$cfg['Export']['phparray_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['json_structure_or_data'] |
|
*/ |
|
$cfg['Export']['json_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* Export functions |
|
* |
|
* @global string $cfg['Export']['json_pretty_print'] |
|
*/ |
|
$cfg['Export']['json_pretty_print'] = false; |
|
|
|
/** |
|
* Export functions |
|
* |
|
* @global string $cfg['Export']['json_unicode'] |
|
*/ |
|
$cfg['Export']['json_unicode'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['remove_definer_from_definitions'] |
|
*/ |
|
$cfg['Export']['remove_definer_from_definitions'] = false; |
|
|
|
/** |
|
* @global string $cfg['Export']['sql_structure_or_data'] |
|
*/ |
|
$cfg['Export']['sql_structure_or_data'] = 'structure_and_data'; |
|
|
|
/** |
|
* @global string $cfg['Export']['sql_compatibility'] |
|
*/ |
|
$cfg['Export']['sql_compatibility'] = 'NONE'; |
|
|
|
/** |
|
* Whether to include comments in SQL export. |
|
* |
|
* @global string $cfg['Export']['sql_include_comments'] |
|
*/ |
|
$cfg['Export']['sql_include_comments'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_disable_fk'] |
|
*/ |
|
$cfg['Export']['sql_disable_fk'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_views_as_tables'] |
|
*/ |
|
$cfg['Export']['sql_views_as_tables'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_metadata'] |
|
*/ |
|
$cfg['Export']['sql_metadata'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_use_transaction'] |
|
*/ |
|
$cfg['Export']['sql_use_transaction'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_create_database'] |
|
*/ |
|
$cfg['Export']['sql_create_database'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_drop_database'] |
|
*/ |
|
$cfg['Export']['sql_drop_database'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_drop_table'] |
|
*/ |
|
$cfg['Export']['sql_drop_table'] = false; |
|
|
|
/** |
|
* true by default for correct behavior when dealing with exporting |
|
* of VIEWs and the stand-in table |
|
* |
|
* @global boolean $cfg['Export']['sql_if_not_exists'] |
|
*/ |
|
$cfg['Export']['sql_if_not_exists'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_view_current_user'] |
|
*/ |
|
$cfg['Export']['sql_view_current_user'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_or_replace'] |
|
*/ |
|
$cfg['Export']['sql_or_replace_view'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_procedure_function'] |
|
*/ |
|
$cfg['Export']['sql_procedure_function'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_create_table'] |
|
*/ |
|
$cfg['Export']['sql_create_table'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_create_view'] |
|
*/ |
|
$cfg['Export']['sql_create_view'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_create_trigger'] |
|
*/ |
|
$cfg['Export']['sql_create_trigger'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_auto_increment'] |
|
*/ |
|
$cfg['Export']['sql_auto_increment'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_backquotes'] |
|
*/ |
|
$cfg['Export']['sql_backquotes'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_dates'] |
|
*/ |
|
$cfg['Export']['sql_dates'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_relation'] |
|
*/ |
|
$cfg['Export']['sql_relation'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_truncate'] |
|
*/ |
|
$cfg['Export']['sql_truncate'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_delayed'] |
|
*/ |
|
$cfg['Export']['sql_delayed'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_ignore'] |
|
*/ |
|
$cfg['Export']['sql_ignore'] = false; |
|
|
|
/** |
|
* Export time in UTC. |
|
* |
|
* @global boolean $cfg['Export']['sql_utc_time'] |
|
*/ |
|
$cfg['Export']['sql_utc_time'] = true; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_hex_for_binary'] |
|
*/ |
|
$cfg['Export']['sql_hex_for_binary'] = true; |
|
|
|
/** |
|
* insert/update/replace |
|
* |
|
* @global string $cfg['Export']['sql_type'] |
|
*/ |
|
$cfg['Export']['sql_type'] = 'INSERT'; |
|
|
|
/** |
|
* @global integer $cfg['Export']['sql_max_query_size'] |
|
*/ |
|
$cfg['Export']['sql_max_query_size'] = 50000; |
|
|
|
/** |
|
* @global boolean $cfg['Export']['sql_mime'] |
|
*/ |
|
$cfg['Export']['sql_mime'] = false; |
|
|
|
/** |
|
* \n is replaced by new line |
|
* |
|
* @global string $cfg['Export']['sql_header_comment'] |
|
*/ |
|
$cfg['Export']['sql_header_comment'] = ''; |
|
|
|
/** |
|
* Whether to use complete inserts, extended inserts, both, or neither |
|
* |
|
* @global string $cfg['Export']['sql_insert_syntax'] |
|
*/ |
|
$cfg['Export']['sql_insert_syntax'] = 'both'; |
|
|
|
/** |
|
* @global string $cfg['Export']['pdf_report_title'] |
|
*/ |
|
$cfg['Export']['pdf_report_title'] = ''; |
|
|
|
/** |
|
* @global string $cfg['Export']['xml_structure_or_data'] |
|
*/ |
|
$cfg['Export']['xml_structure_or_data'] = 'data'; |
|
|
|
/** |
|
* Export schema for each structure |
|
* |
|
* @global string $cfg['Export']['xml_export_struc'] |
|
*/ |
|
$cfg['Export']['xml_export_struc'] = true; |
|
|
|
/** |
|
* Export events |
|
* |
|
* @global string $cfg['Export']['xml_export_events'] |
|
*/ |
|
$cfg['Export']['xml_export_events'] = true; |
|
|
|
/** |
|
* Export functions |
|
* |
|
* @global string $cfg['Export']['xml_export_functions'] |
|
*/ |
|
$cfg['Export']['xml_export_functions'] = true; |
|
|
|
/** |
|
* Export procedures |
|
* |
|
* @global string $cfg['Export']['xml_export_procedures'] |
|
*/ |
|
$cfg['Export']['xml_export_procedures'] = true; |
|
|
|
/** |
|
* Export schema for each table |
|
* |
|
* @global string $cfg['Export']['xml_export_tables'] |
|
*/ |
|
$cfg['Export']['xml_export_tables'] = true; |
|
|
|
/** |
|
* Export triggers |
|
* |
|
* @global string $cfg['Export']['xml_export_triggers'] |
|
*/ |
|
$cfg['Export']['xml_export_triggers'] = true; |
|
|
|
/** |
|
* Export views |
|
* |
|
* @global string $cfg['Export']['xml_export_views'] |
|
*/ |
|
$cfg['Export']['xml_export_views'] = true; |
|
|
|
/** |
|
* Export contents data |
|
* |
|
* @global string $cfg['Export']['xml_export_contents'] |
|
*/ |
|
$cfg['Export']['xml_export_contents'] = true; |
|
|
|
/** |
|
* @global string $cfg['Export']['yaml_structure_or_data'] |
|
*/ |
|
$cfg['Export']['yaml_structure_or_data'] = 'data'; |
|
|
|
/******************************************************************************* |
|
* Import defaults |
|
*/ |
|
$cfg['Import'] = []; |
|
|
|
/** |
|
* @global string $cfg['Import']['format'] |
|
*/ |
|
$cfg['Import']['format'] = 'sql'; |
|
|
|
/** |
|
* Default charset for import. |
|
* |
|
* @global string $cfg['Import']['charset'] |
|
*/ |
|
$cfg['Import']['charset'] = ''; |
|
|
|
/** |
|
* @global boolean $cfg['Import']['allow_interrupt'] |
|
*/ |
|
$cfg['Import']['allow_interrupt'] = true; |
|
|
|
/** |
|
* @global integer $cfg['Import']['skip_queries'] |
|
*/ |
|
$cfg['Import']['skip_queries'] = 0; |
|
|
|
/** |
|
* @global string $cfg['Import']['sql_compatibility'] |
|
*/ |
|
$cfg['Import']['sql_compatibility'] = 'NONE'; |
|
|
|
/** |
|
* @global string $cfg['Import']['sql_no_auto_value_on_zero'] |
|
*/ |
|
$cfg['Import']['sql_no_auto_value_on_zero'] = true; |
|
|
|
/** |
|
* @global string $cfg['Import']['sql_read_as_multibytes'] |
|
*/ |
|
$cfg['Import']['sql_read_as_multibytes'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Import']['csv_replace'] |
|
*/ |
|
$cfg['Import']['csv_replace'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Import']['csv_ignore'] |
|
*/ |
|
$cfg['Import']['csv_ignore'] = false; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_terminated'] |
|
*/ |
|
$cfg['Import']['csv_terminated'] = ','; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_enclosed'] |
|
*/ |
|
$cfg['Import']['csv_enclosed'] = '"'; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_escaped'] |
|
*/ |
|
$cfg['Import']['csv_escaped'] = '"'; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_new_line'] |
|
*/ |
|
$cfg['Import']['csv_new_line'] = 'auto'; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_columns'] |
|
*/ |
|
$cfg['Import']['csv_columns'] = ''; |
|
|
|
/** |
|
* @global string $cfg['Import']['csv_col_names'] |
|
*/ |
|
$cfg['Import']['csv_col_names'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Import']['ldi_replace'] |
|
*/ |
|
$cfg['Import']['ldi_replace'] = false; |
|
|
|
/** |
|
* @global boolean $cfg['Import']['ldi_ignore'] |
|
*/ |
|
$cfg['Import']['ldi_ignore'] = false; |
|
|
|
/** |
|
* @global string $cfg['Import']['ldi_terminated'] |
|
*/ |
|
$cfg['Import']['ldi_terminated'] = ';'; |
|
|
|
/** |
|
* @global string $cfg['Import']['ldi_enclosed'] |
|
*/ |
|
$cfg['Import']['ldi_enclosed'] = '"'; |
|
|
|
/** |
|
* @global string $cfg['Import']['ldi_escaped'] |
|
*/ |
|
$cfg['Import']['ldi_escaped'] = '\\'; |
|
|
|
/** |
|
* @global string $cfg['Import']['ldi_new_line'] |
|
*/ |
|
$cfg['Import']['ldi_new_line'] = 'auto'; |
|
|
|
/** |
|
* @global string $cfg['Import']['ldi_columns'] |
|
*/ |
|
$cfg['Import']['ldi_columns'] = ''; |
|
|
|
/** |
|
* 'auto' for auto-detection, true or false for forcing |
|
* |
|
* @global string $cfg['Import']['ldi_local_option'] |
|
*/ |
|
$cfg['Import']['ldi_local_option'] = 'auto'; |
|
|
|
/** |
|
* @global string $cfg['Import']['ods_col_names'] |
|
*/ |
|
$cfg['Import']['ods_col_names'] = false; |
|
|
|
/** |
|
* @global string $cfg['Import']['ods_empty_rows'] |
|
*/ |
|
$cfg['Import']['ods_empty_rows'] = true; |
|
|
|
/** |
|
* @global string $cfg['Import']['ods_recognize_percentages'] |
|
*/ |
|
$cfg['Import']['ods_recognize_percentages'] = true; |
|
|
|
/** |
|
* @global string $cfg['Import']['ods_recognize_currency'] |
|
*/ |
|
$cfg['Import']['ods_recognize_currency'] = true; |
|
|
|
/******************************************************************************* |
|
* Schema export defaults |
|
*/ |
|
$cfg['Schema'] = []; |
|
|
|
/** |
|
* pdf/eps/dia/svg |
|
* |
|
* @global string $cfg['Schema']['format'] |
|
*/ |
|
$cfg['Schema']['format'] = 'pdf'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_show_color'] |
|
*/ |
|
$cfg['Schema']['pdf_show_color'] = true; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_show_keys'] |
|
*/ |
|
$cfg['Schema']['pdf_show_keys'] = false; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_all_tables_same_width'] |
|
*/ |
|
$cfg['Schema']['pdf_all_tables_same_width'] = false; |
|
|
|
/** |
|
* L/P |
|
* |
|
* @global string $cfg['Schema']['pdf_orientation'] |
|
*/ |
|
$cfg['Schema']['pdf_orientation'] = 'L'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_paper'] |
|
*/ |
|
$cfg['Schema']['pdf_paper'] = 'A4'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_show_grid'] |
|
*/ |
|
$cfg['Schema']['pdf_show_grid'] = false; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_with_doc'] |
|
*/ |
|
$cfg['Schema']['pdf_with_doc'] = true; |
|
|
|
/** |
|
* @global string $cfg['Schema']['pdf_table_order'] |
|
*/ |
|
$cfg['Schema']['pdf_table_order'] = ''; |
|
|
|
/** |
|
* @global string $cfg['Schema']['dia_show_color'] |
|
*/ |
|
$cfg['Schema']['dia_show_color'] = true; |
|
|
|
/** |
|
* @global string $cfg['Schema']['dia_show_keys'] |
|
*/ |
|
$cfg['Schema']['dia_show_keys'] = false; |
|
|
|
/** |
|
* L/P |
|
* |
|
* @global string $cfg['Schema']['dia_orientation'] |
|
*/ |
|
$cfg['Schema']['dia_orientation'] = 'L'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['dia_paper'] |
|
*/ |
|
$cfg['Schema']['dia_paper'] = 'A4'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['eps_show_color'] |
|
*/ |
|
$cfg['Schema']['eps_show_color'] = true; |
|
|
|
/** |
|
* @global string $cfg['Schema']['eps_show_keys'] |
|
*/ |
|
$cfg['Schema']['eps_show_keys'] = false; |
|
|
|
/** |
|
* @global string $cfg['Schema']['eps_all_tables_same_width'] |
|
*/ |
|
$cfg['Schema']['eps_all_tables_same_width'] = false; |
|
|
|
/** |
|
* L/P |
|
* |
|
* @global string $cfg['Schema']['eps_orientation'] |
|
*/ |
|
$cfg['Schema']['eps_orientation'] = 'L'; |
|
|
|
/** |
|
* @global string $cfg['Schema']['svg_show_color'] |
|
*/ |
|
$cfg['Schema']['svg_show_color'] = true; |
|
|
|
/** |
|
* @global string $cfg['Schema']['svg_show_keys'] |
|
*/ |
|
$cfg['Schema']['svg_show_keys'] = false; |
|
|
|
/** |
|
* @global string $cfg['Schema']['svg_all_tables_same_width'] |
|
*/ |
|
$cfg['Schema']['svg_all_tables_same_width'] = false; |
|
|
|
/******************************************************************************* |
|
* PDF options |
|
*/ |
|
|
|
/** |
|
* @global array $cfg['PDFPageSizes'] |
|
*/ |
|
$cfg['PDFPageSizes'] = [ |
|
'A3', |
|
'A4', |
|
'A5', |
|
'letter', |
|
'legal', |
|
]; |
|
|
|
/** |
|
* @global string $cfg['PDFDefaultPageSize'] |
|
*/ |
|
$cfg['PDFDefaultPageSize'] = 'A4'; |
|
|
|
|
|
/******************************************************************************* |
|
* Language and character set conversion settings |
|
*/ |
|
|
|
/** |
|
* Default language to use, if not browser-defined or user-defined |
|
* |
|
* @global string $cfg['DefaultLang'] |
|
*/ |
|
$cfg['DefaultLang'] = 'en'; |
|
|
|
/** |
|
* Default connection collation |
|
* |
|
* @global string $cfg['DefaultConnectionCollation'] |
|
*/ |
|
$cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci'; |
|
|
|
/** |
|
* Force: always use this language, e.g. 'en' |
|
* |
|
* @global string $cfg['Lang'] |
|
*/ |
|
$cfg['Lang'] = ''; |
|
|
|
/** |
|
* Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and |
|
* English only |
|
* |
|
* @global string $cfg['FilterLanguages'] |
|
*/ |
|
$cfg['FilterLanguages'] = ''; |
|
|
|
/** |
|
* You can select here which functions will be used for character set conversion. |
|
* Possible values are: |
|
* auto - automatically use available one (first is tested iconv, then |
|
* recode) |
|
* iconv - use iconv or libiconv functions |
|
* recode - use recode_string function |
|
* mb - use mbstring extension |
|
* none - disable encoding conversion |
|
* |
|
* @global string $cfg['RecodingEngine'] |
|
*/ |
|
$cfg['RecodingEngine'] = 'auto'; |
|
|
|
/** |
|
* Specify some parameters for iconv used in character set conversion. See iconv |
|
* documentation for details: |
|
* https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html |
|
* |
|
* @global string $cfg['IconvExtraParams'] |
|
*/ |
|
$cfg['IconvExtraParams'] = '//TRANSLIT'; |
|
|
|
/** |
|
* Available character sets for MySQL conversion. currently contains all which could |
|
* be found in lang/* files and few more. |
|
* Character sets will be shown in same order as here listed, so if you frequently |
|
* use some of these move them to the top. |
|
* |
|
* @global array $cfg['AvailableCharsets'] |
|
*/ |
|
$cfg['AvailableCharsets'] = [ |
|
'iso-8859-1', |
|
'iso-8859-2', |
|
'iso-8859-3', |
|
'iso-8859-4', |
|
'iso-8859-5', |
|
'iso-8859-6', |
|
'iso-8859-7', |
|
'iso-8859-8', |
|
'iso-8859-9', |
|
'iso-8859-10', |
|
'iso-8859-11', |
|
'iso-8859-12', |
|
'iso-8859-13', |
|
'iso-8859-14', |
|
'iso-8859-15', |
|
'windows-1250', |
|
'windows-1251', |
|
'windows-1252', |
|
'windows-1256', |
|
'windows-1257', |
|
'koi8-r', |
|
'big5', |
|
'gb2312', |
|
'utf-16', |
|
'utf-8', |
|
'utf-7', |
|
'x-user-defined', |
|
'euc-jp', |
|
'ks_c_5601-1987', |
|
'tis-620', |
|
'SHIFT_JIS', |
|
'SJIS', |
|
'SJIS-win', |
|
]; |
|
|
|
|
|
/******************************************************************************* |
|
* Customization & design |
|
* |
|
* The graphical settings are now located in themes/theme-name/scss/_variables.scss |
|
*/ |
|
|
|
/** |
|
* enable the left panel pointer |
|
* |
|
* @global boolean $cfg['NavigationTreePointerEnable'] |
|
*/ |
|
$cfg['NavigationTreePointerEnable'] = true; |
|
|
|
/** |
|
* enable the browse pointer |
|
* |
|
* @global boolean $cfg['BrowsePointerEnable'] |
|
*/ |
|
$cfg['BrowsePointerEnable'] = true; |
|
|
|
/** |
|
* enable the browse marker |
|
* |
|
* @global boolean $cfg['BrowseMarkerEnable'] |
|
*/ |
|
$cfg['BrowseMarkerEnable'] = true; |
|
|
|
/** |
|
* textarea size (columns) in edit mode |
|
* (this value will be emphasized (*2) for SQL |
|
* query textareas and (*1.25) for query window) |
|
* |
|
* @global integer $cfg['TextareaCols'] |
|
*/ |
|
$cfg['TextareaCols'] = 40; |
|
|
|
/** |
|
* textarea size (rows) in edit mode |
|
* |
|
* @global integer $cfg['TextareaRows'] |
|
*/ |
|
$cfg['TextareaRows'] = 15; |
|
|
|
/** |
|
* double size of textarea size for LONGTEXT columns |
|
* |
|
* @global boolean $cfg['LongtextDoubleTextarea'] |
|
*/ |
|
$cfg['LongtextDoubleTextarea'] = true; |
|
|
|
/** |
|
* auto-select when clicking in the textarea of the query-box |
|
* |
|
* @global boolean $cfg['TextareaAutoSelect'] |
|
*/ |
|
$cfg['TextareaAutoSelect'] = false; |
|
|
|
/** |
|
* textarea size (columns) for CHAR/VARCHAR |
|
* |
|
* @global integer $cfg['CharTextareaCols'] |
|
*/ |
|
$cfg['CharTextareaCols'] = 40; |
|
|
|
/** |
|
* textarea size (rows) for CHAR/VARCHAR |
|
* |
|
* @global integer $cfg['CharTextareaRows'] |
|
*/ |
|
$cfg['CharTextareaRows'] = 7; |
|
|
|
/** |
|
* Max field data length in browse mode for all non-numeric fields |
|
* |
|
* @global integer $cfg['LimitChars'] |
|
*/ |
|
$cfg['LimitChars'] = 50; |
|
|
|
/** |
|
* Where to show the edit/copy/delete links in browse mode |
|
* Possible values are 'left', 'right', 'both' and 'none'. |
|
* |
|
* @global string $cfg['RowActionLinks'] |
|
*/ |
|
$cfg['RowActionLinks'] = 'left'; |
|
|
|
/** |
|
* Whether to show row links (Edit, Copy, Delete) and checkboxes for |
|
* multiple row operations even when the selection does not have a unique key. |
|
* |
|
* @global boolean $cfg['RowActionLinksWithoutUnique'] |
|
*/ |
|
$cfg['RowActionLinksWithoutUnique'] = false; |
|
|
|
/** |
|
* Default sort order by primary key. |
|
* |
|
* @global string $cfg['TablePrimaryKeyOrder'] |
|
*/ |
|
$cfg['TablePrimaryKeyOrder'] = 'NONE'; |
|
|
|
/** |
|
* remember the last way a table sorted |
|
* |
|
* @global string $cfg['RememberSorting'] |
|
*/ |
|
$cfg['RememberSorting'] = true; |
|
|
|
/** |
|
* shows column comments in 'browse' mode. |
|
* |
|
* @global boolean $cfg['ShowBrowseComments'] |
|
*/ |
|
$cfg['ShowBrowseComments'] = true; |
|
|
|
/** |
|
* shows column comments in 'table property' mode. |
|
* |
|
* @global boolean $cfg['ShowPropertyComments'] |
|
*/ |
|
$cfg['ShowPropertyComments'] = true; |
|
|
|
/** |
|
* repeat header names every X cells? (0 = deactivate) |
|
* |
|
* @global integer $cfg['RepeatCells'] |
|
*/ |
|
$cfg['RepeatCells'] = 100; |
|
|
|
/** |
|
* Set to true if you want DB-based query history.If false, this utilizes |
|
* JS-routines to display query history (lost by window close) |
|
* |
|
* @global boolean $cfg['QueryHistoryDB'] |
|
*/ |
|
$cfg['QueryHistoryDB'] = false; |
|
|
|
/** |
|
* When using DB-based query history, how many entries should be kept? |
|
* |
|
* @global integer $cfg['QueryHistoryMax'] |
|
*/ |
|
$cfg['QueryHistoryMax'] = 25; |
|
|
|
/** |
|
* Use MIME-Types (stored in column comments table) for |
|
* |
|
* @global boolean $cfg['BrowseMIME'] |
|
*/ |
|
$cfg['BrowseMIME'] = true; |
|
|
|
/** |
|
* When approximate count < this, PMA will get exact count for table rows. |
|
* |
|
* @global integer $cfg['MaxExactCount'] |
|
*/ |
|
$cfg['MaxExactCount'] = 50000; |
|
|
|
/** |
|
* Zero means that no row count is done for views; see the doc |
|
* |
|
* @global integer $cfg['MaxExactCountViews'] |
|
*/ |
|
$cfg['MaxExactCountViews'] = 0; |
|
|
|
/** |
|
* Sort table and database in natural order |
|
* |
|
* @global boolean $cfg['NaturalOrder'] |
|
*/ |
|
$cfg['NaturalOrder'] = true; |
|
|
|
/** |
|
* Initial state for sliders |
|
* (open | closed | disabled) |
|
* |
|
* @global string $cfg['InitialSlidersState'] |
|
*/ |
|
$cfg['InitialSlidersState'] = 'closed'; |
|
|
|
/** |
|
* User preferences: disallow these settings |
|
* For possible setting names look in libraries/config/user_preferences.forms.php |
|
* |
|
* @global array $cfg['UserprefsDisallow'] |
|
*/ |
|
$cfg['UserprefsDisallow'] = []; |
|
|
|
/** |
|
* User preferences: enable the Developer tab |
|
*/ |
|
$cfg['UserprefsDeveloperTab'] = false; |
|
|
|
/******************************************************************************* |
|
* Window title settings |
|
*/ |
|
|
|
/** |
|
* title of browser window when a table is selected |
|
* |
|
* @global string $cfg['TitleTable'] |
|
*/ |
|
$cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@'; |
|
|
|
/** |
|
* title of browser window when a database is selected |
|
* |
|
* @global string $cfg['TitleDatabase'] |
|
*/ |
|
$cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@'; |
|
|
|
/** |
|
* title of browser window when a server is selected |
|
* |
|
* @global string $cfg['TitleServer'] |
|
*/ |
|
$cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@'; |
|
|
|
/** |
|
* title of browser window when nothing is selected |
|
* |
|
* @global string $cfg['TitleDefault'] |
|
*/ |
|
$cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@'; |
|
|
|
|
|
/******************************************************************************* |
|
* theme manager |
|
*/ |
|
|
|
/** |
|
* if you want to use selectable themes and if ThemesPath not empty |
|
* set it to true, else set it to false (default is false); |
|
* |
|
* @global boolean $cfg['ThemeManager'] |
|
*/ |
|
$cfg['ThemeManager'] = true; |
|
|
|
/** |
|
* set up default theme, you can set up here an valid |
|
* path to themes or 'original' for the original pma-theme |
|
* |
|
* @global string $cfg['ThemeDefault'] |
|
*/ |
|
$cfg['ThemeDefault'] = 'pmahomme'; |
|
|
|
/** |
|
* allow different theme for each configured server |
|
* |
|
* @global boolean $cfg['ThemePerServer'] |
|
*/ |
|
$cfg['ThemePerServer'] = false; |
|
|
|
|
|
/** |
|
* Default query for table |
|
* |
|
* @global string $cfg['DefaultQueryTable'] |
|
*/ |
|
$cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1'; |
|
|
|
/** |
|
* Default query for database |
|
* |
|
* @global string $cfg['DefaultQueryDatabase'] |
|
*/ |
|
$cfg['DefaultQueryDatabase'] = ''; |
|
|
|
|
|
/******************************************************************************* |
|
* SQL Query box settings |
|
* These are the links display in all of the SQL Query boxes |
|
* |
|
* @global array $cfg['SQLQuery'] |
|
*/ |
|
$cfg['SQLQuery'] = []; |
|
|
|
/** |
|
* Display an "Edit" link on the results page to change a query |
|
* |
|
* @global boolean $cfg['SQLQuery']['Edit'] |
|
*/ |
|
$cfg['SQLQuery']['Edit'] = true; |
|
|
|
/** |
|
* Display an "Explain SQL" link on the results page |
|
* |
|
* @global boolean $cfg['SQLQuery']['Explain'] |
|
*/ |
|
$cfg['SQLQuery']['Explain'] = true; |
|
|
|
/** |
|
* Display a "Create PHP code" link on the results page to wrap a query in PHP |
|
* |
|
* @global boolean $cfg['SQLQuery']['ShowAsPHP'] |
|
*/ |
|
$cfg['SQLQuery']['ShowAsPHP'] = true; |
|
|
|
/** |
|
* Display a "Refresh" link on the results page |
|
* |
|
* @global boolean $cfg['SQLQuery']['Refresh'] |
|
*/ |
|
$cfg['SQLQuery']['Refresh'] = true; |
|
|
|
/** |
|
* Enables autoComplete for table & column names in SQL queries |
|
* |
|
* default = 'true' |
|
*/ |
|
$cfg['EnableAutocompleteForTablesAndColumns'] = true; |
|
|
|
|
|
/******************************************************************************* |
|
* Web server upload/save/import directories |
|
*/ |
|
|
|
/** |
|
* Directory for uploaded files that can be executed by phpMyAdmin. |
|
* For example './upload'. Leave empty for no upload directory support. |
|
* Use %u for username inclusion. |
|
* |
|
* @global string $cfg['UploadDir'] |
|
*/ |
|
$cfg['UploadDir'] = ''; |
|
|
|
/** |
|
* Directory where phpMyAdmin can save exported data on server. |
|
* For example './save'. Leave empty for no save directory support. |
|
* Use %u for username inclusion. |
|
* |
|
* @global string $cfg['SaveDir'] |
|
*/ |
|
$cfg['SaveDir'] = ''; |
|
|
|
/** |
|
* Directory where phpMyAdmin can save temporary files. |
|
* |
|
* @global string $cfg['TempDir'] |
|
*/ |
|
if (defined('TEMP_DIR')) { |
|
$cfg['TempDir'] = TEMP_DIR; |
|
} else { |
|
$cfg['TempDir'] = ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR; |
|
} |
|
|
|
/** |
|
* Misc. settings |
|
*/ |
|
|
|
/** |
|
* Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection, |
|
* which is the only safe way to determine GD version. |
|
* |
|
* @global string $cfg['GD2Available'] |
|
*/ |
|
$cfg['GD2Available'] = 'auto'; |
|
|
|
/** |
|
* Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny |
|
* |
|
* @global array $cfg['TrustedProxies'] |
|
*/ |
|
$cfg['TrustedProxies'] = []; |
|
|
|
/** |
|
* We normally check the permissions on the configuration file to ensure |
|
* it's not world writable. However, phpMyAdmin could be installed on |
|
* a NTFS filesystem mounted on a non-Windows server, in which case the |
|
* permissions seems wrong but in fact cannot be detected. In this case |
|
* a sysadmin would set the following to false. |
|
*/ |
|
$cfg['CheckConfigurationPermissions'] = true; |
|
|
|
/** |
|
* Limit for length of URL in links. When length would be above this limit, it |
|
* is replaced by form with button. |
|
* This is required as some web servers (IIS) have problems with long URLs. |
|
* The recommended limit is 2000 |
|
* (see https://www.boutell.com/newfaq/misc/urllength.html) but we put |
|
* 1000 to accommodate Suhosin, see bug #3358750. |
|
*/ |
|
$cfg['LinkLengthLimit'] = 1000; |
|
|
|
/** |
|
* Additional string to allow in CSP headers. |
|
*/ |
|
$cfg['CSPAllow'] = ''; |
|
|
|
/** |
|
* Disable the table maintenance mass operations, like optimizing or |
|
* repairing the selected tables of a database. An accidental execution |
|
* of such a maintenance task can enormously slow down a bigger database. |
|
*/ |
|
$cfg['DisableMultiTableMaintenance'] = false; |
|
|
|
/** |
|
* Whether or not to query the user before sending the error report to |
|
* the phpMyAdmin team when a JavaScript error occurs |
|
* |
|
* Available options |
|
* (ask | always | never) |
|
* |
|
* @global string $cfg['SendErrorReports'] |
|
*/ |
|
$cfg['SendErrorReports'] = 'ask'; |
|
|
|
/** |
|
* Whether Enter or Ctrl+Enter executes queries in the console. |
|
* |
|
* @global boolean $cfg['ConsoleEnterExecutes'] |
|
*/ |
|
$cfg['ConsoleEnterExecutes'] = false; |
|
|
|
/** |
|
* Zero Configuration mode. |
|
* |
|
* @global boolean $cfg['ZeroConf'] |
|
*/ |
|
$cfg['ZeroConf'] = true; |
|
|
|
/******************************************************************************* |
|
* Developers ONLY! |
|
* |
|
* @global array $cfg['DBG'] |
|
*/ |
|
$cfg['DBG'] = []; |
|
|
|
/** |
|
* Output executed queries and their execution times |
|
* |
|
* @global boolean $cfg['DBG']['sql'] |
|
*/ |
|
$cfg['DBG']['sql'] = false; |
|
|
|
/** |
|
* Log executed queries and their execution times to syslog |
|
* |
|
* @global boolean $cfg['DBG']['sqllog'] |
|
*/ |
|
$cfg['DBG']['sqllog'] = false; |
|
|
|
/** |
|
* Enable to let server present itself as demo server. |
|
* |
|
* @global boolean $cfg['DBG']['demo'] |
|
*/ |
|
$cfg['DBG']['demo'] = false; |
|
|
|
/** |
|
* Enable Simple two-factor authentication |
|
* |
|
* @global boolean $cfg['DBG']['simple2fa'] |
|
*/ |
|
$cfg['DBG']['simple2fa'] = false; |
|
|
|
/** |
|
* Sets the working environment |
|
* |
|
* This only needs to be changed when you are developing phpMyAdmin itself. |
|
* The development mode may display debug information in some places. |
|
* |
|
* Possible values are 'production' or 'development' |
|
*/ |
|
$cfg['environment'] = 'production'; |
|
|
|
/******************************************************************************* |
|
* MySQL settings |
|
*/ |
|
|
|
/** |
|
* Default functions for above defined groups |
|
* |
|
* @global array $cfg['DefaultFunctions'] |
|
*/ |
|
$cfg['DefaultFunctions'] = [ |
|
'FUNC_CHAR' => '', |
|
'FUNC_DATE' => '', |
|
'FUNC_NUMBER' => '', |
|
'FUNC_SPATIAL' => 'GeomFromText', |
|
'FUNC_UUID' => 'UUID', |
|
'first_timestamp' => 'NOW', |
|
]; |
|
|
|
/** |
|
* Max rows retrieved for zoom search |
|
*/ |
|
$cfg['maxRowPlotLimit'] = 500; |
|
|
|
/** |
|
* Show Git revision if applicable |
|
* |
|
* @global boolean $cfg['ShowGitRevision'] |
|
*/ |
|
$cfg['ShowGitRevision'] = true; |
|
|
|
/** |
|
* MySQL minimal version required |
|
* |
|
* @global array $cfg['MysqlMinVersion'] |
|
*/ |
|
$cfg['MysqlMinVersion'] = [ |
|
'internal' => 50500, |
|
'human' => '5.5.0', |
|
]; |
|
|
|
/** |
|
* Disable shortcuts |
|
* |
|
* @global array $cfg['DisableShortcutKeys'] |
|
*/ |
|
$cfg['DisableShortcutKeys'] = false; |
|
|
|
/** |
|
* Console configuration |
|
* |
|
* This is mostly meant for user preferences. |
|
*/ |
|
$cfg['Console'] = [ |
|
'StartHistory' => false, |
|
'AlwaysExpand' => false, |
|
'CurrentQuery' => true, |
|
'EnterExecutes' => false, |
|
'DarkTheme' => false, |
|
'Mode' => 'info', |
|
'Height' => 92, |
|
'GroupQueries' => false, |
|
'OrderBy' => 'exec', |
|
'Order' => 'asc', |
|
]; |
|
|
|
|
|
/******************************************************************************* |
|
* Default options for transformations |
|
*/ |
|
|
|
/** |
|
* Initialize default transformations array |
|
* |
|
* @global array $cfg['DefaultTransformations'] |
|
*/ |
|
$cfg['DefaultTransformations'] = []; |
|
|
|
/** |
|
* Default transformations for Substring |
|
* |
|
* @global array $cfg['DefaultTransformations']['Substring'] |
|
*/ |
|
$cfg['DefaultTransformations']['Substring'] = [ |
|
0, |
|
'all', |
|
'…', |
|
]; |
|
|
|
/** |
|
* Default transformations for Bool2Text |
|
* |
|
* @global array $cfg['DefaultTransformations']['Bool2Text'] |
|
*/ |
|
$cfg['DefaultTransformations']['Bool2Text'] = [ |
|
'T', |
|
'F', |
|
]; |
|
|
|
/** |
|
* Default transformations for External |
|
* |
|
* @global array $cfg['DefaultTransformations']['External'] |
|
*/ |
|
$cfg['DefaultTransformations']['External'] = [ |
|
0, |
|
'-f /dev/null -i -wrap -q', |
|
1, |
|
1, |
|
]; |
|
|
|
/** |
|
* Default transformations for PreApPend |
|
* |
|
* @global array $cfg['DefaultTransformations']['PreApPend'] |
|
*/ |
|
$cfg['DefaultTransformations']['PreApPend'] = [ |
|
'', |
|
'', |
|
]; |
|
|
|
/** |
|
* Default transformations for Hex |
|
* |
|
* @global array $cfg['DefaultTransformations']['Hex'] |
|
*/ |
|
$cfg['DefaultTransformations']['Hex'] = ['2']; |
|
|
|
/** |
|
* Default transformations for DateFormat |
|
* |
|
* @global array $cfg['DefaultTransformations']['DateFormat'] |
|
*/ |
|
$cfg['DefaultTransformations']['DateFormat'] = [ |
|
0, |
|
'', |
|
'local', |
|
]; |
|
|
|
/** |
|
* Set default for FirstDayOfCalendar |
|
* |
|
* @global integer $cfg['FirstDayOfCalendar'] |
|
*/ |
|
$cfg['FirstDayOfCalendar'] = 0; |
|
|
|
/** |
|
* Default transformations for Inline |
|
* |
|
* @global array $cfg['DefaultTransformations']['Inline'] |
|
*/ |
|
$cfg['DefaultTransformations']['Inline'] = [ |
|
'100', |
|
100, |
|
]; |
|
$cfg['DefaultTransformations']['Inline']['wrapper_link'] = null; |
|
$cfg['DefaultTransformations']['Inline']['wrapper_params'] = []; |
|
|
|
/** |
|
* Default transformations for TextImageLink |
|
* |
|
* @global array $cfg['DefaultTransformations']['TextImageLink'] |
|
*/ |
|
$cfg['DefaultTransformations']['TextImageLink'] = [ |
|
null, |
|
100, |
|
50, |
|
]; |
|
|
|
/** |
|
* Default transformations for TextLink |
|
* |
|
* @global array $cfg['DefaultTransformations']['TextLink'] |
|
*/ |
|
$cfg['DefaultTransformations']['TextLink'] = [ |
|
null, |
|
null, |
|
null, |
|
];
|
|
|