[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Replication and Grants nightmare
From:       Nico Sabbi <nsabbi () officinedigitali ! it>
Date:       2004-04-30 15:05:12
Message-ID: 200404301705.12164.nsabbi () officinedigitali ! it
[Download RAW message or body]

Alle Friday 30 April 2004 16:44, hai scritto:
> At 16:22 +0200 4/30/04, Nico Sabbi wrote:
> >Alle Friday 30 April 2004 15:51, hai scritto:
> >>  >P.S. the manual doesn't say that grants super, reload, replication
> >>  > client and replication slave can be used only on *.* and not on DB.*.
> >>
> >>  Each of those privileges is listed as an administrative privilege here:
> >>
> >>  http://dev.mysql.com/doc/mysql/en/Privileges_provided.html
> >>
> >>  There are not listed as database or table privileges.
> >>
> >>  I'm not sure what it could mean for them to be database-specific,
> >> actually.
> >
> >so I should have columns Repl_client_priv and Repl_slave_priv ?
> >my mysql db doesn't have them:
>
> Indeed you should (in the user table only), and several other columns
> as well.
>
> Perhaps that is a clue to what is happening.  Did you upgrade from a
> release older than 4.0.2 to a release 4.0.2 or newer at some point,
> without running the mysql_fix_privilege_tables script?  If so, then
> please read this:
>
> http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
>

done, it works correctly now. 

Thanks very much,
		Nico

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]