[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] (no subject)



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