Re: [cobalt-users] Creating MySql account

["Zarrir Junior" <zarrir@xxxxxxxxxxxx>]

 > >>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