Re: [cobalt-users] (no subject)

[Bill Gunning <billgun@xxxxxxxxxxxxxxxxx>]

/usr/bin/mysqladmin -u root password 'blablabla'
mysqladmin -u root -p create databasename

mysql -u root -p
GRANT ALL PRIVILEGES ON databasename.* TO username@localhost IDENTIFIED BY
'password'
WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON databasename.* TO username@"%" IDENTIFIED BY
'password' WITH
GRANT OPTION;
FLUSH PRIVILEGES;

username should be the same name as siteadmin, also make
sure siteadmin owns the folders.

Bill

At 07:36 AM 4/13/00 -0700, you wrote:
>I did an install of mysql on my Raq3 but I need  it set up so that I can
>create databases for users set with their username and password so
>that they can access them, etc.... I believe this can be done by
>setting up the permissions but I am unsure how to go about doing this.
>Any help on the is subject would be great.
>
>  
>
>    Thanks Mike
>
>
>
>_______________________________________________
>cobalt-users mailing list
>cobalt-users@xxxxxxxxxxxxxxx
>To Subscribe or Unsubscribe, please go to:
>http://list.cobalt.com/mailman/listinfo/cobalt-users
>
>