I have set all privileges in the user table to yes, as follows: Select_priv enum -- Y Insert_priv enum -- Y Update_priv enum -- Y Delete_priv enum -- Y Create_priv enum -- Y Drop_priv enum -- Y Reload_priv enum -- Y Shutdown_priv enum -- Y Process_priv enum -- Y File_priv enum -- Y Grant_priv enum -- Y References_priv enum -- Y Index_priv enum -- Y Alter_priv enum -- Y
What else can I try? Thanks. Ronnie -----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Re: Unknown error, urgent help please "Ronnie Regev" <[EMAIL PROTECTED]> wrote: > Hi, > Before I go on, I know nothing about mysql, but my db admin is out of town > and I need to be pointed in the right direction please. > Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual > hosting environment on Ensim webppliance-3.5.20-7. > > When using phpMyAdmin and attempting to upload a csv file, the following > error is the result: > ____________________________________________________________________________ > _____________ > Database domain_ca_-_stats - Table location running on localhost > Error > > SQL-query : > > LOAD DATA INFILE '/tmp/php7T1P2m' INTO TABLE `location` FIELDS TERMINATED BY > ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' > > MySQL said: > > > Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > Back > ____________________________________________________________________________ > ____________________ > > The user in question has the appropriate permissions. Thanks about al I > know. > > Im sure this is such a simple problem, but unfortunately this molehill is my > mountain today. > Thanks in advance, and my apologies for posting what will be such a simple > problem. Does user '[EMAIL PROTECTED]' have FILE privilege? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
