localhost:8080 / 127.0.0.1 | phpMyAdmin 5.2.1

phpMyAdmin

Empty session data

phpMyAdmin documentation

MariaDB Documentation

Reload navigation panel

There are no favorite tables.

Drop files here

SQL upload ( 0 ) x -

Page-related settings

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Set some commonly used options.

General

Version check Enables check for latest version on main phpMyAdmin page.
Natural order Use natural order for sorting table and database names.
Initial state for sliders
Login cookie validity Define how long (in seconds) a login cookie is valid.
Skip locked tables Mark used tables and make it possible to show databases with locked tables.
Disable multi table maintenance Disable the table maintenance mass operations, like optimizing or repairing the selected tables of a database.
Show hint Whether to show hint or not.
Send error reports Choose the default action when sending error reports.
Enter executes queries in console Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines will be inserted with Shift+Enter.
Disable shortcut keys Disable shortcut keys
First day of calendar

Databases

Show only listed databases You can use MySQL wildcard characters (% and _), escape them if you want to use their literal instances, i.e. use `'my\_db'` and not `'my_db'`.
Hide databases Hide databases matching regular expression (PCRE).
Maximum databases Maximum number of databases displayed in database list.
Maximum tables Maximum number of tables displayed in table list.
Server connection collation

Customize text input fields.

Text fields

CHAR columns editing Defines which type of editing controls should be used for CHAR and VARCHAR columns; `input` - allows limiting of input length, `textarea` - allows newlines in columns.
Minimum size for input field Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Maximum size for input field Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
CHAR textarea columns Number of columns for CHAR/VARCHAR textareas.
CHAR textarea rows Number of rows for CHAR/VARCHAR textareas.
Textarea columns Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Textarea rows Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Bigger textarea for LONGTEXT Double size of textarea for LONGTEXT columns.

Specify browser's title bar text. Refer to documentation for magic strings that can be used to get special values.

Page titles

Default title Title of browser window when nothing is selected.
Table Title of browser window when a table is selected.
Database Title of browser window when a database is selected.
Server Title of browser window when a server is selected.

Disable some of the warnings shown by phpMyAdmin.

Warnings

Missing phpMyAdmin configuration storage tables Disable the default warning that is displayed on the database details Structure page if any of the required tables for the phpMyAdmin configuration storage could not be found.
Suhosin warning Disable the default warning that is displayed on the main page if Suhosin is detected.
Login cookie validity warning Disable the default warning that is displayed on the main page if the value of the PHP setting session.gc_maxlifetime is less than the value of `LoginCookieValidity`.
MySQL reserved word warning Disable the default warning that is displayed on the Structure page if column names in a table are reserved MySQL words.

Console

Console mode
Show query history at start
Always expand query messages
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter
Switch to dark theme
Console height
Group queries
Order by
Order

Open new phpMyAdmin window