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.216.69.239
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 /
x /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
admin_bogus.result
703
B
-rw-r--r--
admin_bogus_mysqlx.result
523
B
-rw-r--r--
admin_create_collection.result
3.53
KB
-rw-r--r--
admin_create_collection_mysqlx...
1.97
KB
-rw-r--r--
admin_create_index_datetime.re...
4.96
KB
-rw-r--r--
admin_create_index_datetime_my...
1.27
KB
-rw-r--r--
admin_create_index_string.resu...
12.64
KB
-rw-r--r--
admin_create_index_string_mysq...
2.28
KB
-rw-r--r--
admin_ensure_collection.result
3.49
KB
-rw-r--r--
admin_ensure_collection_mysqlx...
3.46
KB
-rw-r--r--
admin_kill.result
3.07
KB
-rw-r--r--
admin_kill_client_mysqlx.resul...
1.61
KB
-rw-r--r--
admin_list_objects.result
3.07
KB
-rw-r--r--
admin_list_objects_case_insens...
1.38
KB
-rw-r--r--
admin_list_objects_case_insens...
1.42
KB
-rw-r--r--
admin_list_objects_case_sensit...
1.25
KB
-rw-r--r--
admin_list_objects_case_sensit...
1.38
KB
-rw-r--r--
admin_list_objects_mysqlx.resu...
2
KB
-rw-r--r--
admin_ping.result
533
B
-rw-r--r--
admin_ping_mysqlx.result
1.21
KB
-rw-r--r--
admin_xkill.result
50.58
KB
-rw-r--r--
binary_log.result
1.07
KB
-rw-r--r--
bug_23028052.result
2.75
KB
-rw-r--r--
capabilities.result
21.04
KB
-rw-r--r--
client_close.result
32.63
KB
-rw-r--r--
client_close_abort.result
1.95
KB
-rw-r--r--
client_session.result
1.26
KB
-rw-r--r--
connection.result
39.97
KB
-rw-r--r--
connection_default_schema.resu...
2.2
KB
-rw-r--r--
connection_expire.result
6.42
KB
-rw-r--r--
connection_expired_certs.resul...
433
B
-rw-r--r--
connection_ipv6.result
4.22
KB
-rw-r--r--
connection_nonssl.result
3.69
KB
-rw-r--r--
connection_openssl.result
18.51
KB
-rw-r--r--
connection_require_secure_tran...
1.99
KB
-rw-r--r--
connection_reset_by_peer.resul...
818
B
-rw-r--r--
connection_skip_grant_table.re...
2.25
KB
-rw-r--r--
connection_skip_networking.res...
1.36
KB
-rw-r--r--
connection_skip_networking_win...
679
B
-rw-r--r--
connection_timeout.result
2.04
KB
-rw-r--r--
connection_tls_version.result
4.75
KB
-rw-r--r--
connection_unixsocket.result
7.49
KB
-rw-r--r--
connection_unixsocket_invalid....
2.57
KB
-rw-r--r--
connection_unixsocket_lock.res...
1.24
KB
-rw-r--r--
connection_unixsocket_rpl.resu...
9.81
KB
-rw-r--r--
connection_user_authentication...
3.91
KB
-rw-r--r--
connection_user_authentication...
3.22
KB
-rw-r--r--
connection_without_session.res...
373
B
-rw-r--r--
create_alter_sql.result
9.96
KB
-rw-r--r--
create_drop_collection_crud.re...
12.87
KB
-rw-r--r--
create_index_crud.result
62.48
KB
-rw-r--r--
crud_asterisk.result
1.88
KB
-rw-r--r--
crud_create_view.result
6.29
KB
-rw-r--r--
crud_debug.result
675
B
-rw-r--r--
crud_delete_args.result
1.12
KB
-rw-r--r--
crud_doc_criteria_args.result
26.62
KB
-rw-r--r--
crud_doc_expr_array.result
23.27
KB
-rw-r--r--
crud_doc_expr_object.result
8.33
KB
-rw-r--r--
crud_drop_view.result
1.32
KB
-rw-r--r--
crud_find_args.result
1.46
KB
-rw-r--r--
crud_find_doc_criteria.result
2.51
KB
-rw-r--r--
crud_find_doc_groupby.result
1.72
KB
-rw-r--r--
crud_find_groupby.result
1.43
KB
-rw-r--r--
crud_insert_args.result
779
B
-rw-r--r--
crud_insert_cast.result
11.9
KB
-rw-r--r--
crud_insert_default.result
3.51
KB
-rw-r--r--
crud_insert_expr.result
3.52
KB
-rw-r--r--
crud_insert_nodoc.result
610
B
-rw-r--r--
crud_modify_view.result
4.66
KB
-rw-r--r--
crud_myisam_memory.result
11.19
KB
-rw-r--r--
crud_octets_content_type.resul...
3.37
KB
-rw-r--r--
crud_order_by.result
2.19
KB
-rw-r--r--
crud_pipe.result
2.56
KB
-rw-r--r--
crud_resultset_metadata.result
990
B
-rw-r--r--
crud_rpl.result
9.24
KB
-rw-r--r--
crud_sundries.result
29.98
KB
-rw-r--r--
crud_table_criteria_args.resul...
20.3
KB
-rw-r--r--
crud_table_expr_array.result
23.29
KB
-rw-r--r--
crud_table_expr_object.result
7.4
KB
-rw-r--r--
crud_update_args.result
1.57
KB
-rw-r--r--
crud_update_table_json.result
9.3
KB
-rw-r--r--
crud_view_sundries.result
3.63
KB
-rw-r--r--
delete_crud_1.result
7.12
KB
-rw-r--r--
delete_crud_o.result
27.17
KB
-rw-r--r--
delete_del_all.result
1.68
KB
-rw-r--r--
delete_del_bad_collection.resu...
2.3
KB
-rw-r--r--
delete_del_bad_expr.result
2.07
KB
-rw-r--r--
delete_del_missing_arg.result
2.1
KB
-rw-r--r--
delete_del_multi_by_expr.resul...
2.06
KB
-rw-r--r--
delete_del_multi_by_id.result
1.89
KB
-rw-r--r--
delete_del_none_by_expr.result
2.07
KB
-rw-r--r--
delete_del_none_table.result
2.61
KB
-rw-r--r--
delete_del_one_by_expr.result
2.57
KB
-rw-r--r--
delete_del_table.result
2
KB
-rw-r--r--
delete_del_table_doc.result
3.23
KB
-rw-r--r--
delete_del_table_order.result
2.99
KB
-rw-r--r--
delete_sql_o.result
10.03
KB
-rw-r--r--
drop_index_crud.result
121.28
KB
-rw-r--r--
expect_noerror.result
6.95
KB
-rw-r--r--
fieldtypes_all.result
9.62
KB
-rw-r--r--
find_crud_conditionalclauses_o...
28.66
KB
-rw-r--r--
find_crud_groupby_o.result
16.74
KB
-rw-r--r--
find_doc_proj.result
10.47
KB
-rw-r--r--
find_doc_simple.result
6.66
KB
-rw-r--r--
find_docpath_expr.result
6.58
KB
-rw-r--r--
find_funtion_call.result
35.96
KB
-rw-r--r--
find_table_find.result
7.24
KB
-rw-r--r--
find_table_find_as_doc.result
5.46
KB
-rw-r--r--
find_table_find_rows_proj.resu...
6.6
KB
-rw-r--r--
forbidden_sql_cmd.result
1.9
KB
-rw-r--r--
input_queue.result
5.98
KB
-rw-r--r--
insert_crud_1.result
15.99
KB
-rw-r--r--
insert_crud_o.result
26.83
KB
-rw-r--r--
insert_doc_bad_proj.result
1.93
KB
-rw-r--r--
insert_doc_id.result
1.79
KB
-rw-r--r--
insert_doc_id_dup.result
2.82
KB
-rw-r--r--
insert_doc_noid.result
1.88
KB
-rw-r--r--
insert_sql_o.result
5.78
KB
-rw-r--r--
insert_table.result
8.56
KB
-rw-r--r--
insert_table_bad_column.result
2.41
KB
-rw-r--r--
insert_table_bad_column_type.r...
5.51
KB
-rw-r--r--
insert_table_bad_numcolumns.re...
5.98
KB
-rw-r--r--
insert_table_escape_identifier...
1.2
KB
-rw-r--r--
insert_table_missing_notnull_c...
1.28
KB
-rw-r--r--
insert_table_string_quoting.re...
1.33
KB
-rw-r--r--
installxplugin.result
12.81
KB
-rw-r--r--
killconnection.result
2.97
KB
-rw-r--r--
message_empty_payload.result
767
B
-rw-r--r--
message_protobuf_nested.result
839
B
-rw-r--r--
multiple_resultsets_and_out_pa...
7.4
KB
-rw-r--r--
mysql_session_user.result
3.22
KB
-rw-r--r--
mysqlx_server_var.result
8.7
KB
-rw-r--r--
mysqlxtest_help.result
8.06
KB
-rw-r--r--
notice_warning.result
6.78
KB
-rw-r--r--
notice_warning_mysqlx.result
1.12
KB
-rw-r--r--
notices_disable.result
71.66
KB
-rw-r--r--
notices_disable_mysqlx.result
11.56
KB
-rw-r--r--
notices_enable.result
216.67
KB
-rw-r--r--
notices_enable_mysqlx.result
63.76
KB
-rw-r--r--
performance_schema.result
16.42
KB
-rw-r--r--
performance_schema_memory.resu...
3.71
KB
-rw-r--r--
performance_schema_sockets.res...
16.04
KB
-rw-r--r--
performance_schema_threads.res...
3.92
KB
-rw-r--r--
performance_schema_unixsockets...
16.12
KB
-rw-r--r--
plugin_license.result
420
B
-rw-r--r--
regression.result
8.69
KB
-rw-r--r--
result_types.result
3.28
KB
-rw-r--r--
session_reset.result
1.8
KB
-rw-r--r--
status_bytes_received.result
326
B
-rw-r--r--
status_variable_errors_unknown...
1.93
KB
-rw-r--r--
status_variable_notices.result
765
B
-rw-r--r--
status_variables.result
6.32
KB
-rw-r--r--
status_variables_incrementing....
3.42
KB
-rw-r--r--
stmtexecute_query_no_result.re...
1.06
KB
-rw-r--r--
stmtexecute_query_result.resul...
1.99
KB
-rw-r--r--
stmtexecute_status_vars.result
20.87
KB
-rw-r--r--
stmtexecute_with_args.result
7.85
KB
-rw-r--r--
system_variable_bind_address.r...
1.74
KB
-rw-r--r--
system_variable_max_allowed_pa...
1.14
KB
-rw-r--r--
system_variable_min_worker_thr...
4.9
KB
-rw-r--r--
system_variable_port_open_time...
3.34
KB
-rw-r--r--
system_variables.result
1.46
KB
-rw-r--r--
update_crud_arrayappend_o.resu...
28.66
KB
-rw-r--r--
update_crud_arrayinsert_o.resu...
38.06
KB
-rw-r--r--
update_crud_itemmerge_o.result
31.89
KB
-rw-r--r--
update_crud_o.result
37.48
KB
-rw-r--r--
update_crud_remove_o.result
16.89
KB
-rw-r--r--
update_crud_replace_o.result
25.88
KB
-rw-r--r--
update_doc.result
30.18
KB
-rw-r--r--
update_sql_o.result
5.42
KB
-rw-r--r--
update_table.result
4.13
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : crud_view_sundries.result
install plugin mysqlx soname "mysqlx.so"; call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); CREATE SCHEMA xtest; CREATE TABLE xtest.tab_a (first INT, second JSON); INSERT INTO xtest.tab_a (first, second) VALUES (1, '{"_id":"one", "name":"Adam"}' ); CREATE USER xuser; Create view on document table created using "Mysqlx.Sql.StmtExecute" -------------------------------------------------------------------- command ok 0 rows affected 0 rows affected name type coll_a COLLECTION tab_a TABLE view_a VIEW view_b COLLECTION_VIEW command ok View Create View character_set_client collation_connection view_a CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `xtest`.`view_a` AS select `xtest`.`coll_a`.`doc` AS `doc`,`xtest`.`coll_a`.`_id` AS `_id` from `xtest`.`coll_a` utf8mb4 utf8mb4_general_ci 0 rows affected View Create View character_set_client collation_connection view_b CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `xtest`.`view_b` AS select `xtest`.`coll_a`.`doc` AS `doc` from `xtest`.`coll_a` utf8mb4 utf8mb4_general_ci 0 rows affected Create view based on another view --------------------------------- Mysqlx.Ok { } View Create View character_set_client collation_connection view_c CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `xtest`.`view_c` AS select `view_a`.`doc` AS `doc` from `xtest`.`view_a` utf8mb4 utf8mb4_general_ci 0 rows affected Error when try modify view which is not updatable. -------------------------------------------------- Got expected error: Mysqlx.Error { severity: ERROR code: 1368 msg: "CHECK OPTION on non-updatable view \'xtest.view_c\'" sql_state: "HY000" } Run select query on view. ------------------------- Mysqlx.Ok { } doc {"_id": "one", "name": "Adam"} 0 rows affected doc {"_id": "one", "name": "Adam"} command ok Error on find if base table alteration invalidates the view. ------------------------------------------------------------ 0 rows affected Records: 0 Duplicates: 0 Warnings: 0 Got expected error: Mysqlx.Error { severity: ERROR code: 1356 msg: "View \'xtest.view_d\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" sql_state: "HY000" } Error on create view for non privilege user ------------------------------------------- connecting... active session is now 'xuser_session' Got expected error: Mysqlx.Error { severity: ERROR code: 1142 msg: "CREATE VIEW command denied to user \'xuser\'@\'localhost\' for table \'view_e\'" sql_state: "42000" } closing session xuser_session Mysqlx.Ok { msg: "bye!" } switched to session default Check view details added in information_schema.views ---------------------------------------------------- name type coll_a COLLECTION tab_a TABLE view_a VIEW view_b COLLECTION_VIEW view_c COLLECTION_VIEW view_d VIEW command ok table_name check_option is_updatable definer security_type view_definition view_a NONE YES root@localhost DEFINER select `xtest`.`coll_a`.`doc` AS `doc`,`xtest`.`coll_a`.`_id` AS `_id` from `xtest`.`coll_a` view_b NONE YES root@localhost DEFINER select `xtest`.`coll_a`.`doc` AS `doc` from `xtest`.`coll_a` view_c NONE NO root@localhost DEFINER select `view_a`.`doc` AS `doc` from `xtest`.`view_a` view_d NONE root@localhost DEFINER select `xtest`.`tab_a`.`second` AS `doc` from `xtest`.`tab_a` 0 rows affected Mysqlx.Ok { msg: "bye!" } ok DROP SCHEMA IF EXISTS xtest; DROP USER xuser; UNINSTALL PLUGIN mysqlx;
Close