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, on a column in a
database.
If this is explained in the doc, I would like to know which keyword
I should give to have a fast answer, through "Search the MySQL manual:"
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
IAP - [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]