Re: [cobalt-users] raq4 mysql

["Nico Meijer" <nico.meijer@xxxxxxxxx>]

Hi Clark,

> As much as I enjoy and have benfitted from using phpMyAdmin for a lot of
> things, I find that for the purposes of creating and setting the
priveleges
> of users that the grant statement on the command line is infinitely more
> intuitive than modifying the user database directly.

Very true. Both products (/usr/bin/mysql and phpMyAdmin) have their
respective pros and cons.

To the newbie/novice user phpMyAdmin offers control you didn't probably even
know existed. I myself have learned a lot from it, since it displays most
queries right after you filled in some forms and clicked a few buttons. A
few hundred pages of printed documentation can be quite scary at first. ;-)

To the intermediate/advanced user the CLI is always much quicker and more
powerful.

For example, I've never used a GUI to administer bind, apache or sendmail
and haven't missed that experience once. Of course, my RaQ has not yet
arrived. ;-) But I'm getting offtopic.

> grant insert, update, delete on <database>.<table> to <user@host>
identified
> by "<password>";

Personally, I like the overview phpMyAdmin offers when doing this task.
Especially if 20 or more accounts are involved. It's all a matter of taste.

> Keep it simple and reduce the opportunity for mistakes.

I think that's the best piece of advice regarding *any* type of
administration. :-)

With regards,

Nico