Re[2]: [cobalt-users] (no subject)

[Mike Fritsch <moley187@xxxxxxxxxxxxx>]

Bill,

What is the difference between the command:
BG> GRANT ALL PRIVILEGES ON databasename.* TO username@localhost IDENTIFIED BY
BG> 'password'
BG> WITH GRANT OPTION;

and

BG> GRANT ALL PRIVILEGES ON databasename.* TO username@"%" IDENTIFIED BY
BG> 'password' WITH
BG> GRANT OPTION;

Also is there anyway to hide the databases that do not belong to the
user?


    Mike 

<--Previous messages can be found below-->
BG> /usr/bin/mysqladmin -u root password 'blablabla'
BG> mysqladmin -u root -p create databasename

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

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

BG> Bill

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

BG> _______________________________________________
BG> cobalt-users mailing list
BG> cobalt-users@xxxxxxxxxxxxxxx
BG> To Subscribe or Unsubscribe, please go to:
BG> http://list.cobalt.com/mailman/listinfo/cobalt-users