"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. > > 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 can insert rows one by one into table ltm_enrollment as user > 'ltmuser'@'localhost' without any problems. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]