[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] (no subject)
- Subject: Re: [cobalt-users] (no subject)
- From: "Daniel Foster" <daniel@xxxxxxxx>
- Date: Thu Nov 30 15:17:01 2000
- List-id: Mailing list for users to share thoughts on Cobalt products. <cobalt-users.list.cobalt.com>
> > Does anyone know the commands to grant privileges on a database
for MySQL?
>
> Here ya go
>
> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
Whoah there! That'll give monty full privileges to all databases!
For a slightly safer method, replace the *.* above with
database_name.* to grant monty privileges on a single database
(database_name)
--
No one will ever win the battle of the sexes; there's too much
fraternizing with the enemy. - Henry Kissinger
Daniel Foster - daniel@xxxxxxxx