List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:September 13 1999 2:49pm
Subject:Re: MySQL: User Privledges
View as plain text  
John Millaway wrote:
> 
>  > John Millaway writes:
> >  > > Does this mean that you store all of the users and passwords
> >  > > in the mysql
> >  > > master database?  Even if it applies to only one specific
> >  > > database on the
> >  > > host?
> >  >
> >  > BINGO!
> >  > All privileges are in the mysql database, in the three
> > tables: user,db,
> >  > and host.
> >  >
> >  >
> >
> >
> > Please do not use insert/update/delete with grant tables.
> >
> > Use grant and revoke commands. There is a whole chapter in a manual
> > devoted to them.
> >
> > Sinisa
> 
> Huh? The manual gives specific examples using INSERT. In fact, now that
> I look at it again, the "privileges" section uses no GRANT or REVOKE
> examples at all....

Hi John

The problem is, that you use the trial/shareware version 3.21.29 of Win32.
This does _not_ have the GRANT, REVOKE syntax.
It was introduced in version 3.22.11 of mysql.
So you have to stick with INSERTs, UPDATEs and DELETEs to the mysql.* priviledge tables.

Tschau
Christian

Thread
Backup tabelBen-Nes Michael6 Sep
  • Re: Backup tabelMartin Ramsch6 Sep
  • Re: Backup tabelBen-Nes Michael6 Sep
    • Re: Backup tabelMartin Ramsch6 Sep
  • Re: Backup tabelBen-Nes Michael9 Sep
    • Re: Backup tabelMartin Ramsch9 Sep
  • Re: Backup tabelBen-Nes Michael9 Sep
    • Re: Backup tabelMichael Widenius9 Sep
  • MySQL: User Privledgesmtweito9 Sep
    • Re: MySQL: User PrivledgesMartin Ramsch9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User Privledgesmtweito9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • RE: MySQL: User Privledgessinisa9 Sep
    • Re: MySQL: User PrivledgesBenjamin Pflugmann9 Sep
      • Re: MySQL: User Privledgessinisa10 Sep
        • get_lockA. Brandic10 Sep
          • Re: get_lockMartin Ramsch10 Sep
          • Re: get_locktonu10 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
RE: MySQL: User PrivledgesJohn Millaway9 Sep
  • Re: MySQL: User PrivledgesChristian Mack13 Sep