Hello.
You should have FILE privilege. The FILE privilege is administrative privilege that can only be granted globally (using ON *.* syntax). Jeroen Van Goey <[EMAIL PROTECTED]> wrote: > Hi all, > > I connect via ssh from a Linux RedHat 9 box to a remote FreeBSD > server. There I can run MySQL and successfully add/remove tables etc. > However, when I tried to upload a comma separated value file, I got an > access denied error, although all privileges are granted to my > account. What should I do/am I doing wrong? > > > > [EMAIL PROTECTED] jeroen]$ uname -rs > Linux 2.4.21-4.EL > > [EMAIL PROTECTED] jeroen]$ ssh [EMAIL PROTECTED] > Password: > > [EMAIL PROTECTED] ~> uname -rs > FreeBSD 5.3-RELEASE > > [EMAIL PROTECTED] ~> mysql -V > mysql Ver 14.7 Distrib 4.1.10, for portbld-freebsd5.3 (i386) > > [EMAIL PROTECTED] ~> mysql -ubiogeek -p > Enter password: > > mysql> use biogeek; > Database changed > > mysql> LOAD DATA INFILE 'zipcode.data' INTO TABLE zipcodes FIELDS > TERMINATED BY ','; > ERROR 1045 (28000): Access denied for user 'biogeek'@'localhost' > (using password: YES) > > mysql> show grants for 'biogeek'@'localhost'; > +--------------------------------------------------------------------------= > ---------------------------------------------------+ > | Grants for [EMAIL PROTECTED] =20 > | > +--------------------------------------------------------------------------= > ---------------------------------------------------+ > | GRANT USAGE ON *.* TO 'biogeek'@'localhost' IDENTIFIED BY PASSWORD '*66..= > .' | > | GRANT ALL PRIVILEGES ON `biogeek`.* TO biogeek'@'localhost' =20 > | > +--------------------------------------------------------------------------= > ---------------------------------------------------+ > 2 rows in set (0.00 sec) > > > > PS: I do not have root access. > -- 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]
