Firstly, I apologize for my incorrect db level grant in the syntax I posted.
Secondly, by going to mysql.com/grant I found the GRANT syntax page,
which states:
"The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE,
SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative
pr
Thanks Dilipkumar,
the syntax works fine
mysql> grant file on *.* to 'wr'@'localhost';
so the "file" privilege is for ALL databases.
by the way, to allow "alter", the syntax is like :
mysql> grant alter on dr4.* to 'wr'@'localhost';
here the "alter" privilege is specific to a database, o
Dilipkumar wrote:
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] identifie
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
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.
sheeri kritzer wrote:
> GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passw
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.
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
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
the
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.
-Sheeri
On 5/26/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
Hello
How to set "FILE privilege enable" to an already defined user ?
It seems that I have to re
