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 user@localhost identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to user@localhost identified by 'passwd';
Try this, correct me if i am worng.This might help you out.
Perhaps I am misreading, but this sounds as if you think I disagreed with you.
That isn't the case. I agreed your solution, "*.*" instead of "db.*" is
correct, referenced the manual page which confirms it, and added that the
"IDENTIFIED BY" clause is unnecessary for existing users. That is,
grant file on *.* to user@localhost identified by 'passwd';
will work, but
grant file on *.* to user@localhost;
is better (unless you really mean to reset the password).
Michael
9 messages in com.mysql.lists.mysqlRe: grant modify, doc on grant.
