Server

MySQL hostname or IP address

MySQL port - leave blank for default port

Path to the socket - leave blank for default socket

Use SSL for connecting to MySQL server?

Path to the key file when using SSL for connecting to the MySQL server

Path to the cert file when using SSL for connecting to the MySQL server

Path to the CA file when using SSL for connecting to the MySQL server

Directory containing trusted SSL CA certificates in PEM format

List of allowable ciphers for SSL connections to the MySQL server

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)

Use compressed protocol for the MySQL connection

MySQL control host. This permits to use a host different from the main host, for the phpMyAdmin configuration storage. If left empty, $cfg['Servers'][$i]['host'] is used instead.

MySQL control port. This permits to use a port different from the main port, for the phpMyAdmin configuration storage. If left empty, $cfg['Servers'][$i]['port'] is used instead.

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)

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)

Authentication method (valid choices: config, http, signon or cookie)

HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)

MySQL user

MySQL password (only needed with 'config' auth_type)

Session to use for 'signon' authentication method

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

PHP script to use for 'signon' authentication method

URL where to redirect user to login for 'signon' authentication method

URL where to redirect user after logout

If set to a db-name, only this db is displayed in navigation panel It may also be an array of db-names

Database name to be hidden from listings

Verbose name for this host - leave blank to show the hostname (for HTTP authentication, all non-US-ASCII characters will be stripped)

Database used for Relation, Bookmark and PDF Features (see resources/sql/create_tables.sql)

• leave blank for no support SUGGESTED: 'phpmyadmin'

Bookmark table

• leave blank for no bookmark support SUGGESTED: 'pma__bookmark'

table to describe the relation between links (see doc)

• leave blank for no relation-links support SUGGESTED: 'pma__relation'

table to describe the display fields

• leave blank for no display fields support SUGGESTED: 'pma__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'

table to describe pages of relationpdf

• leave blank if you don't want to use this SUGGESTED: 'pma__pdf_pages'

table to store column information

• leave blank for no column comments/mime types SUGGESTED: 'pma__column_info'

table to store SQL history

• leave blank for no SQL query history SUGGESTED: 'pma__history'

table to store recently used tables

• leave blank for no "persistent" recently used tables SUGGESTED: 'pma__recent'

table to store favorite tables

• leave blank for no favorite tables SUGGESTED: 'pma__favorite'

table to store UI preferences for tables

• leave blank for no "persistent" UI preferences SUGGESTED: 'pma__table_uiprefs'

table to store SQL tracking

• leave blank for no SQL tracking SUGGESTED: 'pma__tracking'

table to store user preferences

• leave blank to disable server storage SUGGESTED: 'pma__userconfig'

table to store users and their assignment to user groups

• leave blank to disable configurable menus feature SUGGESTED: 'pma__users'

table to store allowed menu items for each user group

• leave blank to disable configurable menus feature SUGGESTED: 'pma__usergroups'

table to store information about item hidden from navigation tree

• leave blank to disable hide/show navigation items feature SUGGESTED: 'pma__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'

table to store central list of columns per database

• leave blank to disable central list of columns feature SUGGESTED: 'pma__central_columns'

table to store designer settings

• leave blank to disable the storage of designer settings SUGGESTED: 'pma__designer_settings'

table to store export templates

• leave blank to disable saved searches feature SUGGESTED: 'pma__export_templates'

Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.

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

whether to allow root login

whether to allow login of any user without a password

Host authentication

Disable use of INFORMATION_SCHEMA.

Whether the tracking mechanism creates versions for tables and views automatically.

Defines the list of statements the auto-creation uses for new versions.

Whether a DROP VIEW IF EXISTS statement will be added as first line to the log when creating a view.

Whether a DROP TABLE IF EXISTS statement will be added as first line to the log when creating a table.

Whether a DROP DATABASE IF EXISTS statement will be added as first line to the log when creating a database.

Whether to show or hide detailed MySQL/MariaDB connection errors on the login page.