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] 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 [EMAIL PROTECTED] identified by 'passwd';
will work, but
grant file on *.* to [EMAIL PROTECTED];
is better (unless you really mean to reset the password).
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
