CREATE DATABASE db_datadict; CREATE USER user_1@localhost; GRANT ALL ON db_datadict.* TO user_1@localhost; # Adding the following grant does not change the outcome # Still failing in 5.0.42 # GRANT FILE ON *.* TO user_1@localhost; select version(); connect (con_test,localhost,user_1,,db_datadict); select current_user(); select user(); SELECT SCHEMA_NAME FROM information_schema.schemata WHERE schema_name LIKE 'db_%'; # Comment out for 5.0.40 and enable for 5.0.42 # --error 1044 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_%';