Re: Mysql question (access rights)

2001-07-06 Thread T LaWall
may need to double quote the % sign. trav On Thu, 5 Jul 2001, Chris M wrote: > I've got a question. > > In the otherwise-excellent Paul DuBois book, on page 427 or so it talks > about how you can do this: > > GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt"; > > So I tried some

Re: Mysql question (access rights)

2001-07-05 Thread Paul DuBois
At 9:20 PM -0600 7/5/01, Chris M wrote: >I've got a question. > >In the otherwise-excellent Paul DuBois book, on page 427 or so it talks >about how you can do this: > >GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt"; > >So I tried something similar: > >mysql> GRANT SELECT ON *.* TO m

Mysql question (access rights)

2001-07-05 Thread Chris M
I've got a question. In the otherwise-excellent Paul DuBois book, on page 427 or so it talks about how you can do this: GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt"; So I tried something similar: mysql> GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY "dirt"; ERROR 1064: You have