Recent
`mysql`.`global_priv`
`information_schema`.`COLUMNS`
`mysql`.`transaction_registry`
`information_schema`.`INNODB_TRX`
`phpmyadmin`.`pma__history`
`phpmyadmin`.`pma__pdf_pages`
`phpmyadmin`.`pma__table_coords`
`information_schema`.`CLIENT_STATISTICS`
`information_schema`.`INNODB_CMP_PER_INDEX`
`information_schema`.`INNODB_SYS_COLUMNS`
Favorites
There are no favorite tables.
New
dat
information_schema
moodle
mysql
performance_schema
phpmyadmin
test
ugc_db
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Databases
SQL
Status
User accounts
Export
Import
Settings
(current)
Variables
Charsets
Engines
Plugins
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Manage your settings
Two-factor authentication
Features
SQL queries
Navigation panel
Main panel
Export
Import
General
Databases
Text fields
Page titles
Warnings
Console
General
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
Open
Closed
Disabled
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.
Ask before sending error reports
Always send error reports
Never send 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
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Databases
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
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.
input
textarea
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
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.
Warnings
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
Console mode
info
show
collapse
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
exec
time
count
Order
asc
desc