demo.phpmyadmin.net / phpMyAdmin demo - MariaDB

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

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:

Plug-ins

AUTHENTICATION INFORMATION SCHEMA REPLICATION STORAGE ENGINE

AUTHENTICATION
Plug-in	Description	Version	Author	Licence
mysql_native_password	Native MySQL authentication	1.0	R.J.Silk, Sergei Golubchik	GPL
mysql_old_password	Old MySQL-4.0 authentication	1.0	R.J.Silk, Sergei Golubchik	GPL
unix_socket	Unix Socket based authentication	1.0	Sergei Golubchik	GPL

INFORMATION SCHEMA
Plug-in	Description	Version	Author	Licence
CLIENT_STATISTICS	Client Statistics	2.0	Percona and Sergei Golubchik	GPL
FEEDBACK disabled	MariaDB User Feedback Plugin	1.1	Sergei Golubchik	GPL
INDEX_STATISTICS	Index Statistics	2.0	Percona and Sergei Golubchik	GPL
INNODB_BUFFER_PAGE	InnoDB Buffer Page Information	10.4	Oracle Corporation	GPL
INNODB_BUFFER_PAGE_LRU	InnoDB Buffer Page in LRU	10.4	Oracle Corporation	GPL
INNODB_BUFFER_POOL_STATS	InnoDB Buffer Pool Statistics Information	10.4	Oracle Corporation	GPL
INNODB_CMP	Statistics for the InnoDB compression	10.4	Oracle Corporation	GPL
INNODB_CMPMEM	Statistics for the InnoDB compressed buffer pool	10.4	Oracle Corporation	GPL
INNODB_CMPMEM_RESET	Statistics for the InnoDB compressed buffer pool; reset cumulated counts	10.4	Oracle Corporation	GPL
INNODB_CMP_PER_INDEX	Statistics for the InnoDB compression (per index)	10.4	Oracle Corporation	GPL
INNODB_CMP_PER_INDEX_RESET	Statistics for the InnoDB compression (per index); reset cumulated counts	10.4	Oracle Corporation	GPL
INNODB_CMP_RESET	Statistics for the InnoDB compression; reset cumulated counts	10.4	Oracle Corporation	GPL
INNODB_FT_BEING_DELETED	INNODB AUXILIARY FTS BEING DELETED TABLE	10.4	Oracle Corporation	GPL
INNODB_FT_CONFIG	INNODB AUXILIARY FTS CONFIG TABLE	10.4	Oracle Corporation	GPL
INNODB_FT_DEFAULT_STOPWORD	Default stopword list for InnoDB Full Text Search	10.4	Oracle Corporation	GPL
INNODB_FT_DELETED	INNODB AUXILIARY FTS DELETED TABLE	10.4	Oracle Corporation	GPL
INNODB_FT_INDEX_CACHE	INNODB AUXILIARY FTS INDEX CACHED	10.4	Oracle Corporation	GPL
INNODB_FT_INDEX_TABLE	INNODB AUXILIARY FTS INDEX TABLE	10.4	Oracle Corporation	GPL
INNODB_LOCKS	InnoDB conflicting locks	10.4	Oracle Corporation	GPL
INNODB_LOCK_WAITS	InnoDB which lock is blocking which	10.4	Oracle Corporation	GPL
INNODB_METRICS	InnoDB Metrics Info	10.4	Oracle Corporation	GPL
INNODB_MUTEXES	InnoDB SYS_DATAFILES	10.4	Oracle Corporation	GPL
INNODB_SYS_COLUMNS	InnoDB SYS_COLUMNS	10.4	Oracle Corporation	GPL
INNODB_SYS_DATAFILES	InnoDB SYS_DATAFILES	10.4	Oracle Corporation	GPL
INNODB_SYS_FIELDS	InnoDB SYS_FIELDS	10.4	Oracle Corporation	GPL
INNODB_SYS_FOREIGN	InnoDB SYS_FOREIGN	10.4	Oracle Corporation	GPL
INNODB_SYS_FOREIGN_COLS	InnoDB SYS_FOREIGN_COLS	10.4	Oracle Corporation	GPL
INNODB_SYS_INDEXES	InnoDB SYS_INDEXES	10.4	Oracle Corporation	GPL
INNODB_SYS_SEMAPHORE_WAITS	InnoDB SYS_SEMAPHORE_WAITS	10.4	MariaDB Corporation	GPL
INNODB_SYS_TABLES	InnoDB SYS_TABLES	10.4	Oracle Corporation	GPL
INNODB_SYS_TABLESPACES	InnoDB SYS_TABLESPACES	10.4	Oracle Corporation	GPL
INNODB_SYS_TABLESTATS	InnoDB SYS_TABLESTATS	10.4	Oracle Corporation	GPL
INNODB_SYS_VIRTUAL	InnoDB SYS_VIRTUAL	10.4	Oracle Corporation	GPL
INNODB_TABLESPACES_ENCRYPTION	InnoDB TABLESPACES_ENCRYPTION	10.4	Google Inc	BSD
INNODB_TABLESPACES_SCRUBBING	InnoDB TABLESPACES_SCRUBBING	10.4	Google Inc	BSD
INNODB_TRX	InnoDB transactions	10.4	Oracle Corporation	GPL
TABLE_STATISTICS	Table Statistics	2.0	Percona and Sergei Golubchik	GPL
USER_STATISTICS	User Statistics	2.0	Percona and Sergei Golubchik	GPL
user_variables	User-defined variables	1.0	Sergey Vojtovich	GPL

REPLICATION
Plug-in	Description	Version	Author	Licence
wsrep	Wsrep replication plugin	1.0	Codership Oy	GPL

STORAGE ENGINE
Plug-in	Description	Version	Author	Licence
Aria	Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables	1.5	MariaDB Corporation Ab	GPL
binlog	This is a pseudo storage engine to represent the binlog in a transaction	1.0	MySQL AB	GPL
CSV	Stores tables as CSV files	1.0	Brian Aker, MySQL AB	GPL
InnoDB	Supports transactions, row-level locking, foreign keys and encryption for tables	10.4	Oracle Corporation	GPL
MEMORY	Hash based, stored in memory, useful for temporary tables	1.0	MySQL AB	GPL
MRG_MyISAM	Collection of identical MyISAM tables	1.0	MySQL AB	GPL
MyISAM	Non-transactional engine with good performance and small data footprint	1.0	MySQL AB	GPL
partition	Partition Storage Engine Helper	1.0	Mikael Ronstrom, MySQL AB	GPL
PERFORMANCE_SCHEMA	Performance Schema	0.1	Marc Alff, Oracle	GPL
SEQUENCE	Generated tables filled with sequential values	1.0	Sergei Golubchik	GPL
SQL_SEQUENCE	Sequence Storage Engine for CREATE SEQUENCE	1.0	jianwei.zhao @ Aliyun & Monty @ MariaDB corp	GPL

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.