On Thursday 20 February 2003 14:40, Andy De Petter wrote:
> When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
> problem, although I (should) have the correct privileges, for a specific
> user:
>
>
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
> 'myuse
;
To: "Jerry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 1:00 PM
Subject: Re: LOAD DATA INTO not working
>
> I've just tried, and it seems to work This means, there is an error
> in the O'Reilly book (July 1999, 1st Edit
x27;@'localhost' IDENTIFIED BY
> > 'password' >
> > > mysql -u myuser -ppassword
> > >
> > > Does that do it ?
> > >
> > > Jerry
> > >
> > > - Original Message -
> > > From: "Andy D
ot;Jerry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 12:47 PM
Subject: Re: LOAD DATA INTO not working
>
> I can perfectly connect to the myqsl server, with this specific user .. he
> can select/insert/update/whatever, but he gets permission den
The file resides in /var/tmp (I am using the full path):
LOAD DATA INFILE '/var/tmp/whatever' INTO TABLE ...
-a
On Thu, 20 Feb 2003, Ahmed S K Anis wrote:
> If the File resides in the same machine as the Database, it should
> work.
> If the file resides where the your client program resides, t
ENTIFIED BY
'password' >
> mysql -u myuser -ppassword
>
> Does that do it ?
>
> Jerry
>
> - Original Message -
> From: "Andy De Petter" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 20, 2003
lt;[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 12:40 PM
Subject: LOAD DATA INTO not working
>
> Hello gurus,
>
> When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
> problem, although I (should) have the correct privileges, for a specific
>
Hello gurus,
When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
problem, although I (should) have the correct privileges, for a specific
user:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
'myuser'@'localhost'
I am using MySQL 3.23.54.
Has anyone
