Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: mysql
Page-related settingsClick 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

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 Replication 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 MyISAM utf8_bin 4 KiB -
column_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
db   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14 MyISAM utf8_bin 17.6 KiB -
event   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 2 KiB -
func   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 1 KiB -
general_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 CSV utf8_general_ci unknown -
gtid_slave_pos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB latin1_swedish_ci 16 KiB -
help_category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 39 MyISAM utf8_general_ci 4.1 KiB -
help_keyword   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 464 MyISAM utf8_general_ci 105.3 KiB -
help_relation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,028 MyISAM utf8_general_ci 26 KiB -
help_topic   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 508 MyISAM utf8_general_ci 416 KiB -
host   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 2 KiB -
index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
innodb_index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,693 InnoDB utf8_bin 336 KiB -
innodb_table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 343 InnoDB utf8_bin 64 KiB -
ndb_binlog_index   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1 KiB -
plugin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
proc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 MyISAM utf8_general_ci 5.1 KiB -
procs_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
proxies_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_bin 11.2 KiB -
roles_mapping   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
servers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
slave_master_info   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16 KiB -
slave_relay_log_info   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16 KiB -
slave_worker_info   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_general_ci 16 KiB -
slow_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 CSV utf8_general_ci unknown -
tables_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 2 KiB -
time_zone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_leap_second   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_name   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
user   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 MyISAM utf8_bin 5 KiB -
34 tables Replication Sum 5,109 InnoDB latin1_swedish_ci 1.1 MiB 0 B
With selected:

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns:
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.