################################################################################# # 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 DEFAULT_ENCRYPTION def information_schema utf8mb3 utf8mb3_general_ci NULL NO def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO def test utf8mb4 utf8mb4_0900_ai_ci NULL NO SHOW DATABASES LIKE 'information_schema'; Database (information_schema) information_schema SHOW DATABASES LIKE 'mysql'; Database (mysql) mysql SHOW DATABASES LIKE 'test'; Database (test) test # Establish connection testuser1 (user=testuser1) 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 DEFAULT_ENCRYPTION def information_schema utf8mb3 utf8mb3_general_ci NULL NO def test utf8mb4 utf8mb4_0900_ai_ci NULL NO SHOW DATABASES LIKE 'information_schema'; Database (information_schema) information_schema SHOW DATABASES LIKE 'mysql'; Database (mysql) SHOW DATABASES LIKE 'test'; Database (test) test # Switch to connection default and close connection testuser1 DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict;