Thanks for the heads-up! > "Bing Du" <[EMAIL PROTECTED]> wrote: >> Greetings, >> >> I did: >> >> mysql> grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; >> >> But >> >> mysql> select * from user where user='ltmuser'\G; >> >> shows: >> >> *************************** 1. row *************************** >> Host: localhost >> User: ltmuser >> Password: 132f058a4532ff99 >> Select_priv: N >> Insert_priv: N >> Update_priv: N >> Delete_priv: N >> Create_priv: N >> Drop_priv: N >> Reload_priv: N >> Shutdown_priv: N >> Process_priv: N >> File_priv: N >> Grant_priv: N >> References_priv: N >> Index_priv: N >> Alter_priv: N >> Show_db_priv: N >> Super_priv: N >> Create_tmp_table_priv: N >> Lock_tables_priv: N >> Execute_priv: N >> Repl_slave_priv: N >> Repl_client_priv: N >> ssl_type: >> ssl_cipher: >> x509_issuer: >> x509_subject: >> max_questions: 0 >> max_updates: 0 >> max_connections: 0 >> >> >> I thought the *_priv fields should all have 'Y' rather than 'N'. > > Table 'user' contains global level privileges, but you set permissions on > the database level. > Check 'db' table. >
Ah, ok. 'db' table looks correct. >> >> I also tried 'flush privileges' but it did not help. >> >> What I need to do is load data from a file into a table. >> >> mysql> load data infile >> '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' >> into table ltm_enrollment fields terminated by '\t'; >> ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using >> password: >> YES) >> >> What privileges are needed for doing 'load data infile'? > > You must have FILE privilege. > >> I did not realize FILE privilege was not covered by 'grant all'. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]