Bug #10531 mysqlimport does not honour user privileges
Submitted: 11 May 2005 7:35 Modified: 13 May 2005 7:34
Reporter: Disha Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.5-beta-nt OS:Windows (Windows xp)
Assigned to: CPU Architecture:Any

[11 May 2005 7:35] Disha 
Description:
If I try to insert data into table using mysqlimport tool it does not honour insert privilege.

data values for file t1.txt
1	a
4	b
5	f

How to repeat:
A)Execute following 'sql' commands

1. Create table t1 (i1  INT NOT NULL AUTO_INCREMENT, i2 char(1),PRIMARY KEY  
   (i1,i2)) ENGINE=MyISAM AUTO_INCREMENT=1;
2.create user 'm'@'localhost';
3.grant all on test01.* to 'm'@'localhost';
4.flush privileges;
5. show grants for 'm'@'localhost';

B) execute the following insert statment 
   mysqlimport -u m -f -i test01  c:\t1.txt
  
C) Expected Result: Sucessful importing of data

D) Actual Result: 	mysqlimport: Error: Access denied for user 'm'@'localhost' 
    (using password: NO), when using table: t1
[11 May 2005 18:38] MySQL Verification Team 
Also tested on Linux.
[13 May 2005 7:34] Sergei Golubchik 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

It honors INSERT privileges perfectly. But you need a global FILE privilege to be able to access files (as mysqlimport uses LOAD DATA INFILE).