[Gloucs] mysql

[Guy Edwards]

(Much fiddling)

Yes! perfect. An old database app I wrote is working now. The
stocktaking thing I downloaded from sourceforge isn't but that's an
unrelated problem.

Cheers,
Guy 

On Tue, 2002-09-17 at 18:44, Adam Langley wrote:
> I don't have a MySQL install to play with, but...
> 
> > mysql> grant all
> > --> on opendb.*
> > --> to stockkeep identified by 'letmein';
> 
> I would write:
> > grant all privileges on opendb.* to stockkeep@localhost identified by
> 'letmein';
> 
> (added "privileges" and "@localhost")
> 
> also,
> 
> > show grants for user@host;
> 
> will show what permissions MySQL thinks a given user has
> 
> hope that helps
> 
> -- 
> Adam Langley                                      agl@imperialviolet.org
> http://www.imperialviolet.org                       (+44) (0)7986 296753
> PGP: 9113   256A   CC0F   71A6   4C84   5087   CDA5   52DF   2CB6   3D60
> 
> _______________________________________________
> Gloucs mailing list
> Gloucs@mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/gloucs