←

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: mysql
Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Some errors have been detected on the server!
Please look at the bottom of this window.

Database structure

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

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
columns_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
column_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
db   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 Aria utf8_bin 40.0 KiB -
event   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
func   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
general_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 CSV utf8_general_ci unknown  -
global_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 Aria utf8_bin 32.0 KiB -
gtid_slave_pos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
help_category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 48 Aria utf8_general_ci 40.0 KiB -
help_keyword   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 37 Aria utf8_general_ci 40.0 KiB -
help_relation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 114 Aria utf8_general_ci 32.0 KiB -
help_topic   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 752 Aria utf8_general_ci 1.6 MiB -
index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
innodb_index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,818 InnoDB utf8_bin 320.0 KiB -
innodb_table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 229 InnoDB utf8_bin 48.0 KiB -
plugin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
proc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
procs_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
proxies_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 Aria utf8_bin 40.0 KiB -
roles_mapping   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
servers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
slow_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 CSV utf8_general_ci unknown  -
tables_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_bin 16.0 KiB -
time_zone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
time_zone_leap_second   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
time_zone_name   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
time_zone_transition   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
time_zone_transition_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 Aria utf8_general_ci 16.0 KiB -
transaction_registry   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_bin 64.0 KiB -
user   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
31 tables Sum ~3,006 InnoDB utf8mb4_general_ci 2.5 MiB 0 B
With selected:

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns:
Warning in .\libraries\classes\Dbi\DbiMysqli.php#199
mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it

Backtrace

.\libraries\classes\Dbi\DbiMysqli.php#199: mysqli->query(
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 0,
)
.\libraries\classes\DatabaseInterface.php#316: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2396: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 256,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2338: PhpMyAdmin\DatabaseInterface->isUserType(string 'super')
.\libraries\classes\Menu.php#450: PhpMyAdmin\DatabaseInterface->isSuperuser()
.\libraries\classes\Menu.php#103: PhpMyAdmin\Menu->_getDbTabs()
.\libraries\classes\Menu.php#70: PhpMyAdmin\Menu->_getMenu()
.\libraries\classes\Header.php#450: PhpMyAdmin\Menu->getDisplay()
.\libraries\classes\Response.php#343: PhpMyAdmin\Header->getDisplay()
.\libraries\classes\Response.php#356: PhpMyAdmin\Response->_getDisplay()
.\libraries\classes\Response.php#514: PhpMyAdmin\Response->_htmlResponse()
PhpMyAdmin\Response->response()