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 | : 13.59.196.41
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 /
funcs_1 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
charset_collation.test
3.99
KB
-rw-r--r--
disabled.def
372
B
-rw-r--r--
innodb_bitdata.test
434
B
-rw-r--r--
innodb_cursors.test
435
B
-rw-r--r--
innodb_func_view.test
499
B
-rw-r--r--
innodb_storedproc_02.test
218
B
-rw-r--r--
innodb_storedproc_03.test
218
B
-rw-r--r--
innodb_storedproc_06.test
218
B
-rw-r--r--
innodb_storedproc_07.test
218
B
-rw-r--r--
innodb_storedproc_08.test
218
B
-rw-r--r--
innodb_storedproc_10.test
218
B
-rw-r--r--
innodb_trig_0102.test
243
B
-rw-r--r--
innodb_trig_03.test
239
B
-rw-r--r--
innodb_trig_03e.test
849
B
-rw-r--r--
innodb_trig_0407.test
243
B
-rw-r--r--
innodb_trig_08.test
239
B
-rw-r--r--
innodb_trig_09.test
239
B
-rw-r--r--
innodb_trig_1011ext-master.opt
33
B
-rw-r--r--
innodb_trig_1011ext.test
249
B
-rw-r--r--
innodb_trig_frkey.test
239
B
-rw-r--r--
innodb_views.test
586
B
-rw-r--r--
is_basics_mixed.test
19.12
KB
-rw-r--r--
is_character_sets.test
4.47
KB
-rw-r--r--
is_cml_innodb.test
1.06
KB
-rw-r--r--
is_cml_memory.test
979
B
-rw-r--r--
is_cml_myisam.test
1.06
KB
-rw-r--r--
is_coll_char_set_appl.test
4.75
KB
-rw-r--r--
is_collations.test
4.9
KB
-rw-r--r--
is_column_privileges.test
13.15
KB
-rw-r--r--
is_column_privileges_is_mysql_...
2.26
KB
-rw-r--r--
is_columns.test
17.04
KB
-rw-r--r--
is_columns_innodb.test
828
B
-rw-r--r--
is_columns_is.test
894
B
-rw-r--r--
is_columns_is_embedded.test
808
B
-rw-r--r--
is_columns_memory.test
881
B
-rw-r--r--
is_columns_myisam.test
960
B
-rw-r--r--
is_columns_myisam_embedded.tes...
883
B
-rw-r--r--
is_columns_mysql.test
624
B
-rw-r--r--
is_columns_mysql_embedded.test
538
B
-rw-r--r--
is_engines.test
4.64
KB
-rw-r--r--
is_engines_archive.test
425
B
-rw-r--r--
is_engines_blackhole.test
433
B
-rw-r--r--
is_engines_csv.test
411
B
-rw-r--r--
is_engines_federated.test
452
B
-rw-r--r--
is_engines_innodb.test
707
B
-rw-r--r--
is_engines_memory.test
423
B
-rw-r--r--
is_engines_merge.test
425
B
-rw-r--r--
is_engines_myisam.test
420
B
-rw-r--r--
is_events.test
7.59
KB
-rw-r--r--
is_key_column_usage.test
829
B
-rw-r--r--
is_key_column_usage_embedded.t...
878
B
-rw-r--r--
is_routines.test
790
B
-rw-r--r--
is_routines_embedded.test
839
B
-rw-r--r--
is_schema_privileges.test
13.53
KB
-rw-r--r--
is_schema_privileges_is_mysql_...
2.27
KB
-rw-r--r--
is_schemata.test
721
B
-rw-r--r--
is_schemata_embedded.test
770
B
-rw-r--r--
is_schemata_is_mysql_test.test
2.22
KB
-rw-r--r--
is_statistics.test
14.15
KB
-rw-r--r--
is_statistics_is.test
507
B
-rw-r--r--
is_statistics_mysql.test
721
B
-rw-r--r--
is_statistics_mysql_embedded.t...
644
B
-rw-r--r--
is_table_constraints.test
12.68
KB
-rw-r--r--
is_table_constraints_is.test
504
B
-rw-r--r--
is_table_constraints_mysql.tes...
719
B
-rw-r--r--
is_table_constraints_mysql_emb...
647
B
-rw-r--r--
is_table_privileges.test
14.16
KB
-rw-r--r--
is_tables.test
968
B
-rw-r--r--
is_tables_embedded.test
1020
B
-rw-r--r--
is_tables_innodb.test
776
B
-rw-r--r--
is_tables_is.test
709
B
-rw-r--r--
is_tables_memory.test
829
B
-rw-r--r--
is_tables_myisam.test
908
B
-rw-r--r--
is_tables_myisam_embedded.test
833
B
-rw-r--r--
is_tables_mysql.test
668
B
-rw-r--r--
is_tables_mysql_embedded.test
591
B
-rw-r--r--
is_triggers.test
822
B
-rw-r--r--
is_triggers_embedded.test
871
B
-rw-r--r--
is_user_privileges.test
15.36
KB
-rw-r--r--
is_views.test
774
B
-rw-r--r--
is_views_embedded.test
857
B
-rw-r--r--
memory_bitdata.test
446
B
-rw-r--r--
memory_cursors.test
451
B
-rw-r--r--
memory_func_view.test
552
B
-rw-r--r--
memory_storedproc_02.test
215
B
-rw-r--r--
memory_storedproc_03.test
215
B
-rw-r--r--
memory_storedproc_06.test
215
B
-rw-r--r--
memory_storedproc_07.test
215
B
-rw-r--r--
memory_storedproc_08.test
215
B
-rw-r--r--
memory_storedproc_10.test
215
B
-rw-r--r--
memory_trig_0102.test
308
B
-rw-r--r--
memory_trig_03.test
255
B
-rw-r--r--
memory_trig_03e.test
804
B
-rw-r--r--
memory_trig_0407.test
308
B
-rw-r--r--
memory_trig_08.test
255
B
-rw-r--r--
memory_trig_09.test
255
B
-rw-r--r--
memory_trig_1011ext-master.opt
33
B
-rw-r--r--
memory_trig_1011ext.test
314
B
-rw-r--r--
memory_views.test
605
B
-rw-r--r--
myisam_bitdata.test
449
B
-rw-r--r--
myisam_cursors.test
449
B
-rw-r--r--
myisam_func_view.test
550
B
-rw-r--r--
myisam_storedproc_02.test
213
B
-rw-r--r--
myisam_storedproc_03.test
213
B
-rw-r--r--
myisam_storedproc_06.test
213
B
-rw-r--r--
myisam_storedproc_07.test
213
B
-rw-r--r--
myisam_storedproc_08.test
213
B
-rw-r--r--
myisam_storedproc_10.test
213
B
-rw-r--r--
myisam_trig_0102.test
257
B
-rw-r--r--
myisam_trig_03.test
253
B
-rw-r--r--
myisam_trig_03e.test
802
B
-rw-r--r--
myisam_trig_0407.test
257
B
-rw-r--r--
myisam_trig_08.test
253
B
-rw-r--r--
myisam_trig_09.test
253
B
-rw-r--r--
myisam_trig_1011ext-master.opt
33
B
-rw-r--r--
myisam_trig_1011ext.test
263
B
-rw-r--r--
myisam_views-big.test
1.01
KB
-rw-r--r--
processlist_priv_no_prot.test
1.74
KB
-rw-r--r--
processlist_priv_ps.test
1.68
KB
-rw-r--r--
processlist_val_no_prot.test
1.54
KB
-rw-r--r--
processlist_val_ps.test
1.48
KB
-rw-r--r--
row_count_func-master.opt
34
B
-rw-r--r--
row_count_func.test
2.07
KB
-rw-r--r--
storedproc.test
642.25
KB
-rw-r--r--
suite.opt
38
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : is_collations.test
# suite/funcs_1/t/is_collations.test # # Check the layout of information_schema.collations and some # functionality related tests. # # Author: # 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of # testsuite funcs_1 # Create this script based on older scripts and new code. # if (`SELECT VERSION() LIKE '%embedded%'`) { --skip Bug#37456 funcs_1: Several tests crash when used with embedded server } let $is_table = COLLATIONS; # The table INFORMATION_SCHEMA.COLLATIONS must exist eval SHOW TABLES FROM information_schema LIKE '$is_table'; --echo ####################################################################### --echo # Testcase 3.2.1.1: INFORMATION_SCHEMA tables can be queried via SELECT --echo ####################################################################### # Ensure that every INFORMATION_SCHEMA table can be queried with a SELECT # statement, just as if it were an ordinary user-defined table. # --source suite/funcs_1/datadict/is_table_query.inc --echo ######################################################################### --echo # Testcase 3.2.3.1: INFORMATION_SCHEMA.COLLATIONS layout --echo ######################################################################### # Ensure that the INFORMATION_SCHEMA.COLLATIONS table has the following # columns, in the following order: # # COLLATION_NAME (shows a collation name), # CHARACTER_SET_NAME (shows the name of the character set to which the # collation applies), # ID (shows a numeric identifier for that collation/character set combination), # IS_DEFAULT (shows whether the collation is the default collation for the # character set shown), # IS_COMPILED (indicates whether the collation is compiled into the MySQL server), # SORTLEN (shows a value related to the amount of memory required to sort # strings using this collation/character set combination). # eval DESCRIBE information_schema.$is_table; eval SHOW CREATE TABLE information_schema.$is_table; eval SHOW COLUMNS FROM information_schema.$is_table; # Note: Retrieval of information within information_schema.columns about # information_schema.collations is in is_columns_is.test. # Retrieval of information_schema.collations content is in # charset_collation.inc (sourced by charset_collation_*.test). echo # Testcases 3.2.3.2 and 3.2.3.3 are checked in suite/funcs_1/t/charset_collation*.test; --echo ######################################################################## --echo # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and --echo # DDL on INFORMATION_SCHEMA tables are not supported --echo ######################################################################## # 3.2.1.3: Ensure that no user may execute an INSERT statement on any # INFORMATION_SCHEMA table. # 3.2.1.4: Ensure that no user may execute an UPDATE statement on any # INFORMATION_SCHEMA table. # 3.2.1.5: Ensure that no user may execute a DELETE statement on any # INFORMATION_SCHEMA table. # 3.2.1.8: Ensure that no user may create an index on an INFORMATION_SCHEMA table. # 3.2.1.9: Ensure that no user may alter the definition of an # INFORMATION_SCHEMA table. # 3.2.1.10: Ensure that no user may drop an INFORMATION_SCHEMA table. # 3.2.1.11: Ensure that no user may move an INFORMATION_SCHEMA table to any # other database. # 3.2.1.12: Ensure that no user may directly add to, alter, or delete any data # in an INFORMATION_SCHEMA table. # --disable_warnings DROP DATABASE IF EXISTS db_datadict; --enable_warnings CREATE DATABASE db_datadict; --error ER_DBACCESS_DENIED_ERROR INSERT INTO information_schema.collations SELECT * FROM information_schema.collations; --error ER_DBACCESS_DENIED_ERROR INSERT INTO information_schema.collations (collation_name,character_set_name,id,is_default,is_compiled,sortlen) VALUES ( 'cp1251_bin', 'cp1251',50, '', '',0); --error ER_DBACCESS_DENIED_ERROR UPDATE information_schema.collations SET description = 'just updated'; --error ER_DBACCESS_DENIED_ERROR DELETE FROM information_schema.collations WHERE table_name = 't1'; --error ER_DBACCESS_DENIED_ERROR TRUNCATE information_schema.collations; --error ER_DBACCESS_DENIED_ERROR CREATE INDEX my_idx ON information_schema.collations(character_set_name); --error ER_DBACCESS_DENIED_ERROR ALTER TABLE information_schema.collations DROP PRIMARY KEY; --error ER_DBACCESS_DENIED_ERROR ALTER TABLE information_schema.collations ADD f1 INT; --error ER_DBACCESS_DENIED_ERROR ALTER TABLE information_schema.collations ENABLE KEYS; --error ER_DBACCESS_DENIED_ERROR DROP TABLE information_schema.collations; --error ER_DBACCESS_DENIED_ERROR ALTER TABLE information_schema.collations RENAME db_datadict.collations; --error ER_DBACCESS_DENIED_ERROR ALTER TABLE information_schema.collations RENAME information_schema.xcollations; # Cleanup DROP DATABASE db_datadict;
Close
