On Monday, March 28, 2005 15:07, Philippe Reynolds wrote: > Hi, > > I've just create an account and given it all privileges for > "database_name.*". However when I try to 'load data infile' it > tell's me that the account doesn't permit it. > > When I use the 'root' account everything is fine. > > Can you guys help? > > Cheers > Phil
The user needs the FILE priv. This is a global priv. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]