#################################################################################
# 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	latin1	latin1_swedish_ci	NULL	
def	test	latin1	latin1_swedish_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	
def	test	latin1	latin1_swedish_ci	NULL	
SHOW DATABASES LIKE 'information_schema';
Database (information_schema)
information_schema
SHOW DATABASES LIKE 'mysql';
Database (mysql)
SHOW DATABASES LIKE 'test';
Database (test)
test
connection default;
DROP USER 'testuser1'@'localhost';
DROP DATABASE db_datadict;