> > [snip] > if you don't restart MySQL after changing the grants > priviliges, you have to > issue the "flush privileges" command from the MySQL Monitor. > If you don't do > either one your privilege changes will not take affect. > > not sure if when you said "reloaded" you meant "flush > privileges" but if not > try it and see how it goes. > [/snip] > > That's what I meant. I have reloaded MySQL, flushed, stopped > and started the > server. The killer is that this user is able to access the > database just > hunky-dorie, do selects, inserts, deletes, updates. > > Thanks! > > Jay > sql, mysql, query
If you use the GRANT command, you don't have to "flush privileges". If you UPDATE,INSERT your own grant records, then you have to flush. Try granting FILE privilege. mysqlimport is LOAD DATA INFILE like, which needs the FILE privilege --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
