Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identified by 'passwd';
Try this, correct me if i am worng.This might help you out.
Michael Stassen wrote:
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
--
Thanks & Regards,
Dilipkumar
DBA Support
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED]
Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here.
www.sifymax.com
Get to see what's happening in your favourite City on Bangalore Live!
www.bangalorelive.in
