I've got a database netscore which I want to be able to bulk load. The database already exists and I can do inserts into tables:
[EMAIL PROTECTED] schema]$ mysql -s mysql> use netscore mysql> insert into boat values (100, 'foo', 'foo', 'foo', 101); mysql>
but I can't do a "load data infile". When I try, I get access denied:
[EMAIL PROTECTED] schema]$ mysql -s mysql> use netscore mysql> load data infile 'data/boat.data' into table boat; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql>
I tried to do a "grant file", but get a "wrong usage" error:
[EMAIL PROTECTED] schema]$ mysql -u root -p -s Enter password: mysql> grant file on netscore.* to roy; ERROR 1221: Wrong usage of DB GRANT and GLOBAL PRIVILEGES mysql>
I don't understand this message. Doesn't the "on netscore.*" clause mean I'm setting privileges at the database level? Why does it think I'm doing a global?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]