1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
#################################################################################
# Testcases 3.2.9.2 + 3.2.9.3: INFORMATION_SCHEMA.SCHEMATA accessible information
#################################################################################
DROP DATABASE IF EXISTS db_datadict;
CREATE DATABASE db_datadict;
DROP USER 'testuser1'@'localhost';
CREATE USER 'testuser1'@'localhost';
GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost';
SELECT * FROM information_schema.schemata
WHERE schema_name IN ('information_schema','mysql','test')
ORDER BY schema_name;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
SHOW DATABASES LIKE 'information_schema';
Database (information_schema)
information_schema
SHOW DATABASES LIKE 'mysql';
Database (mysql)
mysql
SHOW DATABASES LIKE 'test';
Database (test)
test
connect testuser1, localhost, testuser1, , db_datadict;
SELECT * FROM information_schema.schemata
WHERE schema_name IN ('information_schema','mysql','test')
ORDER BY schema_name;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
def information_schema utf8mb3 utf8mb3_general_ci NULL
SHOW DATABASES LIKE 'information_schema';
Database (information_schema)
information_schema
SHOW DATABASES LIKE 'mysql';
Database (mysql)
SHOW DATABASES LIKE 'test';
Database (test)
connection default;
DROP USER 'testuser1'@'localhost';
DROP DATABASE db_datadict;
|
