Translated using Weblate.
[phpmyadmin.git] / libraries / config.default.php
blob34a5fea6cc67eeb5ff17b7f114446c1c4316d230
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * <code>
5 * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
6 * NN N O O !! D D O O NN N O O T E D D I T !!
7 * N N N O O !! D D O O N N N O O T EEEE D D I T !!
8 * N NN O O D D O O N NN O O T E D D I T
9 * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
10 * </code>
12 * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
14 * phpMyAdmin default configuration, you can copy values from here to your
15 * config.inc.php
17 * All directives are explained in Documentation.html
19 * @package PhpMyAdmin
22 /**
23 * Your phpMyAdmin URL.
25 * Complete the variable below with the full URL ie
26 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
28 * It must contain characters that are valid for a URL, and the path is
29 * case sensitive on some Web servers, for example Unix-based servers.
31 * In most cases you can leave this variable empty, as the correct value
32 * will be detected automatically. However, we recommend that you do
33 * test to see that the auto-detection code works in your system. A good
34 * test is to browse a table, then edit a row and save it. There will be
35 * an error message if phpMyAdmin cannot auto-detect the correct value.
37 * @global string $cfg['PmaAbsoluteUri']
39 $cfg['PmaAbsoluteUri'] = '';
41 /**
42 * Disable the default warning that is displayed on the DB Details Structure page if
43 * any of the required Tables for the configuration storage could not be found
45 * @global boolean $cfg['PmaNoRelation_DisableWarning']
47 $cfg['PmaNoRelation_DisableWarning'] = false;
49 /**
50 * Disable the default warning that is displayed if Suhosin is detected
52 * @global boolean $cfg['SuhosinDisableWarning']
54 $cfg['SuhosinDisableWarning'] = false;
56 /**
57 * Disable the default warning that is displayed if mcrypt is missing for
58 * cookie authentication.
60 * @global boolean $cfg['McryptDisableWarning']
62 $cfg['McryptDisableWarning'] = false;
64 /**
65 * Show warning about incomplete translations on certain threshold.
67 * @global boolean $cfg['TranslationWarningThreshold']
69 $cfg['TranslationWarningThreshold'] = 80;
71 /**
72 * Allows phpMyAdmin to be included from a document located on
73 * another domain; setting this to true is a potential security hole
75 * @global boolean $cfg['AllowThirdPartyFraming']
77 $cfg['AllowThirdPartyFraming'] = false;
79 /**
80 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
81 * at least one server configuration uses 'cookie' auth_type, enter here a
82 * pass phrase that will be used by blowfish. The maximum length seems to be 46
83 * characters.
85 * @global string $cfg['blowfish_secret']
87 $cfg['blowfish_secret'] = '';
90 /*******************************************************************************
91 * Server(s) configuration
93 * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
94 * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
95 * to ''. If you want more than one server, just copy following section
96 * (including $i incrementation) several times. There is no need to define
97 * full server array, just define values you need to change.
99 * @global array $cfg['Servers']
101 $cfg['Servers'] = array();
103 $i = 1;
106 * MySQL hostname or IP address
108 * @global string $cfg['Servers'][$i]['host']
110 $cfg['Servers'][$i]['host'] = 'localhost';
113 * MySQL port - leave blank for default port
115 * @global string $cfg['Servers'][$i]['port']
117 $cfg['Servers'][$i]['port'] = '';
120 * Path to the socket - leave blank for default socket
122 * @global string $cfg['Servers'][$i]['socket']
124 $cfg['Servers'][$i]['socket'] = '';
127 * Use SSL for connecting to MySQL server?
129 * @global boolean $cfg['Servers'][$i]['ssl']
131 $cfg['Servers'][$i]['ssl'] = false;
134 * How to connect to MySQL server ('tcp' or 'socket')
136 * @global string $cfg['Servers'][$i]['connect_type']
138 $cfg['Servers'][$i]['connect_type'] = 'tcp';
141 * The PHP MySQL extension to use ('mysql' or 'mysqli')
143 * @global string $cfg['Servers'][$i]['extension']
145 $cfg['Servers'][$i]['extension'] = 'mysqli';
148 * Use compressed protocol for the MySQL connection
150 * @global boolean $cfg['Servers'][$i]['compress']
152 $cfg['Servers'][$i]['compress'] = false;
155 * MySQL control host. This permits to use a host different than the
156 * main host, for the phpMyAdmin configuration storage. If left empty,
157 * $cfg['Servers'][$i]['host'] is used instead.
159 * @global string $cfg['Servers'][$i]['controlhost']
161 $cfg['Servers'][$i]['controlhost'] = '';
164 * MySQL control user settings (this user must have read-only
165 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
166 * used for all relational features (pmadb)
168 * @global string $cfg['Servers'][$i]['controluser']
170 $cfg['Servers'][$i]['controluser'] = '';
173 * MySQL control user settings (this user must have read-only
174 * access to the "mysql/user" and "mysql/db" tables). The controluser is also
175 * used for all relational features (pmadb)
177 * @global string $cfg['Servers'][$i]['controlpass']
179 $cfg['Servers'][$i]['controlpass'] = '';
182 * Authentication method (valid choices: config, http, signon or cookie)
184 * @global string $cfg['Servers'][$i]['auth_type']
186 $cfg['Servers'][$i]['auth_type'] = 'cookie';
189 * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
191 * @global string $cfg['Servers'][$i]['auth_http_realm']
193 $cfg['Servers'][$i]['auth_http_realm'] = '';
196 * File containing Swekey ids and login names (see /contrib);
197 * leave empty to deactivate Swekey hardware authentication
199 * @global string $cfg['Servers'][$i]['auth_swekey_config']
201 $cfg['Servers'][$i]['auth_swekey_config'] = '';
204 * MySQL user
206 * @global string $cfg['Servers'][$i]['user']
208 $cfg['Servers'][$i]['user'] = 'root';
211 * MySQL password (only needed with 'config' auth_type)
213 * @global string $cfg['Servers'][$i]['password']
215 $cfg['Servers'][$i]['password'] = '';
218 * Session to use for 'signon' authentication method
220 * @global string $cfg['Servers'][$i]['SignonSession']
222 $cfg['Servers'][$i]['SignonSession'] = '';
225 * PHP script to use for 'signon' authentication method
227 * @global string $cfg['Servers'][$i]['SignonScript']
229 $cfg['Servers'][$i]['SignonScript'] = '';
232 * URL where to redirect user to login for 'signon' authentication method
234 * @global string $cfg['Servers'][$i]['SignonURL']
236 $cfg['Servers'][$i]['SignonURL'] = '';
239 * URL where to redirect user after logout
241 * @global string $cfg['Servers'][$i]['LogoutURL']
243 $cfg['Servers'][$i]['LogoutURL'] = '';
246 * Whether to try to connect without password
248 * @global boolean $cfg['Servers'][$i]['nopassword']
250 $cfg['Servers'][$i]['nopassword'] = false;
253 * If set to a db-name, only this db is displayed in left frame
254 * It may also be an array of db-names, where sorting order is relevant.
256 * @global string $cfg['Servers'][$i]['only_db']
258 $cfg['Servers'][$i]['only_db'] = '';
261 * Database name to be hidden from listings
263 * @global string $cfg['Servers'][$i]['hide_db']
265 $cfg['Servers'][$i]['hide_db'] = '';
268 * Verbose name for this host - leave blank to show the hostname
269 * (for HTTP authentication, all non-US-ASCII characters will be stripped)
271 * @global string $cfg['Servers'][$i]['verbose']
273 $cfg['Servers'][$i]['verbose'] = '';
276 * Database used for Relation, Bookmark and PDF Features
277 * (see examples/create_tables.sql)
278 * - leave blank for no support
279 * SUGGESTED: 'phpmyadmin'
281 * @global string $cfg['Servers'][$i]['pmadb']
283 $cfg['Servers'][$i]['pmadb'] = '';
286 * Bookmark table
287 * - leave blank for no bookmark support
288 * SUGGESTED: 'pma_bookmark'
290 * @global string $cfg['Servers'][$i]['bookmarktable']
292 $cfg['Servers'][$i]['bookmarktable'] = '';
295 * table to describe the relation between links (see doc)
296 * - leave blank for no relation-links support
297 * SUGGESTED: 'pma_relation'
299 * @global string $cfg['Servers'][$i]['relation']
301 $cfg['Servers'][$i]['relation'] = '';
304 * table to describe the display fields
305 * - leave blank for no display fields support
306 * SUGGESTED: 'pma_table_info'
308 * @global string $cfg['Servers'][$i]['table_info']
310 $cfg['Servers'][$i]['table_info'] = '';
313 * table to describe the tables position for the PDF schema
314 * - leave blank for no PDF schema support
315 * SUGGESTED: 'pma_table_coords'
317 * @global string $cfg['Servers'][$i]['table_coords']
319 $cfg['Servers'][$i]['table_coords'] = '';
322 * table to describe pages of relationpdf
323 * - leave blank if you don't want to use this
324 * SUGGESTED: 'pma_pdf_pages'
326 * @global string $cfg['Servers'][$i]['pdf_pages']
328 $cfg['Servers'][$i]['pdf_pages'] = '';
331 * table to store column information
332 * - leave blank for no column comments/mime types
333 * SUGGESTED: 'pma_column_info'
335 * @global string $cfg['Servers'][$i]['column_info']
337 $cfg['Servers'][$i]['column_info'] = '';
340 * table to store SQL history
341 * - leave blank for no SQL query history
342 * SUGGESTED: 'pma_history'
344 * @global string $cfg['Servers'][$i]['history']
346 $cfg['Servers'][$i]['history'] = '';
349 * table to store the coordinates for Designer
350 * - leave blank for no Designer feature
351 * SUGGESTED: 'pma_designer_coords'
353 * @global string $cfg['Servers'][$i]['designer_coords']
355 $cfg['Servers'][$i]['designer_coords'] = '';
358 * table to store recently used tables
359 * - leave blank for no "persistent" recently used tables
360 * SUGGESTED: 'pma_recent'
362 $cfg['Servers'][$i]['recent'] = '';
365 * table to store UI preferences for tables
366 * - leave blank for no "persistent" UI preferences
367 * SUGGESTED: 'pma_table_uiprefs'
369 $cfg['Servers'][$i]['table_uiprefs'] = '';
372 * table to store SQL tracking
373 * - leave blank for no SQL tracking
374 * SUGGESTED: 'pma_tracking'
376 * @global string $cfg['Servers'][$i]['tracking']
378 $cfg['Servers'][$i]['tracking'] = '';
381 * table to store user preferences
382 * - leave blank to disable server storage
383 * SUGGESTED: 'pma_userconfig'
385 * @global string $cfg['Servers'][$i]['userconfig']
387 $cfg['Servers'][$i]['userconfig'] = '';
390 * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
392 * In case where tables in databases is modified (e.g. dropped or renamed),
393 * table_uiprefs may contains invalid data (referring to tables which are not
394 * exist anymore).
395 * This configuration make sure that we only keep N (N = MaxTableUiprefs)
396 * newest record in table_uiprefs and automatically delete older records.
398 * @global integer $cfg['Servers'][$i]['userconfig'] = '';
400 $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
403 * set to false if you know that your pma_* tables are up to date.
404 * This prevents compatibility checks and thereby increases performance.
406 * @global boolean $cfg['Servers'][$i]['verbose_check']
408 $cfg['Servers'][$i]['verbose_check'] = true;
411 * whether to allow root login
413 * @global boolean $cfg['Servers'][$i]['AllowRoot']
415 $cfg['Servers'][$i]['AllowRoot'] = true;
418 * whether to allow login of any user without a password
420 * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
422 $cfg['Servers'][$i]['AllowNoPassword'] = false;
425 * Host authentication order, leave blank to not use
427 * @global string $cfg['Servers'][$i]['AllowDeny']['order']
429 $cfg['Servers'][$i]['AllowDeny']['order'] = '';
432 * Host authentication rules, leave blank for defaults
434 * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
436 $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
439 * Disable use of INFORMATION_SCHEMA. Is always 'true' for Drizzle.
441 * @see http://sf.net/support/tracker.php?aid=1849494
442 * @see http://bugs.mysql.com/19588
443 * @global boolean $cfg['Servers'][$i]['DisableIS']
445 $cfg['Servers'][$i]['DisableIS'] = true;
448 * SQL command to fetch available databases
450 * by default most user will be fine with SHOW DATABASES,
451 * for servers with a huge amount of databases it is possible to
452 * define a command which executes faster but with less information
454 * especially when accessing database servers from ISPs changing this command
455 * can result in a great speed improvement
457 * false will disable fetching databases from the server, only databases in
458 * $cfg['Servers'][$i]['only_db'] will be displayed
460 * #user# will be replaced by current user
462 * examples:
463 * 'SHOW DATABASES'
464 * "SHOW DATABASES LIKE '#user#\_%'"
465 * 'SELECT DISTINCT TABLE_SCHEMA FROM information_schema.SCHEMA_PRIVILEGES'
466 * 'SELECT SCHEMA_NAME FROM information_schema.SCHEMATA'
467 * false
469 * @global array $cfg['Servers'][$i]['ShowDatabasesCommand']
471 $cfg['Servers'][$i]['ShowDatabasesCommand'] = 'SHOW DATABASES';
474 * Whether to count tables when showing database list
476 * @global array $cfg['Servers'][$i]['CountTables']
478 $cfg['Servers'][$i]['CountTables'] = false;
481 * Whether the tracking mechanism creates versions for tables and views automatically.
483 * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
486 $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
489 * Defines the list of statements the auto-creation uses for new versions.
491 * @global string $cfg['Servers'][$i]['tracking_default_statements']
494 $cfg['Servers'][$i]['tracking_default_statements'] = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,' .
495 'CREATE INDEX,DROP INDEX,' .
496 'INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,' .
497 'CREATE VIEW,ALTER VIEW,DROP VIEW,' .
498 'CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
501 * Whether a DROP VIEW IF EXISTS statement will be added as first line to the log when creating a view.
503 * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
506 $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
509 * Whether a DROP TABLE IF EXISTS statement will be added as first line to the log when creating a table.
511 * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
514 $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
517 * Whether a DROP DATABASE IF EXISTS statement will be added as first line to the log when creating a database.
519 * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
522 $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
525 * Default server (0 = no default server)
527 * If you have more than one server configured, you can set $cfg['ServerDefault']
528 * to any one of them to auto-connect to that server when phpMyAdmin is started,
529 * or set it to 0 to be given a list of servers without logging in
530 * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
531 * set to that server.
533 * @global integer $cfg['ServerDefault']
535 $cfg['ServerDefault'] = 1;
538 * Other core phpMyAdmin settings
541 * whether Ajax behavior is active
543 * @global boolean $cfg['AjaxEnable']
545 $cfg['AjaxEnable'] = true;
548 * whether version check is active
550 * @global boolean $cfg['VersionCheck']
552 $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
555 * maximum number of db's displayed in left frame and database list
557 * @global integer $cfg['MaxDbList']
559 $cfg['MaxDbList'] = 100;
562 * maximum number of tables displayed in table list
564 * @global integer $cfg['MaxTableList']
566 $cfg['MaxTableList'] = 250;
569 * whether to show hint or not
571 * @global boolean $cfg['ShowHint']
573 $cfg['ShowHint'] = true;
576 * maximum number of characters when a SQL query is displayed
578 * @global integer $cfg['MaxCharactersInDisplayedSQL']
580 $cfg['MaxCharactersInDisplayedSQL'] = 1000;
583 * use GZIP output buffering if possible (true|false|'auto')
585 * @global string $cfg['OBGzip']
587 $cfg['OBGzip'] = 'auto';
590 * use persistent connections to MySQL database
592 * @global boolean $cfg['PersistentConnections']
594 $cfg['PersistentConnections'] = false;
597 * whether to force using HTTPS
599 * @global boolean $cfg['ForceSSL']
601 $cfg['ForceSSL'] = false;
604 * maximum execution time in seconds (0 for no limit)
606 * @global integer $cfg['ExecTimeLimit']
608 $cfg['ExecTimeLimit'] = 300;
611 * Path for storing session data (session_save_path PHP parameter).
613 * @global integer $cfg['SessionSavePath']
615 $cfg['SessionSavePath'] = '';
618 * maximum allocated bytes ('0' for no limit)
619 * this is a string because '16M' is a valid value; we must put here
620 * a string as the default value so that /setup accepts strings
622 * @global string $cfg['MemoryLimit']
624 $cfg['MemoryLimit'] = '0';
627 * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
628 * Is ignored for Drizzle.
630 * @global boolean $cfg['SkipLockedTables']
632 $cfg['SkipLockedTables'] = false;
635 * show SQL queries as run
637 * @global boolean $cfg['ShowSQL']
639 $cfg['ShowSQL'] = true;
642 * retain SQL input on Ajax execute
644 * @global boolean $cfg['RetainQueryEditor']
646 $cfg['RetainQueryBox'] = false;
649 * show a 'Drop database' link to normal users
651 * @global boolean $cfg['AllowUserDropDatabase']
653 $cfg['AllowUserDropDatabase'] = false;
656 * confirm some commands that can result in loss of data
657 * (see "need_confirm" in the parser)
659 * @global boolean $cfg['Confirm']
661 $cfg['Confirm'] = true;
664 * recall previous login in cookie authentication mode or not
666 * @global boolean $cfg['LoginCookieRecall']
668 $cfg['LoginCookieRecall'] = true;
671 * validity of cookie login (in seconds; 1440 matches php.ini's
672 * session.gc_maxlifetime)
674 * @global integer $cfg['LoginCookieValidity']
676 $cfg['LoginCookieValidity'] = 1440;
679 * how long login cookie should be stored (in seconds)
681 * @global integer $cfg['LoginCookieStore']
683 $cfg['LoginCookieStore'] = 0;
686 * whether to delete all login cookies on logout
688 * @global boolean $cfg['LoginCookieDeleteAll']
690 $cfg['LoginCookieDeleteAll'] = true;
693 * whether to enable the "database search" feature or not
695 * @global boolean $cfg['UseDbSearch']
697 $cfg['UseDbSearch'] = true;
700 * if set to true, PMA continues computing multiple-statement queries
701 * even if one of the queries failed
703 * @global boolean $cfg['IgnoreMultiSubmitErrors']
705 $cfg['IgnoreMultiSubmitErrors'] = false;
708 * if set to true, PMA will show the affected rows of EACH statement on
709 * multiple-statement queries. See the libraries/import.php file for
710 * hard coded defaults on how many queries a statement may contain!
712 * @global boolean $cfg['VerboseMultiSubmit']
714 $cfg['VerboseMultiSubmit'] = true;
717 * allow login to any user entered server in cookie based authentication
719 * @global boolean $cfg['AllowArbitraryServer']
721 $cfg['AllowArbitraryServer'] = false;
724 /*******************************************************************************
725 * Error handler configuration
727 * this configures phpMyAdmin's own error handler, it is used to avoid information
728 * disclosure, gather errors for logging, reporting and displaying
730 * @global array $cfg['Error_Handler']
732 $cfg['Error_Handler'] = array();
735 * whether to display errors or not
737 * this does not affect errors of type E_USER_*
739 * @global boolean $cfg['Error_Handler']['display']
741 $cfg['Error_Handler']['display'] = false;
744 * (NOT IMPLEMENTED YET)
745 * where to log errors, false or empty to disable
747 * <code>
748 * // EXAMPLE log to std PHP error log
749 * $cfg['Error_Handler']['log'] = array(0);
750 * // EXAMPLE mail errors
751 * $cfg['Error_Handler']['log'] = array(1, 'admin@example.org');
752 * // EXAMPLE append to specific file
753 * $cfg['Error_Handler']['log'] = array(3, '/var/log/phpmyadmin_error.log');
754 * </code>
756 * @see http://php.net/error_log
757 * @global string $cfg['Error_Handler']['log']
759 //$cfg['Error_Handler']['log'] = false;
762 * gather all errors in session to be displayed on a error reporting page
763 * for viewing and/or sending to phpMyAdmin developer team
765 * @global boolean $cfg['Error_Handler']['gather']
767 $cfg['Error_Handler']['gather'] = false;
770 /*******************************************************************************
771 * Left frame setup
775 * use a select-based menu and display only the current tables in the left frame.
777 * @global boolean $cfg['LeftFrameLight']
779 $cfg['LeftFrameLight'] = true;
782 * turn the select-based light menu into a tree
784 * @global boolean $cfg['LeftFrameDBTree']
786 $cfg['LeftFrameDBTree'] = true;
789 * the separator to sub-tree the select-based light menu tree
791 * @global string $cfg['LeftFrameDBSeparator']
793 $cfg['LeftFrameDBSeparator'] = '_';
796 * Which string will be used to generate table prefixes
797 * to split/nest tables into multiple categories
799 * @global string $cfg['LeftFrameTableSeparator']
801 $cfg['LeftFrameTableSeparator']= '__';
804 * How many sublevels should be displayed when splitting up tables by the above Separator
806 * @global integer $cfg['LeftFrameTableLevel']
808 $cfg['LeftFrameTableLevel'] = 1;
811 * display table comment as tooltip in left frame
813 * @global boolean $cfg['ShowTooltip']
815 $cfg['ShowTooltip'] = true;
818 * if ShowToolTip is enabled, this defines that table/db comments
820 * @global boolean $cfg['ShowTooltipAliasDB']
822 $cfg['ShowTooltipAliasDB'] = false;
825 * are shown (in the left menu and db_structure) instead of table/db names.
826 * Setting ShowTooltipAliasTB to 'nested' will only use the Aliases for nested
827 * descriptors, not the table itself.
829 * @global boolean $cfg['ShowTooltipAliasTB']
831 $cfg['ShowTooltipAliasTB'] = false;
834 * display logo at top of left frame
836 * @global boolean $cfg['LeftDisplayLogo']
838 $cfg['LeftDisplayLogo'] = true;
841 * where should logo link point to (can also contain an external URL)
843 * @global string $cfg['LeftLogoLink']
845 $cfg['LeftLogoLink'] = 'main.php';
848 * whether to open the linked page in the main window ('main') or
849 * in a new window ('new')
851 * @global string $cfg['LeftLogoLinkWindow']
853 $cfg['LeftLogoLinkWindow'] = 'main';
856 * number of recently used tables displayed in the navigation frame
858 * @global integer $cfg['LeftRecentTable']
860 $cfg['LeftRecentTable'] = 10;
863 * display a JavaScript table filter in the left frame
864 * when more then x tables are present
866 * @global boolean $cfg['LeftDisplayTableFilterMinimum']
868 $cfg['LeftDisplayTableFilterMinimum'] = 30;
871 * display server choice at top of left frame
873 * @global boolean $cfg['LeftDisplayServers']
875 $cfg['LeftDisplayServers'] = false;
878 * server choice as links
880 * @global boolean $cfg['DisplayServersList']
882 $cfg['DisplayServersList'] = false;
885 * database choice in light as links
887 * @global boolean $cfg['DisplayDatabasesList']
889 $cfg['DisplayDatabasesList'] = 'auto';
892 * target of the navigation panel quick access icon
894 * Possible values:
895 * 'tbl_structure.php' = fields list
896 * 'tbl_sql.php' = SQL form
897 * 'tbl_select.php' = search page
898 * 'tbl_change.php' = insert row page
899 * 'sql.php' = browse page
901 * @global string $cfg['LeftDefaultTabTable']
903 $cfg['LeftDefaultTabTable'] = 'tbl_structure.php';
906 /*******************************************************************************
907 * In the main frame, at startup...
911 * allow to display statistics and space usage in the pages about database
912 * details and table properties
914 * @global boolean $cfg['ShowStats']
916 $cfg['ShowStats'] = true;
919 * show PHP info link
921 * @global boolean $cfg['ShowPhpInfo']
923 $cfg['ShowPhpInfo'] = false;
926 * show MySQL server and web server information
928 * @global boolean $cfg['ShowServerInfo']
930 $cfg['ShowServerInfo'] = true;
933 * show change password link
935 * @global boolean $cfg['ShowChgPassword']
937 $cfg['ShowChgPassword'] = true;
940 * show create database form
942 * @global boolean $cfg['ShowCreateDb']
944 $cfg['ShowCreateDb'] = true;
947 * suggest a new DB name if possible (false = keep empty)
949 * @global boolean $cfg['SuggestDBName']
951 $cfg['SuggestDBName'] = true;
954 /*******************************************************************************
955 * In browse mode...
959 * Use icons instead of text for the navigation bar buttons
960 * and on right panel top menu (server db table) (true|false|'both')
962 * @global string $cfg['NavigationBarIconic']
964 $cfg['NavigationBarIconic'] = true;
967 * Defines whether a user should be displayed a "show all (records)"
968 * button in browse mode or not.
970 * @global boolean $cfg['ShowAll']
972 $cfg['ShowAll'] = false;
975 * Number of rows displayed when browsing a result set. If the result
976 * set contains more rows, "Previous" and "Next".
978 * @global integer $cfg['MaxRows']
980 $cfg['MaxRows'] = 30;
983 * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
984 * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
985 * ascending order else-)
987 * @global string $cfg['Order']
989 $cfg['Order'] = 'SMART';
992 * default for 'Show binary contents as HEX'
994 * @global string $cfg['DisplayBinaryAsHex']
996 $cfg['DisplayBinaryAsHex'] = true;
999 /*******************************************************************************
1000 * In edit mode...
1004 * disallow editing of binary fields
1005 * valid values are:
1006 * false allow editing
1007 * 'blob' allow editing except for BLOB fields
1008 * 'all' disallow editing
1010 * @global string $cfg['ProtectBinary']
1012 $cfg['ProtectBinary'] = 'blob';
1015 * Display the function fields in edit/insert mode
1017 * @global boolean $cfg['ShowFunctionFields']
1019 $cfg['ShowFunctionFields'] = true;
1022 * Display the type fields in edit/insert mode
1024 * @global boolean $cfg['ShowFieldTypesInDataEditView']
1026 $cfg['ShowFieldTypesInDataEditView'] = true;
1029 * Which editor should be used for CHAR/VARCHAR fields:
1030 * input - allows limiting of input length
1031 * textarea - allows newlines in fields
1033 * @global string $cfg['CharEditing']
1035 $cfg['CharEditing'] = 'input';
1038 * The minimum size for character input fields
1040 * @global integer $cfg['MinSizeForInputField']
1042 $cfg['MinSizeForInputField'] = 4;
1045 * The maximum size for character input fields
1047 * @global integer $cfg['MinSizeForInputField']
1049 $cfg['MaxSizeForInputField'] = 60;
1052 * How many rows can be inserted at one time
1054 * @global integer $cfg['InsertRows']
1056 $cfg['InsertRows'] = 2;
1059 * Sort order for items in a foreign-key drop-down list.
1060 * 'content' is the referenced data, 'id' is the key value.
1062 * @global array $cfg['ForeignKeyDropdownOrder']
1064 $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
1067 * A drop-down list will be used if fewer items are present
1069 * @global integer $cfg['ForeignKeyMaxLimit']
1071 $cfg['ForeignKeyMaxLimit'] = 100;
1074 /*******************************************************************************
1075 * For the export features...
1079 * Allow for the use of zip compression (requires zip support to be enabled)
1081 * @global boolean $cfg['ZipDump']
1083 $cfg['ZipDump'] = true;
1086 * Allow for the use of gzip compression (requires zlib)
1088 * @global boolean $cfg['GZipDump']
1090 $cfg['GZipDump'] = true;
1093 * Allow for the use of bzip2 compression (requires bz2 extension)
1095 * @global boolean $cfg['BZipDump']
1097 $cfg['BZipDump'] = true;
1100 * Will compress gzip/bzip2 exports on the fly without the need for much memory.
1101 * If you encounter problems with created gzip/bzip2 files disable this feature.
1103 * @global boolean $cfg['CompressOnFly']
1105 $cfg['CompressOnFly'] = true;
1108 /*******************************************************************************
1109 * Tabs display settings
1113 * Use graphically less intense menu tabs
1115 * @global boolean $cfg['LightTabs']
1117 $cfg['LightTabs'] = false;
1120 * Use icons instead of text for the table display of a database (true|false|'both')
1122 * @global boolean $cfg['PropertiesIconic']
1124 $cfg['PropertiesIconic'] = 'both';
1127 * How many columns should be used for table display of a database?
1128 * (a value larger than 1 results in some information being hidden)
1130 * @global integer $cfg['PropertiesNumColumns']
1132 $cfg['PropertiesNumColumns'] = 1;
1135 * Possible values:
1136 * 'main.php' = the welcome page
1137 * (recommended for multiuser setups)
1138 * 'server_databases.php' = list of databases
1139 * 'server_status.php' = runtime information
1140 * 'server_variables.php' = MySQL server variables
1141 * 'server_privileges.php' = user management
1142 * 'server_processlist.php' = process list
1144 * @global string $cfg['DefaultTabServer']
1146 $cfg['DefaultTabServer'] = 'main.php';
1149 * Possible values:
1150 * 'db_structure.php' = tables list
1151 * 'db_sql.php' = SQL form
1152 * 'db_search.php' = search query
1153 * 'db_operations.php' = operations on database
1155 * @global string $cfg['DefaultTabDatabase']
1157 $cfg['DefaultTabDatabase'] = 'db_structure.php';
1160 * Possible values:
1161 * 'tbl_structure.php' = fields list
1162 * 'tbl_sql.php' = SQL form
1163 * 'tbl_select.php' = search page
1164 * 'tbl_change.php' = insert row page
1165 * 'sql.php' = browse page
1167 * @global string $cfg['DefaultTabTable']
1169 $cfg['DefaultTabTable'] = 'sql.php';
1171 /*******************************************************************************
1172 * Export defaults
1174 $cfg['Export'] = array();
1177 * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xls/xml/yaml
1179 * @global string $cfg['Export']['format']
1181 $cfg['Export']['format'] = 'sql';
1184 * quick/custom/custom-no-form
1186 * @global string $cfg['Export']['format']
1188 $cfg['Export']['method'] = 'quick';
1191 * none/zip/gzip/bzip2
1193 * @global string $cfg['Export']['compression']
1195 $cfg['Export']['compression'] = 'none';
1200 * @global boolean $cfg['Export']['asfile']
1202 $cfg['Export']['asfile'] = true;
1207 * @global string $cfg['Export']['charset']
1209 $cfg['Export']['charset'] = '';
1214 * @global boolean $cfg['Export']['onserver']
1216 $cfg['Export']['onserver'] = false;
1221 * @global boolean $cfg['Export']['onserver_overwrite']
1223 $cfg['Export']['onserver_overwrite'] = false;
1228 * @global boolean $cfg['Export']['quick_export_onserver']
1230 $cfg['Export']['quick_export_onserver'] = false;
1235 * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
1237 $cfg['Export']['quick_export_onserver_overwrite'] = false;
1242 * @global boolean $cfg['Export']['remember_file_template']
1244 $cfg['Export']['remember_file_template'] = true;
1249 * @global string $cfg['Export']['file_template_table']
1251 $cfg['Export']['file_template_table'] = '@TABLE@';
1256 * @global string $cfg['Export']['file_template_database']
1258 $cfg['Export']['file_template_database'] = '@DATABASE@';
1263 * @global string $cfg['Export']['file_template_server']
1265 $cfg['Export']['file_template_server'] = '@SERVER@';
1270 * @global string $cfg['Export']['codegen_structure_or_data']
1272 $cfg['Export']['codegen_structure_or_data'] = 'data';
1277 * @global $cfg['Export']['codegen_format']
1279 $cfg['Export']['codegen_format'] = 0;
1284 * @global boolean $cfg['Export']['ods_columns']
1286 $cfg['Export']['ods_columns'] = false;
1291 * @global string $cfg['Export']['ods_null']
1293 $cfg['Export']['ods_null'] = 'NULL';
1298 * @global string $cfg['Export']['odt_structure_or_data']
1300 $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
1305 * @global boolean $cfg['Export']['odt_columns']
1307 $cfg['Export']['odt_columns'] = true;
1312 * @global boolean $cfg['Export']['odt_relation']
1314 $cfg['Export']['odt_relation'] = true;
1319 * @global boolean $cfg['Export']['odt_comments']
1321 $cfg['Export']['odt_comments'] = true;
1326 * @global boolean $cfg['Export']['odt_mime']
1328 $cfg['Export']['odt_mime'] = true;
1333 * @global string $cfg['Export']['odt_null']
1335 $cfg['Export']['odt_null'] = 'NULL';
1340 * @global boolean $cfg['Export']['htmlword_structure_or_data']
1342 $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
1347 * @global boolean $cfg['Export']['htmlword_columns']
1349 $cfg['Export']['htmlword_columns'] = false;
1354 * @global string $cfg['Export']['htmlword_null']
1356 $cfg['Export']['htmlword_null'] = 'NULL';
1361 * @global string $cfg['Export']['texytext_structure_or_data']
1363 $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
1368 * @global boolean $cfg['Export']['texytext_columns']
1370 $cfg['Export']['texytext_columns'] = false;
1375 * @global string $cfg['Export']['texytext_null']
1377 $cfg['Export']['texytext_null'] = 'NULL';
1382 * @global boolean $cfg['Export']['xls_columns']
1384 $cfg['Export']['xls_columns'] = false;
1389 * @global string $cfg['Export']['xls_structure_or_data']
1391 $cfg['Export']['xls_structure_or_data'] = 'data';
1396 * @global string $cfg['Export']['xls_null']
1398 $cfg['Export']['xls_null'] = 'NULL';
1403 * @global boolean $cfg['Export']['xlsx_columns']
1405 $cfg['Export']['xlsx_columns'] = false;
1410 * @global string $cfg['Export']['xlsx_structure_or_data']
1412 $cfg['Export']['xlsx_structure_or_data'] = 'data';
1417 * @global string $cfg['Export']['xlsx_null']
1419 $cfg['Export']['xlsx_null'] = 'NULL';
1424 * @global boolean $cfg['Export']['csv_columns']
1426 $cfg['Export']['csv_columns'] = false;
1431 * @global string $cfg['Export']['csv_structure_or_data']
1433 $cfg['Export']['csv_structure_or_data'] = 'data';
1438 * @global string $cfg['Export']['csv_null']
1440 $cfg['Export']['csv_null'] = 'NULL';
1445 * @global string $cfg['Export']['csv_separator']
1447 $cfg['Export']['csv_separator'] = ',';
1452 * @global string $cfg['Export']['csv_enclosed']
1454 $cfg['Export']['csv_enclosed'] = '"';
1459 * @global string $cfg['Export']['csv_escaped']
1461 $cfg['Export']['csv_escaped'] = '"';
1466 * @global string $cfg['Export']['csv_terminated']
1468 $cfg['Export']['csv_terminated'] = 'AUTO';
1473 * @global string $cfg['Export']['csv_removeCRLF']
1475 $cfg['Export']['csv_removeCRLF'] = false;
1480 * @global boolean $cfg['Export']['excel_columns']
1482 $cfg['Export']['excel_columns'] = false;
1487 * @global string $cfg['Export']['excel_null']
1489 $cfg['Export']['excel_null'] = 'NULL';
1492 * win/mac
1494 * @global string $cfg['Export']['excel_edition']
1496 $cfg['Export']['excel_edition'] = 'win';
1501 * @global string $cfg['Export']['excel_removeCRLF']
1503 $cfg['Export']['excel_removeCRLF'] = false;
1508 * @global string $cfg['Export']['excel_structure_or_data']
1510 $cfg['Export']['excel_structure_or_data'] = 'data';
1515 * @global string $cfg['Export']['latex_structure_or_data']
1517 $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
1522 * @global boolean $cfg['Export']['latex_columns']
1524 $cfg['Export']['latex_columns'] = true;
1529 * @global boolean $cfg['Export']['latex_relation']
1531 $cfg['Export']['latex_relation'] = true;
1536 * @global boolean $cfg['Export']['latex_comments']
1538 $cfg['Export']['latex_comments'] = true;
1543 * @global boolean $cfg['Export']['latex_mime']
1545 $cfg['Export']['latex_mime'] = true;
1550 * @global string $cfg['Export']['latex_null']
1552 $cfg['Export']['latex_null'] = '\textit{NULL}';
1557 * @global boolean $cfg['Export']['latex_caption']
1559 $cfg['Export']['latex_caption'] = true;
1564 * @global string $cfg['Export']['latex_structure_caption']
1566 $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
1571 * @global string $cfg['Export']['latex_structure_continued_caption']
1573 $cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';
1578 * @global string $cfg['Export']['latex_data_caption']
1580 $cfg['Export']['latex_data_caption'] = 'strLatexContent';
1585 * @global string $cfg['Export']['latex_data_continued_caption']
1587 $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
1592 * @global string $cfg['Export']['latex_data_label']
1594 $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
1599 * @global string $cfg['Export']['latex_structure_label']
1601 $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
1606 * @global string $cfg['Export']['mediawiki_structure_or_data']
1608 $cfg['Export']['mediawiki_structure_or_data'] = 'data';
1613 * @global string $cfg['Export']['ods_structure_or_data']
1615 $cfg['Export']['ods_structure_or_data'] = 'data';
1620 * @global string $cfg['Export']['pdf_structure_or_data']
1622 $cfg['Export']['pdf_structure_or_data'] = 'data';
1627 * @global string $cfg['Export']['php_array_structure_or_data']
1629 $cfg['Export']['php_array_structure_or_data'] = 'data';
1634 * @global string $cfg['Export']['json_structure_or_data']
1636 $cfg['Export']['json_structure_or_data'] = 'data';
1641 * @global string $cfg['Export']['sql_structure_or_data']
1643 $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
1648 * @global string $cfg['Export']['sql_compatibility']
1650 $cfg['Export']['sql_compatibility'] = 'NONE';
1653 * Whether to include comments in SQL export.
1655 * @global string $cfg['Export']['sql_include_comments']
1657 $cfg['Export']['sql_include_comments'] = true;
1662 * @global boolean $cfg['Export']['sql_disable_fk']
1664 $cfg['Export']['sql_disable_fk'] = false;
1669 * @global boolean $cfg['Export']['sql_use_transaction']
1671 $cfg['Export']['sql_use_transaction'] = false;
1676 * @global boolean $cfg['Export']['sql_drop_database']
1678 $cfg['Export']['sql_drop_database'] = false;
1683 * @global boolean $cfg['Export']['sql_drop_table']
1685 $cfg['Export']['sql_drop_table'] = false;
1690 * true by default for correct behavior when dealing with exporting
1691 * of VIEWs and the stand-in table
1692 * @global boolean $cfg['Export']['sql_if_not_exists']
1694 $cfg['Export']['sql_if_not_exists'] = true;
1699 * @global boolean $cfg['Export']['sql_procedure_function']
1701 $cfg['Export']['sql_procedure_function'] = true;
1706 * @global boolean $cfg['Export']['sql_auto_increment']
1708 $cfg['Export']['sql_auto_increment'] = true;
1713 * @global boolean $cfg['Export']['sql_backquotes']
1715 $cfg['Export']['sql_backquotes'] = true;
1720 * @global boolean $cfg['Export']['sql_dates']
1722 $cfg['Export']['sql_dates'] = false;
1727 * @global boolean $cfg['Export']['sql_relation']
1729 $cfg['Export']['sql_relation'] = false;
1734 * @global boolean $cfg['Export']['sql_delayed']
1736 $cfg['Export']['sql_delayed'] = false;
1741 * @global boolean $cfg['Export']['sql_ignore']
1743 $cfg['Export']['sql_ignore'] = false;
1746 * Export time in UTC.
1748 * @global boolean $cfg['Export']['sql_utc_time']
1750 $cfg['Export']['sql_utc_time'] = true;
1755 * @global boolean $cfg['Export']['sql_hex_for_blob']
1757 $cfg['Export']['sql_hex_for_blob'] = true;
1760 * insert/update/replace
1762 * @global string $cfg['Export']['sql_type']
1764 $cfg['Export']['sql_type'] = 'INSERT';
1769 * @global integer $cfg['Export']['sql_max_query_size']
1771 $cfg['Export']['sql_max_query_size'] = 50000;
1776 * @global boolean $cfg['Export']['sql_comments']
1778 $cfg['Export']['sql_comments'] = false;
1783 * @global boolean $cfg['Export']['sql_mime']
1785 $cfg['Export']['sql_mime'] = false;
1788 * \n is replaced by new line
1790 * @global string $cfg['Export']['sql_header_comment']
1792 $cfg['Export']['sql_header_comment'] = '';
1797 * @global boolean $cfg['Export']['sql_create_table_statements']
1799 $cfg['Export']['sql_create_table_statements'] = true;
1802 * Whether to use complete inserts, extended inserts, both, or neither
1804 * @global string $cfg['Export']['sql_insert_syntax']
1806 $cfg['Export']['sql_insert_syntax'] = 'both';
1811 * @global string $cfg['Export']['pdf_report_title']
1813 $cfg['Export']['pdf_report_title'] = '';
1818 *@global string $cfg['Export']['xml_structure_or_data']
1820 $cfg['Export']['xml_structure_or_data'] = 'data';
1823 * Export schema for each structure
1825 * @global string $cfg['Export']['xml_export_struc']
1827 $cfg['Export']['xml_export_struc'] = true;
1830 * Export functions
1832 * @global string $cfg['Export']['xml_export_functions']
1834 $cfg['Export']['xml_export_functions'] = true;
1837 * Export procedures
1839 * @global string $cfg['Export']['xml_export_procedures']
1841 $cfg['Export']['xml_export_procedures'] = true;
1844 * Export schema for each table
1846 * @global string $cfg['Export']['xml_export_tables']
1848 $cfg['Export']['xml_export_tables'] = true;
1851 * Export triggers
1853 * @global string $cfg['Export']['xml_export_triggers']
1855 $cfg['Export']['xml_export_triggers'] = true;
1858 * Export views
1860 * @global string $cfg['Export']['xml_export_views']
1862 $cfg['Export']['xml_export_views'] = true;
1865 * Export contents data
1867 * @global string $cfg['Export']['xml_export_contents']
1869 $cfg['Export']['xml_export_contents'] = true;
1874 * @global string $cfg['Export']['yaml_structure_or_data']
1876 $cfg['Export']['yaml_structure_or_data'] = 'data';
1878 /*******************************************************************************
1879 * Import defaults
1881 $cfg['Import'] = array();
1886 * @global string $cfg['Import']['format']
1888 $cfg['Import']['format'] = 'sql';
1891 * Default charset for import.
1893 * @global string $cfg['Import']['charset']
1895 $cfg['Import']['charset'] = '';
1900 * @global boolean $cfg['Import']['allow_interrupt']
1902 $cfg['Import']['allow_interrupt'] = true;
1907 * @global integer $cfg['Import']['skip_queries']
1909 $cfg['Import']['skip_queries'] = 0;
1914 * @global string $cfg['Import']['sql_compatibility']
1916 $cfg['Import']['sql_compatibility'] = 'NONE';
1921 * @global string $cfg['Import']['sql_no_auto_value_on_zero']
1923 $cfg['Import']['sql_no_auto_value_on_zero'] = true;
1928 * @global boolean $cfg['Import']['csv_replace']
1930 $cfg['Import']['csv_replace'] = false;
1935 * @global boolean $cfg['Import']['csv_ignore']
1937 $cfg['Import']['csv_ignore'] = false;
1942 * @global string $cfg['Import']['csv_terminated']
1944 $cfg['Import']['csv_terminated'] = ',';
1949 * @global string $cfg['Import']['csv_enclosed']
1951 $cfg['Import']['csv_enclosed'] = '"';
1956 * @global string $cfg['Import']['csv_escaped']
1958 $cfg['Import']['csv_escaped'] = '"';
1963 * @global string $cfg['Import']['csv_new_line']
1965 $cfg['Import']['csv_new_line'] = 'auto';
1970 * @global string $cfg['Import']['csv_columns']
1972 $cfg['Import']['csv_columns'] = '';
1977 * @global string $cfg['Import']['csv_col_names']
1979 $cfg['Import']['csv_col_names'] = false;
1984 * @global boolean $cfg['Import']['ldi_replace']
1986 $cfg['Import']['ldi_replace'] = false;
1991 * @global boolean $cfg['Import']['ldi_ignore']
1993 $cfg['Import']['ldi_ignore'] = false;
1998 * @global string $cfg['Import']['ldi_terminated']
2000 $cfg['Import']['ldi_terminated'] = ';';
2005 * @global string $cfg['Import']['ldi_enclosed']
2007 $cfg['Import']['ldi_enclosed'] = '"';
2012 * @global string $cfg['Import']['ldi_escaped']
2014 $cfg['Import']['ldi_escaped'] = '\\';
2019 * @global string $cfg['Import']['ldi_new_line']
2021 $cfg['Import']['ldi_new_line'] = 'auto';
2026 * @global string $cfg['Import']['ldi_columns']
2028 $cfg['Import']['ldi_columns'] = '';
2031 * 'auto' for auto-detection, true or false for forcing
2033 * @global string $cfg['Import']['ldi_local_option']
2035 $cfg['Import']['ldi_local_option'] = 'auto';
2040 * @global string $cfg['Import']['ods_col_names']
2042 $cfg['Import']['ods_col_names'] = false;
2047 * @global string $cfg['Import']['ods_empty_rows']
2049 $cfg['Import']['ods_empty_rows'] = true;
2054 * @global string $cfg['Import']['ods_recognize_percentages']
2056 $cfg['Import']['ods_recognize_percentages'] = true;
2061 * @global string $cfg['Import']['ods_recognize_currency']
2063 $cfg['Import']['ods_recognize_currency'] = true;
2068 * @global string $cfg['Import']['xml_col_names']
2070 $cfg['Import']['xls_col_names'] = false;
2075 * @global string $cfg['Import']['xml_empty_rows']
2077 $cfg['Import']['xls_empty_rows'] = true;
2082 * @global string $cfg['Import']['xlsx_col_names']
2084 $cfg['Import']['xlsx_col_names'] = false;
2087 * Link to the official MySQL documentation.
2088 * Be sure to include no trailing slash on the path.
2089 * See http://dev.mysql.com/doc/ for more information
2090 * about MySQL manuals and their types.
2092 * @global string $cfg['MySQLManualBase']
2094 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
2097 * Type of MySQL documentation:
2098 * viewable - "viewable online", current one used on MySQL website
2099 * searchable - "Searchable, with user comments"
2100 * chapters - "HTML, one page per chapter"
2101 * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
2102 * big - "HTML, all on one page"
2103 * old - old style used in phpMyAdmin 2.3.0 and sooner
2104 * none - do not show documentation links
2106 * @global string $cfg['MySQLManualType']
2108 $cfg['MySQLManualType'] = 'viewable';
2111 /*******************************************************************************
2112 * PDF options
2118 * @global array $cfg['PDFPageSizes']
2120 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
2125 * @global string $cfg['PDFDefaultPageSize']
2127 $cfg['PDFDefaultPageSize'] = 'A4';
2130 /*******************************************************************************
2131 * Language and character set conversion settings
2135 * Default language to use, if not browser-defined or user-defined
2137 * @global string $cfg['DefaultLang']
2139 $cfg['DefaultLang'] = 'en';
2142 * Default connection collation
2144 * @global string $cfg['DefaultConnectionCollation']
2146 $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
2149 * Force: always use this language
2150 * $cfg['Lang'] = 'en';
2152 * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
2153 * English only
2155 * @global string $cfg['FilterLanguages']
2157 $cfg['FilterLanguages'] = '';
2160 * You can select here which functions will be used for character set conversion.
2161 * Possible values are:
2162 * auto - automatically use available one (first is tested iconv, then
2163 * recode)
2164 * iconv - use iconv or libiconv functions
2165 * recode - use recode_string function
2166 * none - disable encoding conversion
2168 * @global string $cfg['RecodingEngine']
2170 $cfg['RecodingEngine'] = 'auto';
2173 * Specify some parameters for iconv used in character set conversion. See iconv
2174 * documentation for details:
2175 * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
2177 * @global string $cfg['IconvExtraParams']
2179 $cfg['IconvExtraParams'] = '//TRANSLIT';
2182 * Available character sets for MySQL conversion. currently contains all which could
2183 * be found in lang/* files and few more.
2184 * Character sets will be shown in same order as here listed, so if you frequently
2185 * use some of these move them to the top.
2187 * @global array $cfg['AvailableCharsets']
2189 $cfg['AvailableCharsets'] = array(
2190 'iso-8859-1',
2191 'iso-8859-2',
2192 'iso-8859-3',
2193 'iso-8859-4',
2194 'iso-8859-5',
2195 'iso-8859-6',
2196 'iso-8859-7',
2197 'iso-8859-8',
2198 'iso-8859-9',
2199 'iso-8859-10',
2200 'iso-8859-11',
2201 'iso-8859-12',
2202 'iso-8859-13',
2203 'iso-8859-14',
2204 'iso-8859-15',
2205 'windows-1250',
2206 'windows-1251',
2207 'windows-1252',
2208 'windows-1256',
2209 'windows-1257',
2210 'koi8-r',
2211 'big5',
2212 'gb2312',
2213 'utf-16',
2214 'utf-8',
2215 'utf-7',
2216 'x-user-defined',
2217 'euc-jp',
2218 'ks_c_5601-1987',
2219 'tis-620',
2220 'SHIFT_JIS'
2224 /*******************************************************************************
2225 * Customization & design
2227 * The graphical settings are now located in themes/theme-name/layout.inc.php
2231 * enable the left panel pointer
2232 * (used when LeftFrameLight is false)
2233 * see also LeftPointerColor
2234 * in layout.inc.php
2236 * @global boolean $cfg['LeftPointerEnable']
2238 $cfg['LeftPointerEnable'] = true;
2241 * enable the browse pointer
2242 * see also BrowsePointerColor
2243 * in layout.inc.php
2245 * @global boolean $cfg['BrowsePointerEnable']
2247 $cfg['BrowsePointerEnable'] = true;
2250 * enable the browse marker
2251 * see also BrowseMarkerColor
2252 * in layout.inc.php
2254 * @global boolean $cfg['BrowseMarkerEnable']
2256 $cfg['BrowseMarkerEnable'] = true;
2259 * textarea size (columns) in edit mode
2260 * (this value will be emphasized (*2) for SQL
2261 * query textareas and (*1.25) for query window)
2263 * @global integer $cfg['TextareaCols']
2265 $cfg['TextareaCols'] = 40;
2268 * textarea size (rows) in edit mode
2270 * @global integer $cfg['TextareaRows']
2272 $cfg['TextareaRows'] = 15;
2275 * double size of textarea size for LONGTEXT columns
2277 * @global boolean $cfg['LongtextDoubleTextarea']
2279 $cfg['LongtextDoubleTextarea'] = true;
2282 * auto-select when clicking in the textarea of the query-box
2284 * @global boolean $cfg['TextareaAutoSelect']
2286 $cfg['TextareaAutoSelect'] = false;
2289 * textarea size (columns) for CHAR/VARCHAR
2291 * @global integer $cfg['CharTextareaCols']
2293 $cfg['CharTextareaCols'] = 40;
2296 * textarea size (rows) for CHAR/VARCHAR
2298 * @global integer $cfg['CharTextareaRows']
2300 $cfg['CharTextareaRows'] = 2;
2303 * Max field data length in browse mode for all non-numeric fields
2305 * @global integer $cfg['LimitChars']
2307 $cfg['LimitChars'] = 50;
2310 * Where to show the edit/copy/delete links in browse mode
2311 * Possible values are 'left', 'right', 'both' and 'none';
2312 * which will be interpreted as 'top', 'bottom', 'both' and 'none'
2313 * respectively for vertical display mode
2315 * @global string $cfg['RowActionLinks']
2317 $cfg['RowActionLinks'] = 'left';
2320 * default display direction (horizontal|vertical|horizontalflipped)
2322 * @global string $cfg['DefaultDisplay']
2324 $cfg['DefaultDisplay'] = 'horizontal';
2327 * remember the last way a table sorted
2329 * @global string $cfg['RememberSorting']
2331 $cfg['RememberSorting'] = true;
2334 * table-header rotation via faking or CSS? (css|fake|auto)
2335 * NOTE: CSS only works in IE browsers!
2337 * @global string $cfg['HeaderFlipType']
2339 $cfg['HeaderFlipType'] = 'auto';
2342 * shows stored relation-comments in 'browse' mode.
2344 * @global boolean $cfg['ShowBrowseComments']
2346 $cfg['ShowBrowseComments'] = true;
2349 * shows stored relation-comments in 'table property' mode.
2351 * @global boolean $cfg['ShowPropertyComments']
2353 $cfg['ShowPropertyComments']= true;
2356 * save edited cell(s) in browse-mode at once.
2358 $cfg['SaveCellsAtOnce'] = false;
2361 * shows table display direction.
2363 $cfg['ShowDisplayDirection'] = false;
2366 * repeat header names every X cells? (0 = deactivate)
2368 * @global integer $cfg['RepeatCells']
2370 $cfg['RepeatCells'] = 100;
2373 * Set to true if Edit link should open the query to edit in the query window
2374 * (assuming JavaScript is enabled), and to false if we should edit in the right panel
2376 * @global boolean $cfg['EditInWindow']
2378 $cfg['EditInWindow'] = true;
2381 * Width of Query window
2383 * @global integer $cfg['QueryWindowWidth']
2385 $cfg['QueryWindowWidth'] = 550;
2388 * Height of Query window
2390 * @global integer $cfg['QueryWindowHeight']
2392 $cfg['QueryWindowHeight'] = 310;
2395 * Set to true if you want DB-based query history.If false, this utilizes
2396 * JS-routines to display query history (lost by window close)
2398 * @global boolean $cfg['QueryHistoryDB']
2400 $cfg['QueryHistoryDB'] = false;
2403 * which tab to display in the querywindow on startup
2404 * (sql|files|history|full)
2406 * @global string $cfg['QueryWindowDefTab']
2408 $cfg['QueryWindowDefTab'] = 'sql';
2411 * When using DB-based query history, how many entries should be kept?
2413 * @global integer $cfg['QueryHistoryMax']
2415 $cfg['QueryHistoryMax'] = 25;
2418 * Use MIME-Types (stored in column comments table) for
2420 * @global boolean $cfg['BrowseMIME']
2422 $cfg['BrowseMIME'] = true;
2425 * When approximate count < this, PMA will get exact count for table rows.
2427 * @global integer $cfg['MaxExactCount']
2429 $cfg['MaxExactCount'] = 20000;
2432 * Zero means that no row count is done for views; see the doc
2434 * @global integer $cfg['MaxExactCountViews']
2436 $cfg['MaxExactCountViews'] = 100000;
2439 * Sort table and database in natural order
2441 * @global boolean $cfg['NaturalOrder']
2443 $cfg['NaturalOrder'] = true;
2446 * Initial state for sliders
2447 * (open | closed | disabled)
2449 * @global string $cfg['InitialSlidersState']
2451 $cfg['InitialSlidersState'] = 'closed';
2454 * User preferences: disallow these settings
2455 * For possible setting names look in libraries/config/user_preferences.forms.php
2457 * @global array $cfg['UserprefsDisallow']
2459 $cfg['UserprefsDisallow'] = array();
2462 * User preferences: enable the Developer tab
2464 $cfg['UserprefsDeveloperTab'] = false;
2466 /*******************************************************************************
2467 * Window title settings
2471 * title of browser window when a table is selected
2473 * @global string $cfg['TitleTable']
2475 $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
2478 * title of browser window when a database is selected
2480 * @global string $cfg['TitleDatabase']
2482 $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
2485 * title of browser window when a server is selected
2487 * @global string $cfg['TitleServer']
2489 $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
2492 * title of browser window when nothing is selected
2493 * @global string $cfg['TitleDefault']
2495 $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
2498 * show some icons for warning, error and information messages (true|false)?
2500 * @global boolean $cfg['ErrorIconic']
2502 $cfg['ErrorIconic'] = true;
2505 * show icons in list on main page and on menu tabs (true|false)?
2507 * @global boolean $cfg['MainPageIconic']
2509 $cfg['MainPageIconic'] = true;
2512 * show help button instead of Documentation text (true|false)?
2514 * @global boolean $cfg['ReplaceHelpImg']
2516 $cfg['ReplaceHelpImg'] = true;
2519 /*******************************************************************************
2520 * theme manager
2524 * using themes manager please set up here the path to 'themes' else leave empty
2526 * @global string $cfg['ThemePath']
2528 $cfg['ThemePath'] = './themes';
2531 * if you want to use selectable themes and if ThemesPath not empty
2532 * set it to true, else set it to false (default is false);
2534 * @global boolean $cfg['ThemeManager']
2536 $cfg['ThemeManager'] = true;
2539 * set up default theme, if ThemePath not empty you can set up here an valid
2540 * path to themes or 'original' for the original pma-theme
2542 * @global string $cfg['ThemeDefault']
2544 $cfg['ThemeDefault'] = 'pmahomme';
2547 * allow different theme for each configured server
2549 * @global boolean $cfg['ThemePerServer']
2551 $cfg['ThemePerServer'] = false;
2554 /*******************************************************************************
2559 * Default query for table
2561 * @global string $cfg['DefaultQueryTable']
2563 $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
2566 * Default query for database
2568 * @global string $cfg['DefaultQueryDatabase']
2570 $cfg['DefaultQueryDatabase'] = '';
2573 /*******************************************************************************
2574 * SQL Query box settings
2575 * These are the links display in all of the SQL Query boxes
2577 * @global array $cfg['SQLQuery']
2579 $cfg['SQLQuery'] = array();
2582 * Edit link to change a query
2584 * @global boolean $cfg['SQLQuery']['Edit']
2586 $cfg['SQLQuery']['Edit'] = true;
2589 * EXPLAIN on SELECT queries
2591 * @global boolean $cfg['SQLQuery']['Explain']
2593 $cfg['SQLQuery']['Explain'] = true;
2596 * Wrap a query in PHP
2598 * @global boolean $cfg['SQLQuery']['ShowAsPHP']
2600 $cfg['SQLQuery']['ShowAsPHP'] = true;
2603 * Validate a query (see $cfg['SQLValidator'] as well)
2605 * @global boolean $cfg['SQLQuery']['Validate']
2607 $cfg['SQLQuery']['Validate'] = false;
2610 * Refresh the results page
2612 * @global boolean $cfg['SQLQuery']['Refresh']
2614 $cfg['SQLQuery']['Refresh'] = true;
2617 /*******************************************************************************
2618 * Web server upload/save/import directories
2622 * Directory for uploaded files that can be executed by phpMyAdmin.
2623 * For example './upload'. Leave empty for no upload directory support.
2624 * Use %u for username inclusion.
2626 * @global string $cfg['UploadDir']
2628 $cfg['UploadDir'] = '';
2631 * Directory where phpMyAdmin can save exported data on server.
2632 * For example './save'. Leave empty for no save directory support.
2633 * Use %u for username inclusion.
2635 * @global string $cfg['SaveDir']
2637 $cfg['SaveDir'] = '';
2640 * Directory where phpMyAdmin can save temporary files.
2641 * This is needed for MS Excel export, see documentation how to enable that.
2643 * @global string $cfg['TempDir']
2645 $cfg['TempDir'] = '';
2649 * Misc. settings
2653 * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
2654 * which is the only safe way to determine GD version.
2656 * @global string $cfg['GD2Available']
2658 $cfg['GD2Available'] = 'auto';
2661 * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
2663 * @global array $cfg['TrustedProxies']
2665 $cfg['TrustedProxies'] = array();
2668 * We normally check the permissions on the configuration file to ensure
2669 * it's not world writable. However, phpMyAdmin could be installed on
2670 * a NTFS filesystem mounted on a non-Windows server, in which case the
2671 * permissions seems wrong but in fact cannot be detected. In this case
2672 * a sysadmin would set the following to false.
2674 $cfg['CheckConfigurationPermissions'] = true;
2677 * Limit for length of URL in links. When length would be above this limit, it
2678 * is replaced by form with button.
2679 * This is required as some web servers (IIS) have problems with long URLs.
2680 * The recommended limit is 2000
2681 * (see http://www.boutell.com/newfaq/misc/urllength.html) but we put
2682 * 1000 to accommodate Suhosin, see bug #3358750.
2684 $cfg['LinkLengthLimit'] = 1000;
2687 * Disable the table maintenance mass operations, like optimizing or
2688 * repairing the selected tables of a database. An accidental execution
2689 * of such a maintenance task can enormously slow down a bigger database.
2691 $cfg['DisableMultiTableMaintenance'] = false;
2693 /*******************************************************************************
2694 * SQL Parser Settings
2696 * @global array $cfg['SQP']
2698 $cfg['SQP'] = array();
2701 * Pretty-printing style to use on queries (html, text, none)
2703 * @global string $cfg['SQP']['fmtType']
2705 $cfg['SQP']['fmtType'] = 'html';
2708 * Amount to indent each level (floats are valid)
2710 * @global integer $cfg['SQP']['fmtInd']
2712 $cfg['SQP']['fmtInd'] = '1';
2715 * Units for indenting each level (CSS Types - {em, px, pt})
2717 * @global string $cfg['SQP']['fmtIndUnit']
2719 $cfg['SQP']['fmtIndUnit'] = 'em';
2722 /*******************************************************************************
2723 * If you wish to use the SQL Validator service, you should be aware of the
2724 * following:
2725 * All SQL statements are stored anonymously for statistical purposes.
2726 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
2727 * All rights reserved.
2729 * @global array $cfg['SQLValidator']
2731 $cfg['SQLValidator'] = array();
2734 * Make the SQL Validator available
2736 * @global boolean $cfg['SQLValidator']['use']
2738 $cfg['SQLValidator']['use'] = false;
2741 * If you have a custom username, specify it here (defaults to anonymous)
2743 * @global string $cfg['SQLValidator']['username']
2745 $cfg['SQLValidator']['username'] = '';
2748 * Password for username
2750 * @global string $cfg['SQLValidator']['password']
2752 $cfg['SQLValidator']['password'] = '';
2755 /*******************************************************************************
2756 * Developers ONLY!
2758 * @global array $cfg['DBG']
2760 $cfg['DBG'] = array();
2763 * Output executed queries and their execution times
2765 * @global boolean $cfg['DBG']['sql']
2767 $cfg['DBG']['sql'] = false;
2770 /*******************************************************************************
2771 * MySQL settings
2775 * Column types;
2776 * VARCHAR, TINYINT, TEXT and DATE are listed first, based on estimated popularity
2778 * This variable is filled in data_*.inc.php
2780 * @global array $cfg['ColumnTypes']
2782 $cfg['ColumnTypes'] = array();
2785 * Attributes
2787 * This variable is filled in data_*.inc.php
2789 * @global array $cfg['AttributeTypes']
2791 $cfg['AttributeTypes'] = array();
2794 if ($cfg['ShowFunctionFields']) {
2796 * Available functions
2798 * This variable is filled in data_*.inc.php
2800 * @global array $cfg['Functions']
2802 $cfg['Functions'] = array();
2805 * Which column types will be mapped to which Group?
2807 * This variable is filled in data_*.inc.php
2809 * @global array $cfg['RestrictColumnTypes']
2811 $cfg['RestrictColumnTypes'] = array();
2814 * Map above defined groups to any function
2816 * This variable is filled in data_*.inc.php
2818 * @global array $cfg['RestrictFunctions']
2820 $cfg['RestrictFunctions'] = array();
2823 * Default functions for above defined groups
2825 * @global array $cfg['DefaultFunctions']
2827 $cfg['DefaultFunctions'] = array(
2828 'FUNC_CHAR' => '',
2829 'FUNC_DATE' => '',
2830 'FUNC_NUMBER' => '',
2831 'FUNC_SPATIAL' => 'GeomFromText',
2832 'FUNC_UUID' => 'UUID',
2833 'first_timestamp' => 'NOW',
2835 } // end if
2838 * Search operators
2840 * @global array $cfg['NumOperators']
2842 $cfg['NumOperators'] = array(
2843 '=',
2844 '>',
2845 '>=',
2846 '<',
2847 '<=',
2848 '!=',
2849 'LIKE',
2850 'NOT LIKE',
2851 'IN (...)',
2852 'NOT IN (...)',
2853 'BETWEEN',
2854 'NOT BETWEEN',
2858 * Search operators
2860 * @global array $cfg['TextOperators']
2862 $cfg['TextOperators'] = array(
2863 'LIKE',
2864 'LIKE %...%',
2865 'NOT LIKE',
2866 '=',
2867 '!=',
2868 'REGEXP',
2869 'REGEXP ^...$',
2870 'NOT REGEXP',
2871 "= ''",
2872 "!= ''",
2873 'IN (...)',
2874 'NOT IN (...)',
2875 'BETWEEN',
2876 'NOT BETWEEN',
2880 * Search operators
2882 * @global array $cfg['EnumOperators']
2884 $cfg['EnumOperators'] = array(
2885 '=',
2886 '!=',
2890 * Search operators
2892 * @global array $cfg['SetOperators']
2894 $cfg['SetOperators'] = array(
2895 'IN',
2896 'NOT IN',
2900 * Search operators
2902 * @global array $cfg['NullOperators']
2904 $cfg['NullOperators'] = array(
2905 'IS NULL',
2906 'IS NOT NULL',
2910 * Search operators
2912 * @global array $cfg['UnaryOperators']
2914 $cfg['UnaryOperators'] = array(
2915 'IS NULL' => 1,
2916 'IS NOT NULL' => 1,
2917 "= ''" => 1,
2918 "!= ''" => 1
2922 * Max rows retreived for zoom search
2924 $cfg['maxRowPlotLimit'] = 500;