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]
