On Thu, Aug 16, 2001 at 03:57:02PM -0400, Brian Burke wrote:
> All,
>
> I'm hitting some stumbling blocks getting replication working, and
> so I decided to join the list for support.
Welcome...
> Here is what I'm trying to do:
> GRANT FILE on dbname.tablename to user@"%" IDENTIFIED BY 'passwd';
>
> Here is the error I get:
> ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual
> which privileges can be used.
>
> The following commands work for database level replication:
> GRANT FILE on * to user@"%" IDENTIFIED BY 'passwd';
> GRANT FILE on *.* to user@"%" IDENTIFIED BY 'passwd';
>
> I've looked through the documentation and haven't been able to find
> what I need. Is this possible, or must I do database level
> replication?
I suspect that you can't actually GRANT the file privilege to a
particular db.table combination. If that's the case, the fact that
'*.*' worked may be a bug. Hmm. The manual isn't too clear on this
point (where I looked, at least).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 0 days, processed 409,266 queries (99/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
