[Gloucs] mysql

[Adam Langley]

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