Your grant statement give ltm all privileges on LTM and not on user. By default, ltm is granted usage on user.
To see the privileges the user ltm has, try any of these two: select * from db where user='ltmuser'\G; show privileges for [EMAIL PROTECTED] Select from db should show ltm having all privileges on LTM and not user. HTH Babs -----Ursprüngliche Nachricht----- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 25. März 2004 18:27 An: [EMAIL PROTECTED] Betreff: Re: mysql.user does not reflect privileges granted correctly? "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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
