RE: [cobalt-users] raq4 mysql

["Clark E. Morgan" <prlhkr@xxxxxxxxxxxxx>]

> Hi,
>
> > This sounds so simple but I'm so stuck! I've managed to install
> PHPMyAdmin
> > successfully on my RAQ4 and can log in as root. I know how to create a
> > database within PHPMyAdmin, but how do you create a user with privilages
> > just to that users database? What is the command/syntax? I'm concerned
> about
> > security, etc.
>
> Using phpMyAdmin this should turn out to be a breeze. Here's the
> procedure I
> follow:

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. An example might be,
say for a restricxted access web only user

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

Depending on how you went about it, you could issue as many as 4 insert and
update statements combined to achieve the same result that this single
statement will get for you. Keep it simple and reduce the opportunity for
mistakes.

Clark E. Morgan