Settings

Your phpMyAdmin URL.

Configure authentication logging destination

Whether to log successful authentication attempts

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

Disable the default warning that is displayed if Suhosin is detected

Disable the default warning that is displayed if session.gc_maxlifetime is less than LoginCookieValidity

Disable the default warning about MySQL reserved words in column names

Show warning about incomplete translations on certain threshold.

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.

The 'cookie' auth_type uses the Sodium extension to encrypt the cookies. If at least one server configuration uses 'cookie' auth_type, enter here a generated string of random bytes to be used as an encryption key. The encryption key must be 32 bytes long.

Server(s) configuration

Default server (0 = no default server)

whether version check is active

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 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.

The password for authenticating with the proxy.

maximum number of db's displayed in database list

maximum number of tables displayed in table list

whether to show hint or not

maximum number of characters when a SQL query is displayed

use GZIP output buffering if possible (true|false|'auto')

use persistent connections to MySQL database

maximum execution time in seconds (0 for no limit)

Path for storing session data (session_save_path PHP parameter).

Hosts or IPs to consider safe when checking if SSL is used or not

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

mark used tables, make possible to show locked tables (since MySQL 3.23.30)

show SQL queries as run

retain SQL input on Ajax execute

use CodeMirror syntax highlighting for editing SQL

use the parser to find any errors in the query before executing

show a 'Drop database' link to normal users

confirm some commands that can result in loss of data

sets SameSite attribute of the Set-Cookie HTTP response header

recall previous login in cookie authentication mode or not

validity of cookie login (in seconds; 1440 matches php.ini's session.gc_maxlifetime)

how long login cookie should be stored (in seconds)

whether to delete all login cookies on logout

whether to enable the "database search" feature or not

if set to true, PMA continues computing multiple-statement queries even if one of the queries failed

Define whether phpMyAdmin will encrypt sensitive data from the URL query string.

A secret key used to encrypt/decrypt the URL query string. Should be 32 bytes long.

allow login to any user entered server in cookie based authentication

restrict by IP (with regular expression) the MySQL servers the user can enter when $cfg['AllowArbitraryServer'] = true

To enable reCaptcha v2 checkbox mode if necessary

URL for the reCaptcha v2 compatible API to use

Content-Security-Policy snippet for the reCaptcha v2 compatible API

reCaptcha API's request parameter name

reCaptcha API's response parameter name

if reCaptcha is enabled it needs public key to connect with the service

if reCaptcha is enabled it needs private key to connect with the service

if reCaptcha is enabled may need an URL for site verify

Enable drag and drop import

In the navigation panel, replaces the database tree with a selector

maximum number of first level databases displayed in navigation panel

maximum number of items displayed in navigation panel

turn the select-based light menu into a tree

the separator to sub-tree the select-based light menu tree

Which string will be used to generate table prefixes to split/nest tables into multiple categories

How many sublevels should be displayed when splitting up tables by the above Separator

link with main panel by highlighting the current db/table

display logo at top of navigation panel

where should logo link point to (can also contain an external URL)

whether to open the linked page in the main window ('main') or in a new window ('new')

number of recently used tables displayed in the navigation panel

number of favorite tables displayed in the navigation panel

display a JavaScript table filter in the navigation panel when more then x tables are present

display server choice at top of navigation panel

server choice as links

display a JavaScript database filter in the navigation panel when more then x databases are present

target of the navigation panel quick access icon

target of the navigation panel quick second access icon

Enables the possibility of navigation tree expansion

Show tables in navigation panel

Show views in navigation panel

Show functions in navigation panel

Show procedures in navigation panel

Show events in navigation panel

Width of navigation panel

Automatically expands single database in navigation panel

allow to display statistics and space usage in the pages about database details and table properties

show PHP info link

show MySQL server and/or web server information (true|false|'database-server'|'web-server')

show change password link

show create database form

show charset column in database structure (true|false)?

show comment column in database structure (true|false)?

show creation timestamp column in database structure (true|false)?

show last update timestamp column in database structure (true|false)?

show last check timestamp column in database structure (true|false)?

allow hide action columns to drop down menu in database structure (true|false)?

Show column comments in table structure view (true|false)?

Use icons instead of text for the navigation bar buttons (table browse) ('text'|'icons'|'both')

Defines whether a user should be displayed a "show all (records)" button in browse mode or not.

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next".

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-)

grid editing: save edited cell(s) in browse-mode at once

grid editing: which action triggers it, or completely disable the feature

Options > Relational display

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

Display the function fields in edit/insert mode

Display the type fields in edit/insert mode

Which editor should be used for CHAR/VARCHAR fields: input - allows limiting of input length textarea - allows newlines in fields

The minimum size for character input fields

The maximum size for character input fields

How many rows can be inserted at one time

Sort order for items in a foreign-key drop-down list.

A drop-down list will be used if fewer items are present

Whether to disable foreign key checks while importing

Allow for the use of zip compression (requires zip support to be enabled)

Allow for the use of gzip compression (requires zlib)

Allow for the use of bzip2 decompression (requires bz2 extension)

Will compress gzip exports on the fly without the need for much memory.

How to display the menu tabs ('icons'|'text'|'both')

How to display various action links ('icons'|'text'|'both')

How many columns should be used for table display of a database? (a value larger than 1 results in some information being hidden)

Possible values: 'welcome' = the welcome page (recommended for multiuser setups) 'databases' = list of databases 'status' = runtime information 'variables' = MySQL server variables 'privileges' = user management

Possible values: 'structure' = tables list 'sql' = SQL form 'search' = search query 'operations' = operations on database

Possible values: 'structure' = fields list 'sql' = SQL form 'search' = search page 'insert' = insert row page 'browse' = browse page

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.

Export defaults

Import defaults

Schema export defaults

Possible paper sizes for creating PDF pages.

Default page size to use when creating PDF pages.

Default language to use, if not browser-defined or user-defined

Default connection collation

Force: always use this language, e.g. 'en'

Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and English only

You can select here which functions will be used for character set conversion.

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

Available character sets for MySQL conversion. currently contains all which could be found in lang/* files and few more.

enable the left panel pointer

enable the browse pointer

enable the browse marker

textarea size (columns) in edit mode (this value will be emphasized (2) for SQL query textareas and (1.25) for query window)

textarea size (rows) in edit mode

double size of textarea size for LONGTEXT columns

auto-select when clicking in the textarea of the query-box

textarea size (columns) for CHAR/VARCHAR

textarea size (rows) for CHAR/VARCHAR

Max field data length in browse mode for all non-numeric fields

Where to show the edit/copy/delete links in browse mode Possible values are 'left', 'right', 'both' and 'none'.

Whether to show row links (Edit, Copy, Delete) and checkboxes for multiple row operations even when the selection does not have a unique key.

Default sort order by primary key.

remember the last way a table sorted

shows column comments in 'browse' mode.

shows column comments in 'table property' mode.

repeat header names every X cells? (0 = deactivate)

Set to true if you want DB-based query history.If false, this utilizes JS-routines to display query history (lost by window close)

When using DB-based query history, how many entries should be kept?

Allow shared bookmarks between users

Use MIME-Types (stored in column comments table) for

When approximate count < this, PMA will get exact count for table rows.

Zero means that no row count is done for views; see the doc

Sort table and database in natural order

Initial state for sliders (open | closed | disabled)

User preferences: disallow these settings For possible setting names look in src/Config/Forms/User/

User preferences: enable the Developer tab

title of browser window when a table is selected

title of browser window when a database is selected

title of browser window when a server is selected

title of browser window when nothing is selected

if you want to use selectable themes and if ThemesPath not empty set it to true, else set it to false (default is false);

set up default theme, you can set up here an valid path to themes or 'original' for the original pma-theme

allow different theme for each configured server

Default query for table

Default query for database

SQL Query box settings These are the links display in all of the SQL Query boxes

Enables autoComplete for table & column names in SQL queries

Directory for uploaded files that can be executed by phpMyAdmin.

Directory where phpMyAdmin can save exported data on server.

Directory where phpMyAdmin can save temporary files.

Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection, which is the only safe way to determine GD version.

Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny

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.

Limit for length of URL in links. When length would be above this limit, it is replaced by form with button.

Additional string to allow in CSP headers.

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.

Whether or not to query the user before sending the error report to the phpMyAdmin team when a JavaScript error occurs

Whether Enter or Ctrl+Enter executes queries in the console.

Zero Configuration mode.

Developers ONLY!

Sets the working environment

Default functions for above defined groups

Max rows retrieved for zoom search

Show Git revision if applicable

MySQL minimal version required

Disable shortcuts

Console configuration

Initialize default transformations array

Set default for FirstDayOfCalendar