how a normal user can "load a data into the table" ?

[santhanalakshmi]

hi,

I have created a new user in mysql by the root user.
user:san
password:san

when i login into mysql as a normal user :

      shell> mysql  -u san -psan databasename

Now,i am trying to use

 mysql>load data infile 'C:/text.txt' into table born fields terminated by ',' lines terminated by '\r\n';

Error msg:

Access denied for use san@loacalhost( using password 'YES')

But i have GRANTED ALL PRIVILEGES for the user.But its working very finely if i login as a ROOT user.

A normal user :
1.cant create a new user
2.cant create a new database
3.cant change a password
4.cant use "LOAD data " also va............. .......

only they can do "SELECT,INSERT, UPDATE,DELETE.. ..."

[mwasif]

But i have GRANTED ALL PRIVILEGES for the user.But its working very finely if i login as a ROOT user.

How did you GRANTED ALL PRIVILEGES?

For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege.

[santhanalakshmi]

hi,

I got it .Thanks for your response.