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/[EMAIL PROTECTED]