demo.phpmyadmin.net / phpMyAdmin demo - MySQL | phpMyAdmin 6.0.0-dev+20241218.57a56f1aa7

Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

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 Query failed Database: Queried time:

Your preferences will be saved for current session only. Storing them permanently requires phpMyAdmin configuration storage.

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

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.

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.

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

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5345-g57a56f1aa7 from the master branch.