phpMyAdmin setup

Customize startup page.

Show create database form
Show statistics Allow to display database and table statistics (eg. space usage).
Show detailed MySQL server information
Show phpinfo() link Shows link to phpinfo() output.
Show password change form Please note that enabling this has no effect with config authentication mode because the password is hard coded in the configuration file; this does not limit the ability to execute the same command directly.

Choose which details to show in the database structure (list of tables).

Show table charset Show or hide a column displaying the charset for all tables.
Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Settings for the table structure (list of columns).

Hide table structure actions Whether the table structure actions should be hidden.
Show column comments Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	2
Default transformations for Substring Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 all …
Default transformations for Bool2Text Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	T F
Default transformations for External Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 local
Default transformations for Inline Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 100
Default transformations for TextImageLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 50
Default transformations for TextLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

Customize browse mode.

Table navigation bar Use only icons, only text or both.	IconsTextBoth
How to display various action links Use only icons, only text or both.	IconsTextBoth
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.	2550100250500
Default sorting order SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.	ASCDESCSMART
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action	ClickDouble clickDisabled
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, 0 deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.	NowhereLeftRightBoth
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.	NoneAscendingDescending
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options	keydisplay column

Customize edit mode.

Protect binary columns Disallow BLOB and BINARY columns from editing.	noblobnobloball
Show function fields Display the function fields in edit/insert mode.
Show field types Defines whether or not type fields should be initially displayed in edit/insert mode.
Number of inserted rows How many rows can be inserted at one time.
Foreign key dropdown order Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value.	content-id id-content
Foreign key limit A dropdown will be used if fewer items are present.

Choose how you want tabs to work.

How to display the menu tabs Use only icons, only text or both.	IconsTextBoth
Default server tab Tab that is displayed when entering a server.	WelcomeDatabasesStatusVariablesPrivileges
Default database tab Tab that is displayed when entering a database.	StructureSQLSearchOperations
Default table tab Tab that is displayed when entering a table.	StructureSQLSearchInsertBrowse