Hello.
Your entry in the user table doesn't have the FILE privilege enabled. What output does the following statement produce: show grants for 'your_dba_user'@'your_dba_host'; You can find out your username by executing 'status' command in mysql. Have you reloaded grant tables after changing them? See: http://dev.mysql.com/doc/mysql/en/Access_denied.html http://dev.mysql.com/doc/mysql/en/Privilege_changes.html http://dev.mysql.com/doc/mysql/en/Privileges_provided.html [EMAIL PROTECTED] wrote: > > Hi, > Thank you for your reply. When I log in as a DBA user and try to load > data from a file, I am getting an error as "Access Denied", so, here I > want to know what type of permissions I have to give for a user to load > data infile form a file. > > Thanks, > Narasimha > > -----Original Message----- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 22, 2004 1:35 AM > To: mysql@lists.mysql.com > Subject: Re: Regarding User creation and loading data > > Hello. > > What error have you got? Send us compete command that you issued and > the error message. >>Could any one of you help me in creating two users like First user with >>all dba privileges as root and the Second user with only dml > operations. > > For root user use: > grant all privileges on *.* to 'vasja'@'vasinhost' identified by > 'vasinpass' with grant option; > > For dml user use something like this: > grant select,insert,update,delete on test.* to 'dml'@'localhost' > identified by 'v'; > See: > http://dev.mysql.com/doc/mysql/en/GRANT.html > > >>And in loading data using LOAD DATA INFILE, if I use the file full > path, >>I am getting error. And if I put the file in mysql\bin it is executing. >>How to load a dta in a file which is located in some other directories. > > > --=0D > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=0D > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > Confidentiality Notice=0D > > The information contained in this electronic message and any attachments to= > this message are intended > for the exclusive use of the addressee(s) and may contain confidential or= > privileged information. If > you are not the intended recipient, please notify the sender at Wipro or= > [EMAIL PROTECTED] immediately > and destroy all copies of this message and any attachments. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
