RE: [cobalt-users] Creating MySql account

["Simon Watts" <simon@xxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of
> Zarrir Junior
> Sent: 23 July 2001 07:20
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] Creating MySql account
>
>
>  > >>3)How exactly do i create his account?
> > The easiest way to start managing your MySQL databases would be to
> > grab yourself a copy of PHPMyAdmin and drop it into a
> > password-protected folder in your /home/sites/home/web directory.
> > Open up config.php with an editor and input your username
> (root) and
> > password.
> > Then go to that directory through your browser, and you'll
> > immediately see (once you've gotten past the password
> challenge) the
> > opportunity to create a new database. Let's say it's going to be
> > named "bluewidgets". You'd type "bluewidgets" (no quotes) into the
> > field there on the right-hand side of the page and hit the CREATE
> > button.
> > It creates the database for you, and opens up a page
> where you can do
> > further stuff with it. In the big textarea there, you're going to
> > type (or copy/paste) the command to make a user *just* for the
> > bluewidgets database. (He won't be able to access any other
> > databases.) Type:
> > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER on
> > bluewidgets.* TO clientusername@localhost IDENTIFIED by
> > "clientusernamepassword";
>
>           Thank you so much Carrie. Extremely explanatory
> and helped me with
> all my doubts and more. A very concise How-to.
>             Zarrir
>