CREATE DATABASE db_datadict;
CREATE USER user_1@localhost;
GRANT ALL ON db_datadict.* TO user_1@localhost;
select version();
version()
5.0.42-log
select current_user();
current_user()
user_1@localhost
select user();
user()
user_1@localhost
SELECT SCHEMA_NAME
FROM information_schema.schemata
WHERE schema_name LIKE 'db_%';
SCHEMA_NAME
db_datadict
SELECT SCHEMA_NAME
INTO OUTFILE '../tmp/test_out.file'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM information_schema.schemata
WHERE schema_name LIKE 'db_%';
ERROR 42000: Access denied for user 'user_1'@'localhost' to database 'information_schema'