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 privileges that can only be granted globally (using ON *.* syntax)." -Sheeri On 5/30/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]