Gilles MISSONNIER wrote: > Hello > How to set "FILE privilege enable" to an already defined user ? > > It seems that I have to read the all manual for that. > I cannot find an example in the on line manual. <snip>
sheeri kritzer wrote: > GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; > > It won't set up a new account, just add the privilege for you. Gilles MISSONNIER wrote: > Thank you Sheeri for answering, > > I guess this syntax works for you, but > for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian sarge ) > > mysql> GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd'; > ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES <snip> Dilipkumar wrote:
Hi, You can try this option by grant file on *.* to [EMAIL PROTECTED] identified by 'db123'; Query OK, 0 rows affected (0.03 sec) For all the Databases.
The FILE privilege is a global privilege <http://dev.mysql.com/doc/refman/5.0/en/grant.html>, so it can only be granted on *.*, as Dilipkumar suggests. Also, once you've created a user and set a password, you only need the "IDENTIFIED BY" clause in your GRANT statements if you are *changing* the password. Without that clause, the current password stays in effect. Hence, you need
GRANT FILE ON *.* TO [EMAIL PROTECTED]; Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
