mysql.user does not reflect privileges granted correctly?

[Bing Du]

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'.

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'?

I can insert rows one by one into table ltm_enrollment as user
'ltmuser'@'localhost' without any problems.

Would anybody tell me what's wrong?

Thanks,

Bing

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]