Hi, File Privilege will do that. But the FILE privilege can only be granted globally (using ON *.* syntax).Therefore, attempts to restrict it to a particular scope will lead to error.
so try with grant file on*.* to 'user'@'localhost'; Hope this will do. Thanks ViSolve DB Team ----- Original Message ----- From: "Bing Du" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Thursday, December 14, 2006 12:26 AM Subject: account that can only do backup > Hi, > > I want to create a MySQL user account that can only do database backup but > nothing else. What privileges does such an account need? > > I'm having trouble with connecting to mysql.com to look at the documents. > It's just spinning forever. Actually, the connection to mysql.com has > become extremely slow since I noticed the mysql.com was redesigned. > > Thanks in advance, > > Bing > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
