Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.118.31.32
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
perfschema /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
all_tests.result
1.38
KB
-rw-r--r--
alter_table_progress.result
2.96
KB
-rw-r--r--
bad_option.result
342
B
-rw-r--r--
batch_table_io_func.result
6.2
KB
-rw-r--r--
binlog_edge_mix.result
8.28
KB
-rw-r--r--
binlog_edge_row.result
8.58
KB
-rw-r--r--
binlog_edge_stmt.result
15.31
KB
-rw-r--r--
binlog_ok_mix.result
4.6
KB
-rw-r--r--
binlog_ok_row.result
4.6
KB
-rw-r--r--
binlog_ok_stmt.result
4.6
KB
-rw-r--r--
checksum.result
7.33
KB
-rw-r--r--
cnf_option.result
263
B
-rw-r--r--
column_privilege.result
2.06
KB
-rw-r--r--
connect_attrs.result
1.47
KB
-rw-r--r--
connection.result
26.22
KB
-rw-r--r--
connection_3a.result
25.15
KB
-rw-r--r--
connection_3a_3u.result
24.58
KB
-rw-r--r--
connection_3u.result
25.66
KB
-rw-r--r--
connection_type_notwin.result
3.24
KB
-rw-r--r--
connection_type_win.result
3.33
KB
-rw-r--r--
csv_table_io.result
5.69
KB
-rw-r--r--
ddl_accounts.result
539
B
-rw-r--r--
ddl_cond_instances.result
580
B
-rw-r--r--
ddl_esgs_by_account_by_event_n...
669
B
-rw-r--r--
ddl_esgs_by_host_by_event_name...
657
B
-rw-r--r--
ddl_esgs_by_thread_by_event_na...
667
B
-rw-r--r--
ddl_esgs_by_user_by_event_name...
657
B
-rw-r--r--
ddl_esgs_global_by_event_name....
657
B
-rw-r--r--
ddl_esms_by_account_by_event_n...
685
B
-rw-r--r--
ddl_esms_by_digest.result
621
B
-rw-r--r--
ddl_esms_by_host_by_event_name...
673
B
-rw-r--r--
ddl_esms_by_program.result
635
B
-rw-r--r--
ddl_esms_by_thread_by_event_na...
683
B
-rw-r--r--
ddl_esms_by_user_by_event_name...
673
B
-rw-r--r--
ddl_esms_global_by_event_name....
673
B
-rw-r--r--
ddl_ets_by_account_by_event_na...
693
B
-rw-r--r--
ddl_ets_by_host_by_event_name....
681
B
-rw-r--r--
ddl_ets_by_thread_by_event_nam...
691
B
-rw-r--r--
ddl_ets_by_user_by_event_name....
681
B
-rw-r--r--
ddl_ets_global_by_event_name.r...
681
B
-rw-r--r--
ddl_events_stages_current.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history.resu...
1.18
KB
-rw-r--r--
ddl_events_stages_history_long...
1.21
KB
-rw-r--r--
ddl_events_statements_current....
585
B
-rw-r--r--
ddl_events_statements_history....
585
B
-rw-r--r--
ddl_events_statements_history_...
605
B
-rw-r--r--
ddl_events_transactions_curren...
593
B
-rw-r--r--
ddl_events_transactions_histor...
593
B
-rw-r--r--
ddl_events_transactions_histor...
613
B
-rw-r--r--
ddl_events_waits_current.resul...
565
B
-rw-r--r--
ddl_events_waits_history.resul...
565
B
-rw-r--r--
ddl_events_waits_history_long....
585
B
-rw-r--r--
ddl_ews_by_account_by_event_na...
665
B
-rw-r--r--
ddl_ews_by_host_by_event_name....
653
B
-rw-r--r--
ddl_ews_by_instance.result
617
B
-rw-r--r--
ddl_ews_by_thread_by_event_nam...
663
B
-rw-r--r--
ddl_ews_by_user_by_event_name....
653
B
-rw-r--r--
ddl_ews_global_by_event_name.r...
653
B
-rw-r--r--
ddl_file_instances.result
590
B
-rw-r--r--
ddl_fs_by_event_name.result
581
B
-rw-r--r--
ddl_fs_by_instance.result
573
B
-rw-r--r--
ddl_global_status.result
547
B
-rw-r--r--
ddl_global_variables.result
606
B
-rw-r--r--
ddl_host_cache.result
513
B
-rw-r--r--
ddl_hosts.result
527
B
-rw-r--r--
ddl_mems_by_account_by_event_n...
641
B
-rw-r--r--
ddl_mems_by_host_by_event_name...
629
B
-rw-r--r--
ddl_mems_by_thread_by_event_na...
637
B
-rw-r--r--
ddl_mems_by_user_by_event_name...
629
B
-rw-r--r--
ddl_mems_global_by_event_name....
625
B
-rw-r--r--
ddl_metadata_locks.result
592
B
-rw-r--r--
ddl_mutex_instances.result
584
B
-rw-r--r--
ddl_os_global_by_type.result
611
B
-rw-r--r--
ddl_performance_timers.result
608
B
-rw-r--r--
ddl_prepared_statements_instan...
619
B
-rw-r--r--
ddl_processlist.result
1
KB
-rw-r--r--
ddl_replication_applier_config...
674
B
-rw-r--r--
ddl_replication_applier_status...
650
B
-rw-r--r--
ddl_replication_applier_status...
698
B
-rw-r--r--
ddl_replication_applier_status...
678
B
-rw-r--r--
ddl_replication_connection_con...
668
B
-rw-r--r--
ddl_replication_connection_sta...
650
B
-rw-r--r--
ddl_replication_group_member_s...
654
B
-rw-r--r--
ddl_replication_group_members....
634
B
-rw-r--r--
ddl_rwlock_instances.result
588
B
-rw-r--r--
ddl_session_account_connect_at...
650
B
-rw-r--r--
ddl_session_connect_attrs.resu...
618
B
-rw-r--r--
ddl_session_status.result
598
B
-rw-r--r--
ddl_session_variables.result
610
B
-rw-r--r--
ddl_setup_actors.result
972
B
-rw-r--r--
ddl_setup_consumers.result
584
B
-rw-r--r--
ddl_setup_instruments.result
592
B
-rw-r--r--
ddl_setup_objects.result
843
B
-rw-r--r--
ddl_setup_timers.result
572
B
-rw-r--r--
ddl_socket_instances.result
598
B
-rw-r--r--
ddl_socket_summary_by_event_na...
591
B
-rw-r--r--
ddl_socket_summary_by_instance...
591
B
-rw-r--r--
ddl_status_by_account.result
563
B
-rw-r--r--
ddl_status_by_host.result
551
B
-rw-r--r--
ddl_status_by_thread.result
559
B
-rw-r--r--
ddl_status_by_user.result
551
B
-rw-r--r--
ddl_table_handles.result
588
B
-rw-r--r--
ddl_threads.result
572
B
-rw-r--r--
ddl_tiws_by_index_usage.result
637
B
-rw-r--r--
ddl_tiws_by_table.result
613
B
-rw-r--r--
ddl_tlws_by_table.result
621
B
-rw-r--r--
ddl_users.result
527
B
-rw-r--r--
ddl_uvar_by_thread.result
638
B
-rw-r--r--
ddl_variables_by_thread.result
618
B
-rw-r--r--
digest_null_literal.result
804
B
-rw-r--r--
digest_table_full.result
3.63
KB
-rw-r--r--
digest_view.result
6.42
KB
-rw-r--r--
dml_accounts.result
1.19
KB
-rw-r--r--
dml_cond_instances.result
1.06
KB
-rw-r--r--
dml_esgs_by_account_by_event_n...
1.85
KB
-rw-r--r--
dml_esgs_by_host_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_by_thread_by_event_na...
1.83
KB
-rw-r--r--
dml_esgs_by_user_by_event_name...
1.79
KB
-rw-r--r--
dml_esgs_global_by_event_name....
1.77
KB
-rw-r--r--
dml_esms_by_account_by_event_n...
1.92
KB
-rw-r--r--
dml_esms_by_digest.result
2.57
KB
-rw-r--r--
dml_esms_by_host_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_by_program.result
2.77
KB
-rw-r--r--
dml_esms_by_thread_by_event_na...
1.89
KB
-rw-r--r--
dml_esms_by_user_by_event_name...
1.86
KB
-rw-r--r--
dml_esms_global_by_event_name....
1.83
KB
-rw-r--r--
dml_ets_by_account_by_event_na...
1.95
KB
-rw-r--r--
dml_ets_by_host_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_by_thread_by_event_nam...
1.92
KB
-rw-r--r--
dml_ets_by_user_by_event_name....
1.89
KB
-rw-r--r--
dml_ets_global_by_event_name.r...
1.86
KB
-rw-r--r--
dml_events_stages_current.resu...
1.41
KB
-rw-r--r--
dml_events_stages_history.resu...
1.64
KB
-rw-r--r--
dml_events_stages_history_long...
1.73
KB
-rw-r--r--
dml_events_statements_current....
1.48
KB
-rw-r--r--
dml_events_statements_history....
1.73
KB
-rw-r--r--
dml_events_statements_history_...
1.81
KB
-rw-r--r--
dml_events_transactions_curren...
1.51
KB
-rw-r--r--
dml_events_transactions_histor...
1.76
KB
-rw-r--r--
dml_events_transactions_histor...
1.85
KB
-rw-r--r--
dml_events_waits_current.resul...
1.4
KB
-rw-r--r--
dml_events_waits_history.resul...
1.64
KB
-rw-r--r--
dml_events_waits_history_long....
1.73
KB
-rw-r--r--
dml_ews_by_account_by_event_na...
2.04
KB
-rw-r--r--
dml_ews_by_host_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_by_instance.result
2.07
KB
-rw-r--r--
dml_ews_by_thread_by_event_nam...
1.81
KB
-rw-r--r--
dml_ews_by_user_by_event_name....
1.97
KB
-rw-r--r--
dml_ews_global_by_event_name.r...
1.75
KB
-rw-r--r--
dml_file_instances.result
3.21
KB
-rw-r--r--
dml_fs_by_event_name.result
1.52
KB
-rw-r--r--
dml_fs_by_instance.result
1.49
KB
-rw-r--r--
dml_global_status.result
1.13
KB
-rw-r--r--
dml_global_variables.result
1.17
KB
-rw-r--r--
dml_handler.result
19.35
KB
-rw-r--r--
dml_host_cache.result
1.28
KB
-rw-r--r--
dml_hosts.result
1.12
KB
-rw-r--r--
dml_mems_by_account_by_event_n...
1.76
KB
-rw-r--r--
dml_mems_by_host_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_by_thread_by_event_na...
1.74
KB
-rw-r--r--
dml_mems_by_user_by_event_name...
1.71
KB
-rw-r--r--
dml_mems_global_by_event_name....
1.68
KB
-rw-r--r--
dml_metadata_locks.result
1.22
KB
-rw-r--r--
dml_mutex_instances.result
1.07
KB
-rw-r--r--
dml_os_global_by_type.result
2.81
KB
-rw-r--r--
dml_performance_timers.result
1.56
KB
-rw-r--r--
dml_prepared_statements_instan...
2.82
KB
-rw-r--r--
dml_processlist.result
1.26
KB
-rw-r--r--
dml_replication_applier_config...
1.33
KB
-rw-r--r--
dml_replication_applier_status...
1.46
KB
-rw-r--r--
dml_replication_applier_status...
1.75
KB
-rw-r--r--
dml_replication_applier_status...
1.67
KB
-rw-r--r--
dml_replication_connection_con...
1.64
KB
-rw-r--r--
dml_replication_connection_sta...
1.59
KB
-rw-r--r--
dml_replication_group_member_s...
1.89
KB
-rw-r--r--
dml_replication_group_members....
1.4
KB
-rw-r--r--
dml_rwlock_instances.result
1.08
KB
-rw-r--r--
dml_session_account_connect_at...
1.52
KB
-rw-r--r--
dml_session_connect_attrs.resu...
1.4
KB
-rw-r--r--
dml_session_status.result
1.14
KB
-rw-r--r--
dml_session_variables.result
1.18
KB
-rw-r--r--
dml_setup_actors.result
3.61
KB
-rw-r--r--
dml_setup_consumers.result
1.95
KB
-rw-r--r--
dml_setup_instruments.result
3.72
KB
-rw-r--r--
dml_setup_objects.result
3.04
KB
-rw-r--r--
dml_setup_timers.result
4.16
KB
-rw-r--r--
dml_socket_instances.result
1.08
KB
-rw-r--r--
dml_socket_summary_by_event_na...
1.52
KB
-rw-r--r--
dml_socket_summary_by_instance...
1.51
KB
-rw-r--r--
dml_status_by_account.result
1.38
KB
-rw-r--r--
dml_status_by_host.result
1.32
KB
-rw-r--r--
dml_status_by_thread.result
1.34
KB
-rw-r--r--
dml_status_by_user.result
1.32
KB
-rw-r--r--
dml_table_handles.result
1.19
KB
-rw-r--r--
dml_threads.result
1.29
KB
-rw-r--r--
dml_tiws_by_index_usage.result
1.7
KB
-rw-r--r--
dml_tiws_by_table.result
1.61
KB
-rw-r--r--
dml_tlws_by_table.result
1.64
KB
-rw-r--r--
dml_users.result
1.12
KB
-rw-r--r--
dml_uvar_by_thread.result
1.65
KB
-rw-r--r--
dml_variables_by_thread.result
1.39
KB
-rw-r--r--
event_aggregate.result
245.64
KB
-rw-r--r--
event_aggregate_no_a.result
169.86
KB
-rw-r--r--
event_aggregate_no_a_no_h.resu...
149.82
KB
-rw-r--r--
event_aggregate_no_a_no_u.resu...
110.6
KB
-rw-r--r--
event_aggregate_no_a_no_u_no_h...
90.56
KB
-rw-r--r--
event_aggregate_no_h.result
225.59
KB
-rw-r--r--
event_aggregate_no_u.result
186.38
KB
-rw-r--r--
event_aggregate_no_u_no_h.resu...
166.33
KB
-rw-r--r--
file_misc.result
62
B
-rw-r--r--
func_file_io.result
6.55
KB
-rw-r--r--
func_mutex.result
5.51
KB
-rw-r--r--
global_objects.result
1.02
KB
-rw-r--r--
global_read_lock.result
1.93
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_again_...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_al...
3.18
KB
-rw-r--r--
hostcache_ipv4_addrinfo_bad_de...
2.5
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_a...
3.31
KB
-rw-r--r--
hostcache_ipv4_addrinfo_good_d...
2.57
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
3.51
KB
-rw-r--r--
hostcache_ipv4_addrinfo_noname...
2.5
KB
-rw-r--r--
hostcache_ipv4_auth_plugin.res...
5.81
KB
-rw-r--r--
hostcache_ipv4_blocked.result
12.56
KB
-rw-r--r--
hostcache_ipv4_format.result
2.46
KB
-rw-r--r--
hostcache_ipv4_max_con.result
18.74
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
5.28
KB
-rw-r--r--
hostcache_ipv4_nameinfo_again_...
4.25
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
3.14
KB
-rw-r--r--
hostcache_ipv4_nameinfo_noname...
2.46
KB
-rw-r--r--
hostcache_ipv4_passwd.result
6.34
KB
-rw-r--r--
hostcache_ipv4_ssl.result
5.16
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_again_...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_al...
3.21
KB
-rw-r--r--
hostcache_ipv6_addrinfo_bad_de...
2.51
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_a...
3.32
KB
-rw-r--r--
hostcache_ipv6_addrinfo_good_d...
2.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
3.54
KB
-rw-r--r--
hostcache_ipv6_addrinfo_noname...
2.51
KB
-rw-r--r--
hostcache_ipv6_auth_plugin.res...
5.83
KB
-rw-r--r--
hostcache_ipv6_blocked.result
12.63
KB
-rw-r--r--
hostcache_ipv6_max_con.result
18.81
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
5.32
KB
-rw-r--r--
hostcache_ipv6_nameinfo_again_...
4.27
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
3.17
KB
-rw-r--r--
hostcache_ipv6_nameinfo_noname...
2.48
KB
-rw-r--r--
hostcache_ipv6_passwd.result
6.37
KB
-rw-r--r--
hostcache_ipv6_ssl.result
5.17
KB
-rw-r--r--
hostcache_peer_addr.result
1.93
KB
-rw-r--r--
indexed_table_io.result
5.89
KB
-rw-r--r--
information_schema.result
37.19
KB
-rw-r--r--
innodb_table_io.result
5.74
KB
-rw-r--r--
io_cache.result
8.78
KB
-rw-r--r--
max_program_zero.result
11.01
KB
-rw-r--r--
mdl_func.result
22.87
KB
-rw-r--r--
memory_aggregate.result
130.6
KB
-rw-r--r--
memory_aggregate_32bit.result
130.5
KB
-rw-r--r--
memory_aggregate_no_a.result
95.47
KB
-rw-r--r--
memory_aggregate_no_a_no_h.res...
82.7
KB
-rw-r--r--
memory_aggregate_no_a_no_u.res...
60.58
KB
-rw-r--r--
memory_aggregate_no_a_no_u_no_...
47.81
KB
-rw-r--r--
memory_aggregate_no_h.result
117.82
KB
-rw-r--r--
memory_aggregate_no_u.result
95.71
KB
-rw-r--r--
memory_aggregate_no_u_no_h.res...
82.93
KB
-rw-r--r--
memory_table_io.result
5.7
KB
-rw-r--r--
merge_table_io.result
7
KB
-rw-r--r--
misc.result
9.73
KB
-rw-r--r--
misc_global_status.result
2.52
KB
-rw-r--r--
multi_table_io.result
4.56
KB
-rw-r--r--
myisam_file_io.result
3.47
KB
-rw-r--r--
myisam_table_io.result
5.65
KB
-rw-r--r--
nesting.result
11.54
KB
-rw-r--r--
no_threads.result
1.82
KB
-rw-r--r--
one_thread_per_con.result
1.35
KB
-rw-r--r--
ortho_iter.result
51.59
KB
-rw-r--r--
part_table_io.result
6.54
KB
-rw-r--r--
pfs_upgrade_event.result
7.48
KB
-rw-r--r--
pfs_upgrade_func.result
7.45
KB
-rw-r--r--
pfs_upgrade_proc.result
7.46
KB
-rw-r--r--
pfs_upgrade_table.result
7.42
KB
-rw-r--r--
pfs_upgrade_view.result
7.44
KB
-rw-r--r--
prepared_statements.result
20.55
KB
-rw-r--r--
prepared_stmts_by_stored_progr...
6.38
KB
-rw-r--r--
privilege.result
36.39
KB
-rw-r--r--
privilege_table_io.result
7.44
KB
-rw-r--r--
processlist.result
8.57
KB
-rw-r--r--
processlist_57.result
13.07
KB
-rw-r--r--
processlist_acl.result
10.36
KB
-rw-r--r--
processlist_anonymous.result
2.4
KB
-rw-r--r--
processlist_no_pfs.result
8.54
KB
-rw-r--r--
processlist_port.result
5.15
KB
-rw-r--r--
processlist_reg_user.result
3.3
KB
-rw-r--r--
query_cache.result
2.28
KB
-rw-r--r--
read_only.result
5.95
KB
-rw-r--r--
relaylog.result
12.62
KB
-rw-r--r--
rollback_table_io.result
3.74
KB
-rw-r--r--
rpl_group_member_stats.result
597
B
-rw-r--r--
rpl_group_members.result
310
B
-rw-r--r--
rpl_gtid_func.result
4.42
KB
-rw-r--r--
rpl_statements.result
13.92
KB
-rw-r--r--
rpl_threads.result
2.45
KB
-rw-r--r--
schema.result
65.31
KB
-rw-r--r--
selects.result
3.68
KB
-rw-r--r--
server_init.result
4.09
KB
-rw-r--r--
setup_actors.result
6.46
KB
-rw-r--r--
setup_actors_enabled.result
5.31
KB
-rw-r--r--
setup_actors_history.result
5.26
KB
-rw-r--r--
setup_consumers_defaults.resul...
882
B
-rw-r--r--
setup_instruments_defaults.res...
2.22
KB
-rw-r--r--
setup_object_table_lock_io.res...
3.9
KB
-rw-r--r--
setup_objects.result
6.44
KB
-rw-r--r--
short_option_1.result
755
B
-rw-r--r--
short_option_2.result
356
B
-rw-r--r--
show_aggregate.result
20.89
KB
-rw-r--r--
show_coverage.result
4.1
KB
-rw-r--r--
show_misc.result
3.49
KB
-rw-r--r--
show_plugin.result
30.45
KB
-rw-r--r--
show_plugin_56.result
29.67
KB
-rw-r--r--
show_sanity.result
31.28
KB
-rw-r--r--
socket_connect.result
5.85
KB
-rw-r--r--
socket_instances_func.result
7.03
KB
-rw-r--r--
socket_instances_func_win.resu...
4.97
KB
-rw-r--r--
socket_summary_by_event_name_f...
3.9
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.19
KB
-rw-r--r--
socket_summary_by_instance_fun...
12.26
KB
-rw-r--r--
stage_mdl_function.result
1.57
KB
-rw-r--r--
stage_mdl_global.result
1.75
KB
-rw-r--r--
stage_mdl_procedure.result
1.6
KB
-rw-r--r--
stage_mdl_table.result
2.1
KB
-rw-r--r--
start_server_1_digest.result
272
B
-rw-r--r--
start_server_disable_idle.resu...
9.02
KB
-rw-r--r--
start_server_disable_stages.re...
8.89
KB
-rw-r--r--
start_server_disable_statement...
10.62
KB
-rw-r--r--
start_server_disable_transacti...
9.89
KB
-rw-r--r--
start_server_disable_waits.res...
9.03
KB
-rw-r--r--
start_server_innodb.result
9.1
KB
-rw-r--r--
start_server_low_digest.result
951
B
-rw-r--r--
start_server_low_digest_sql_le...
772
B
-rw-r--r--
start_server_low_index.result
12.86
KB
-rw-r--r--
start_server_low_table_lock.re...
10.91
KB
-rw-r--r--
start_server_no_account.result
8.18
KB
-rw-r--r--
start_server_no_cond_class.res...
8.42
KB
-rw-r--r--
start_server_no_cond_inst.resu...
8.56
KB
-rw-r--r--
start_server_no_digests.result
3.47
KB
-rw-r--r--
start_server_no_file_class.res...
8.42
KB
-rw-r--r--
start_server_no_file_inst.resu...
8.55
KB
-rw-r--r--
start_server_no_host.result
8.17
KB
-rw-r--r--
start_server_no_index.result
8.96
KB
-rw-r--r--
start_server_no_mdl.result
8.23
KB
-rw-r--r--
start_server_no_memory_class.r...
12.18
KB
-rw-r--r--
start_server_no_mutex_class.re...
8.43
KB
-rw-r--r--
start_server_no_mutex_inst.res...
8.57
KB
-rw-r--r--
start_server_no_prepared_stmts...
9.41
KB
-rw-r--r--
start_server_no_rwlock_class.r...
8.44
KB
-rw-r--r--
start_server_no_rwlock_inst.re...
8.57
KB
-rw-r--r--
start_server_no_setup_actors.r...
8.05
KB
-rw-r--r--
start_server_no_setup_objects....
8.05
KB
-rw-r--r--
start_server_no_socket_class.r...
8.44
KB
-rw-r--r--
start_server_no_socket_inst.re...
8.57
KB
-rw-r--r--
start_server_no_stage_class.re...
8.64
KB
-rw-r--r--
start_server_no_stages_history...
8.13
KB
-rw-r--r--
start_server_no_stages_history...
8.15
KB
-rw-r--r--
start_server_no_statement_clas...
8.67
KB
-rw-r--r--
start_server_no_statements_his...
8.15
KB
-rw-r--r--
start_server_no_statements_his...
8.17
KB
-rw-r--r--
start_server_no_table_hdl.resu...
8.59
KB
-rw-r--r--
start_server_no_table_inst.res...
8.59
KB
-rw-r--r--
start_server_no_table_lock.res...
8.72
KB
-rw-r--r--
start_server_no_thread_class.r...
8.42
KB
-rw-r--r--
start_server_no_thread_inst.re...
8.45
KB
-rw-r--r--
start_server_no_transactions_h...
8.16
KB
-rw-r--r--
start_server_no_transactions_h...
8.17
KB
-rw-r--r--
start_server_no_user.result
8.17
KB
-rw-r--r--
start_server_no_waits_history....
8.13
KB
-rw-r--r--
start_server_no_waits_history_...
8.15
KB
-rw-r--r--
start_server_nothing.result
26.2
KB
-rw-r--r--
start_server_off.result
13.44
KB
-rw-r--r--
start_server_on.result
9.1
KB
-rw-r--r--
start_server_zero_digest_sql_l...
682
B
-rw-r--r--
statement_digest.result
6.59
KB
-rw-r--r--
statement_digest_charset.resul...
991
B
-rw-r--r--
statement_digest_consumers.res...
6.7
KB
-rw-r--r--
statement_digest_consumers2.re...
3.78
KB
-rw-r--r--
statement_digest_long_query.re...
2.9
KB
-rw-r--r--
statement_program_concurrency....
3.96
KB
-rw-r--r--
statement_program_lost_inst.re...
11.83
KB
-rw-r--r--
statement_program_nested.resul...
110.37
KB
-rw-r--r--
statement_program_nesting_even...
55.05
KB
-rw-r--r--
statement_program_non_nested.r...
25.42
KB
-rw-r--r--
status_reprepare.result
1.65
KB
-rw-r--r--
sxlock_func.result
2.5
KB
-rw-r--r--
table_aggregate_global_2u_2t.r...
63.78
KB
-rw-r--r--
table_aggregate_global_2u_3t.r...
68.29
KB
-rw-r--r--
table_aggregate_global_4u_2t.r...
63.75
KB
-rw-r--r--
table_aggregate_global_4u_3t.r...
68.27
KB
-rw-r--r--
table_aggregate_hist_2u_2t.res...
67.07
KB
-rw-r--r--
table_aggregate_hist_2u_3t.res...
73.23
KB
-rw-r--r--
table_aggregate_hist_4u_2t.res...
67.42
KB
-rw-r--r--
table_aggregate_hist_4u_3t.res...
73.65
KB
-rw-r--r--
table_aggregate_off.result
65.5
KB
-rw-r--r--
table_aggregate_thread_2u_2t.r...
63.72
KB
-rw-r--r--
table_aggregate_thread_2u_3t.r...
68.16
KB
-rw-r--r--
table_aggregate_thread_4u_2t.r...
64.05
KB
-rw-r--r--
table_aggregate_thread_4u_3t.r...
68.56
KB
-rw-r--r--
table_io_aggregate_global_2u_2...
63.77
KB
-rw-r--r--
table_io_aggregate_global_2u_3...
68.23
KB
-rw-r--r--
table_io_aggregate_global_4u_2...
63.75
KB
-rw-r--r--
table_io_aggregate_global_4u_3...
68.21
KB
-rw-r--r--
table_io_aggregate_hist_2u_2t....
65.25
KB
-rw-r--r--
table_io_aggregate_hist_2u_3t....
70.53
KB
-rw-r--r--
table_io_aggregate_hist_4u_2t....
65.51
KB
-rw-r--r--
table_io_aggregate_hist_4u_3t....
70.81
KB
-rw-r--r--
table_io_aggregate_thread_2u_2...
63.65
KB
-rw-r--r--
table_io_aggregate_thread_2u_3...
68.08
KB
-rw-r--r--
table_io_aggregate_thread_4u_2...
63.89
KB
-rw-r--r--
table_io_aggregate_thread_4u_3...
68.35
KB
-rw-r--r--
table_lock_aggregate_global_2u...
62.19
KB
-rw-r--r--
table_lock_aggregate_global_2u...
65.9
KB
-rw-r--r--
table_lock_aggregate_global_4u...
62.17
KB
-rw-r--r--
table_lock_aggregate_global_4u...
65.88
KB
-rw-r--r--
table_lock_aggregate_hist_2u_2...
63.91
KB
-rw-r--r--
table_lock_aggregate_hist_2u_3...
68.48
KB
-rw-r--r--
table_lock_aggregate_hist_4u_2...
63.99
KB
-rw-r--r--
table_lock_aggregate_hist_4u_3...
68.58
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
62.23
KB
-rw-r--r--
table_lock_aggregate_thread_2u...
65.92
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
62.3
KB
-rw-r--r--
table_lock_aggregate_thread_4u...
66.02
KB
-rw-r--r--
table_name.result
4.73
KB
-rw-r--r--
table_schema.result
208.92
KB
-rw-r--r--
tampered_perfschema_table1.res...
358
B
-rw-r--r--
temp_table_io.result
4.59
KB
-rw-r--r--
thread_cache.result
896
B
-rw-r--r--
thread_misc.result
62
B
-rw-r--r--
threads_history.result
15.41
KB
-rw-r--r--
threads_innodb.result
1.59
KB
-rw-r--r--
threads_mysql.result
4
KB
-rw-r--r--
threads_mysql_freebsd.result
125
B
-rw-r--r--
threads_mysql_linux.result
125
B
-rw-r--r--
threads_mysql_windows.result
125
B
-rw-r--r--
transaction.result
23.04
KB
-rw-r--r--
transaction_gtid.result
4.81
KB
-rw-r--r--
transaction_nested_events.resu...
40.69
KB
-rw-r--r--
trigger_table_io.result
7.63
KB
-rw-r--r--
unary_digest.result
2.63
KB
-rw-r--r--
user_var_func.result
2.22
KB
-rw-r--r--
view_table_io.result
5.9
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : privilege.result
set @orig_sql_mode= @@sql_mode; set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER','')); Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. show grants; Grants for root@localhost GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION grant ALL on *.* to 'pfs_user_1'@localhost with GRANT OPTION; Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. grant ALL on performance_schema.* to 'pfs_user_2'@localhost with GRANT OPTION; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE on performance_schema.* to 'pfs_user_2'@localhost; Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. grant DROP on performance_schema.* to 'pfs_user_2'@localhost; grant REFERENCES on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INDEX on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant ALTER on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE TEMPORARY TABLES on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant EXECUTE on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE VIEW on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant SHOW VIEW on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE ROUTINE on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant ALTER ROUTINE on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant EVENT on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant TRIGGER on performance_schema.* to 'pfs_user_2'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant SELECT on performance_schema.* to 'pfs_user_2'@localhost; grant INSERT on performance_schema.* to 'pfs_user_2'@localhost; grant UPDATE on performance_schema.* to 'pfs_user_2'@localhost; grant DELETE on performance_schema.* to 'pfs_user_2'@localhost; grant LOCK TABLES on performance_schema.* to 'pfs_user_2'@localhost; grant ALL on performance_schema.setup_instruments to 'pfs_user_3'@localhost with GRANT OPTION; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE on performance_schema.setup_instruments to 'pfs_user_3'@localhost; Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. grant DROP on performance_schema.setup_instruments to 'pfs_user_3'@localhost; grant REFERENCES on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INDEX on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant ALTER on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE VIEW on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant SHOW VIEW on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant TRIGGER on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INSERT on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: INSERT, GRANT command denied to user 'root'@'localhost' for table 'setup_instruments' grant DELETE on performance_schema.setup_instruments to 'pfs_user_3'@localhost; ERROR 42000: DELETE, GRANT command denied to user 'root'@'localhost' for table 'setup_instruments' grant SELECT on performance_schema.setup_instruments to 'pfs_user_3'@localhost with GRANT OPTION; grant UPDATE on performance_schema.setup_instruments to 'pfs_user_3'@localhost with GRANT OPTION; grant ALL on performance_schema.events_waits_current to 'pfs_user_3'@localhost with GRANT OPTION; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE on performance_schema.events_waits_current to 'pfs_user_3'@localhost; grant DROP on performance_schema.events_waits_current to 'pfs_user_3'@localhost; grant REFERENCES on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INDEX on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant ALTER on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE VIEW on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant SHOW VIEW on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant TRIGGER on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INSERT on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: INSERT, GRANT command denied to user 'root'@'localhost' for table 'events_waits_current' grant UPDATE on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: UPDATE, GRANT command denied to user 'root'@'localhost' for table 'events_waits_current' grant DELETE on performance_schema.events_waits_current to 'pfs_user_3'@localhost; ERROR 42000: DELETE, GRANT command denied to user 'root'@'localhost' for table 'events_waits_current' grant SELECT on performance_schema.events_waits_current to 'pfs_user_3'@localhost with GRANT OPTION; grant ALL on performance_schema.file_instances to 'pfs_user_3'@localhost with GRANT OPTION; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE on performance_schema.file_instances to 'pfs_user_3'@localhost; grant DROP on performance_schema.file_instances to 'pfs_user_3'@localhost; grant REFERENCES on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INDEX on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant ALTER on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant CREATE VIEW on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant SHOW VIEW on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant TRIGGER on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' grant INSERT on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: INSERT, GRANT command denied to user 'root'@'localhost' for table 'file_instances' grant UPDATE on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: UPDATE, GRANT command denied to user 'root'@'localhost' for table 'file_instances' grant DELETE on performance_schema.file_instances to 'pfs_user_3'@localhost; ERROR 42000: DELETE, GRANT command denied to user 'root'@'localhost' for table 'file_instances' grant SELECT on performance_schema.file_instances to 'pfs_user_3'@localhost with GRANT OPTION; grant LOCK TABLES on performance_schema.* to 'pfs_user_3'@localhost with GRANT OPTION; flush privileges; drop table if exists test.t1; rename table performance_schema.setup_instruments to test.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to test.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to test.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to performance_schema.t1; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.events_waits_current; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.setup_instruments; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create procedure performance_schema.my_proc() begin end; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create function performance_schema.my_func() returns int return 0; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create event performance_schema.my_event on schedule every 15 minute do begin end; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_setup_instruments before insert on performance_schema.setup_instruments for each row begin end; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_events_waits_current before insert on performance_schema.events_waits_current for each row begin end; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_file_instances before insert on performance_schema.file_instances for each row begin end; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' create table test.t1(a int) engine=PERFORMANCE_SCHEMA; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.setup_instruments; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.events_waits_current; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.file_instances; ERROR HY000: Invalid performance_schema usage. insert into performance_schema.setup_instruments set name="foo"; ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_instruments' insert into performance_schema.events_waits_current set name="foo"; ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'events_waits_current' insert into performance_schema.file_instances set name="foo"; ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'file_instances' delete from performance_schema.setup_instruments; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments' delete from performance_schema.events_waits_current; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'events_waits_current' delete from performance_schema.file_instances; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'file_instances' lock table performance_schema.setup_instruments read; unlock tables; lock table performance_schema.setup_instruments write; unlock tables; lock table performance_schema.events_waits_current read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.events_waits_current write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.file_instances read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'file_instances' unlock tables; lock table performance_schema.file_instances write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'file_instances' unlock tables; # # WL#4818, NFS2: Can use grants to give normal user access # to view data from _current and _history tables # # Should work as pfs_user_1 and pfs_user_2, but not as pfs_user_3. # (Except for events_waits_current, which is granted.) SELECT "can select" FROM performance_schema.events_waits_history LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_history_long LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_current LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_summary_by_instance LIMIT 1; can select can select SELECT "can select" FROM performance_schema.file_summary_by_instance LIMIT 1; can select can select drop table if exists test.t1; rename table performance_schema.setup_instruments to test.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to test.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to test.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.events_waits_current; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.setup_instruments; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create procedure performance_schema.my_proc() begin end; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create function performance_schema.my_func() returns int return 0; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create event performance_schema.my_event on schedule every 15 minute do begin end; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_setup_instruments before insert on performance_schema.setup_instruments for each row begin end; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_events_waits_current before insert on performance_schema.events_waits_current for each row begin end; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_file_instances before insert on performance_schema.file_instances for each row begin end; ERROR 42000: Access denied for user 'pfs_user_1'@'localhost' to database 'performance_schema' create table test.t1(a int) engine=PERFORMANCE_SCHEMA; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.setup_instruments; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.events_waits_current; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.file_instances; ERROR HY000: Invalid performance_schema usage. insert into performance_schema.setup_instruments set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_1'@'localhost' for table 'setup_instruments' insert into performance_schema.events_waits_current set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_1'@'localhost' for table 'events_waits_current' insert into performance_schema.file_instances set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_1'@'localhost' for table 'file_instances' delete from performance_schema.setup_instruments; ERROR 42000: DELETE command denied to user 'pfs_user_1'@'localhost' for table 'setup_instruments' delete from performance_schema.events_waits_current; ERROR 42000: DELETE command denied to user 'pfs_user_1'@'localhost' for table 'events_waits_current' delete from performance_schema.file_instances; ERROR 42000: DELETE command denied to user 'pfs_user_1'@'localhost' for table 'file_instances' lock table performance_schema.setup_instruments read; unlock tables; lock table performance_schema.setup_instruments write; unlock tables; lock table performance_schema.events_waits_current read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_1'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.events_waits_current write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_1'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.file_instances read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_1'@'localhost' for table 'file_instances' unlock tables; lock table performance_schema.file_instances write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_1'@'localhost' for table 'file_instances' unlock tables; # # WL#4818, NFS2: Can use grants to give normal user access # to view data from _current and _history tables # # Should work as pfs_user_1 and pfs_user_2, but not as pfs_user_3. # (Except for events_waits_current, which is granted.) SELECT "can select" FROM performance_schema.events_waits_history LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_history_long LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_current LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_summary_by_instance LIMIT 1; can select can select SELECT "can select" FROM performance_schema.file_summary_by_instance LIMIT 1; can select can select drop table if exists test.t1; rename table performance_schema.setup_instruments to test.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to test.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to test.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.events_waits_current; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.setup_instruments; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create procedure performance_schema.my_proc() begin end; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create function performance_schema.my_func() returns int return 0; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create event performance_schema.my_event on schedule every 15 minute do begin end; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_setup_instruments before insert on performance_schema.setup_instruments for each row begin end; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_events_waits_current before insert on performance_schema.events_waits_current for each row begin end; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_file_instances before insert on performance_schema.file_instances for each row begin end; ERROR 42000: Access denied for user 'pfs_user_2'@'localhost' to database 'performance_schema' create table test.t1(a int) engine=PERFORMANCE_SCHEMA; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.setup_instruments; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.events_waits_current; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.file_instances; ERROR HY000: Invalid performance_schema usage. insert into performance_schema.setup_instruments set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_2'@'localhost' for table 'setup_instruments' insert into performance_schema.events_waits_current set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_2'@'localhost' for table 'events_waits_current' insert into performance_schema.file_instances set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_2'@'localhost' for table 'file_instances' delete from performance_schema.setup_instruments; ERROR 42000: DELETE command denied to user 'pfs_user_2'@'localhost' for table 'setup_instruments' delete from performance_schema.events_waits_current; ERROR 42000: DELETE command denied to user 'pfs_user_2'@'localhost' for table 'events_waits_current' delete from performance_schema.file_instances; ERROR 42000: DELETE command denied to user 'pfs_user_2'@'localhost' for table 'file_instances' lock table performance_schema.setup_instruments read; unlock tables; lock table performance_schema.setup_instruments write; unlock tables; lock table performance_schema.events_waits_current read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_2'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.events_waits_current write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_2'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.file_instances read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_2'@'localhost' for table 'file_instances' unlock tables; lock table performance_schema.file_instances write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_2'@'localhost' for table 'file_instances' unlock tables; # # WL#4818, NFS2: Can use grants to give normal user access # to view data from _current and _history tables # # Should work as pfs_user_1 and pfs_user_2, but not as pfs_user_3. # (Except for events_waits_current, which is granted.) SELECT "can select" FROM performance_schema.events_waits_history LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_history_long LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_current LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_summary_by_instance LIMIT 1; can select can select SELECT "can select" FROM performance_schema.file_summary_by_instance LIMIT 1; can select can select drop table if exists test.t1; rename table performance_schema.setup_instruments to test.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to test.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to test.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.file_instances to performance_schema.t1; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.setup_instruments to performance_schema.events_waits_current; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' rename table performance_schema.events_waits_current to performance_schema.setup_instruments; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create procedure performance_schema.my_proc() begin end; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create function performance_schema.my_func() returns int return 0; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create event performance_schema.my_event on schedule every 15 minute do begin end; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_setup_instruments before insert on performance_schema.setup_instruments for each row begin end; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_events_waits_current before insert on performance_schema.events_waits_current for each row begin end; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create trigger performance_schema.bi_file_instances before insert on performance_schema.file_instances for each row begin end; ERROR 42000: Access denied for user 'pfs_user_3'@'localhost' to database 'performance_schema' create table test.t1(a int) engine=PERFORMANCE_SCHEMA; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.setup_instruments; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.events_waits_current; ERROR HY000: Invalid performance_schema usage. create table test.t1 like performance_schema.file_instances; ERROR HY000: Invalid performance_schema usage. insert into performance_schema.setup_instruments set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_3'@'localhost' for table 'setup_instruments' insert into performance_schema.events_waits_current set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_current' insert into performance_schema.file_instances set name="foo"; ERROR 42000: INSERT command denied to user 'pfs_user_3'@'localhost' for table 'file_instances' delete from performance_schema.setup_instruments; ERROR 42000: DELETE command denied to user 'pfs_user_3'@'localhost' for table 'setup_instruments' delete from performance_schema.events_waits_current; ERROR 42000: DELETE command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_current' delete from performance_schema.file_instances; ERROR 42000: DELETE command denied to user 'pfs_user_3'@'localhost' for table 'file_instances' lock table performance_schema.setup_instruments read; unlock tables; lock table performance_schema.setup_instruments write; unlock tables; lock table performance_schema.events_waits_current read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.events_waits_current write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_current' unlock tables; lock table performance_schema.file_instances read; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_3'@'localhost' for table 'file_instances' unlock tables; lock table performance_schema.file_instances write; ERROR 42000: SELECT, LOCK TABLES command denied to user 'pfs_user_3'@'localhost' for table 'file_instances' unlock tables; # # WL#4818, NFS2: Can use grants to give normal user access # to view data from _current and _history tables # # Should work as pfs_user_1 and pfs_user_2, but not as pfs_user_3. # (Except for events_waits_current, which is granted.) SELECT "can select" FROM performance_schema.events_waits_history LIMIT 1; ERROR 42000: SELECT command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_history' SELECT "can select" FROM performance_schema.events_waits_history_long LIMIT 1; ERROR 42000: SELECT command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_history_long' SELECT "can select" FROM performance_schema.events_waits_current LIMIT 1; can select can select SELECT "can select" FROM performance_schema.events_waits_summary_by_instance LIMIT 1; ERROR 42000: SELECT command denied to user 'pfs_user_3'@'localhost' for table 'events_waits_summary_by_instance' SELECT "can select" FROM performance_schema.file_summary_by_instance LIMIT 1; ERROR 42000: SELECT command denied to user 'pfs_user_3'@'localhost' for table 'file_summary_by_instance' revoke all privileges, grant option from 'pfs_user_1'@localhost; revoke all privileges, grant option from 'pfs_user_2'@localhost; revoke all privileges, grant option from 'pfs_user_3'@localhost; drop user 'pfs_user_1'@localhost; drop user 'pfs_user_2'@localhost; drop user 'pfs_user_3'@localhost; flush privileges; # Test cases from WL#4818 # Setup user CREATE user pfs_user_4; # # WL#4818, NFS4: Normal user does not have access to view data # without grants # # Select as pfs_user_4 should fail without grant SELECT event_id FROM performance_schema.events_waits_history; ERROR 42000: SELECT command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_history' SELECT event_id FROM performance_schema.events_waits_history_long; ERROR 42000: SELECT command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_history_long' SELECT event_id FROM performance_schema.events_waits_current; ERROR 42000: SELECT command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_current' SELECT event_name FROM performance_schema.events_waits_summary_by_instance; ERROR 42000: SELECT command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_summary_by_instance' SELECT event_name FROM performance_schema.file_summary_by_instance; ERROR 42000: SELECT command denied to user 'pfs_user_4'@'localhost' for table 'file_summary_by_instance' # # WL#4818, NFS3: Normal user does not have access to change what is # instrumented without grants # # User pfs_user_4 should not be allowed to tweak instrumentation without # explicit grant UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES'; ERROR 42000: UPDATE command denied to user 'pfs_user_4'@'localhost' for table 'setup_instruments' UPDATE performance_schema.setup_instruments SET enabled = 'YES' WHERE name LIKE 'wait/synch/mutex/%' OR name LIKE 'wait/synch/rwlock/%'; ERROR 42000: UPDATE command denied to user 'pfs_user_4'@'localhost' for table 'setup_instruments' UPDATE performance_schema.setup_consumers SET enabled = 'YES'; ERROR 42000: UPDATE command denied to user 'pfs_user_4'@'localhost' for table 'setup_consumers' UPDATE performance_schema.setup_timers SET timer_name = 'TICK'; ERROR 42000: UPDATE command denied to user 'pfs_user_4'@'localhost' for table 'setup_timers' TRUNCATE TABLE performance_schema.events_waits_history_long; ERROR 42000: DROP command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_history_long' TRUNCATE TABLE performance_schema.events_waits_history; ERROR 42000: DROP command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_history' TRUNCATE TABLE performance_schema.events_waits_current; ERROR 42000: DROP command denied to user 'pfs_user_4'@'localhost' for table 'events_waits_current' # # WL#4814, NFS1: Can use grants to give normal user access # to turn on and off instrumentation # # Grant access to change tables with the root account GRANT UPDATE ON performance_schema.setup_consumers TO pfs_user_4; GRANT UPDATE ON performance_schema.setup_timers TO pfs_user_4; GRANT UPDATE, SELECT ON performance_schema.setup_instruments TO pfs_user_4; GRANT DROP ON performance_schema.events_waits_current TO pfs_user_4; GRANT DROP ON performance_schema.events_waits_history TO pfs_user_4; GRANT DROP ON performance_schema.events_waits_history_long TO pfs_user_4; # User pfs_user_4 should now be allowed to tweak instrumentation UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES'; UPDATE performance_schema.setup_instruments SET enabled = 'YES' WHERE name LIKE 'wait/synch/mutex/%' OR name LIKE 'wait/synch/rwlock/%'; UPDATE performance_schema.setup_consumers SET enabled = 'YES'; UPDATE performance_schema.setup_timers SET timer_name = 'TICK'; Warnings: Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. TRUNCATE TABLE performance_schema.events_waits_history_long; TRUNCATE TABLE performance_schema.events_waits_history; TRUNCATE TABLE performance_schema.events_waits_current; # Clean up REVOKE ALL PRIVILEGES, GRANT OPTION FROM pfs_user_4; DROP USER pfs_user_4; flush privileges; UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES'; UPDATE performance_schema.setup_consumers SET enabled = 'YES'; UPDATE performance_schema.setup_timers SET timer_name = 'MICROSECOND' where name="idle"; Warnings: Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. UPDATE performance_schema.setup_timers SET timer_name = 'CYCLE' where name="wait"; Warnings: Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. UPDATE performance_schema.setup_timers SET timer_name = 'NANOSECOND' where name="stage"; Warnings: Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. UPDATE performance_schema.setup_timers SET timer_name = 'NANOSECOND' where name="statement"; Warnings: Warning 1681 'performance_schema.setup_timers' is deprecated and will be removed in a future release. set sql_mode= @orig_sql_mode; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. # # WL#2284: Increase the length of a user name # CREATE USER 'user_name_len_22_01234'@localhost; GRANT ALL ON performance_schema.* TO 'user_name_len_22_01234'@localhost with GRANT OPTION; ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user_name_len_22_01234'@localhost; DROP USER 'user_name_len_22_01234'@localhost;
Close