471,075 Members | 1,248 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Access denied with LOAD DATA INFILE

I am a relatively new user to MySQL running version 4.0.17 on MacOS X
10.3.3 (this is the "current version" installed by the Fink package
manager).

I login to mysql as root

mysql -u root -p

and issue the following commands:

CREATE DATABASE MAPS;
GRANT ALL ON maps.* TO creator@localhost;
FLUSH PRIVILEGES;
use MAPS;
CREATE TABLE Pproto [I have "clipped" the full command here]

Then I login to mysql as user creator (which has no password)

mysql -h localhost -u creator maps

and type the following:

CREATE TABLE P001 AS SELECT * FROM Pproto;
ALTER TABLE P001 ADD PRIMARY KEY (starnumO);
LOAD DATA INFILE '/path_to/P001.in' INTO TABLE P001 FIELDS TERMINATED BY
' ' LINES TERMINATED BY '\n';"

At which point the space delimited file at /path_to/P001.in (which is
readable by all readers) fails to be read in with the following error:

ERROR 1045 at line 1: Access denied for user: 'creator@localhost' (Using
password: NO)

Why am I getting a usage error. User 'creator@localhost' should have
all privileges on the maps.* tables, and I can create and alter them,
but "FILES" privilege doesn't appear to have been granted to 'creator'.

Juan
Jul 20 '05 #1
0 2283

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Bruce A. Julseth | last post: by
14 posts views Thread by Bruce A. Julseth | last post: by
5 posts views Thread by Phil Powell | last post: by
3 posts views Thread by hall | last post: by
4 posts views Thread by CPD | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.