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
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
user:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
'myuser
it ?
Jerry
- Original Message -
From: Andy De Petter [EMAIL PROTECTED]
To: [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
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,
: 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 denied errors,
when trying to do a load data infile ;-/
The user has:
GRANT USAGE
/doc/en/LOAD_DATA.html
Did adding FILE to the permissions do it ?
Jerry
- Original Message -
From: Andy De Petter [EMAIL PROTECTED]
To: Jerry [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 12:47 PM
Subject: Re: LOAD DATA INTO not working
I can
: [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 Edition) then. ;)
Thanks a lot,
-Andy
On Thu, 20 Feb 2003, Jerry wrote
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