Re: 'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

2005-05-29 Thread Gleb Paharenko
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

'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

2005-05-28 Thread Jeroen Van Goey
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