sslug-teknik team mailing list archive

["Steen Jakobsen" <Sjakob@xxxxxxxxxxxx>]

----- Oprindelig meddelelse -----
Fra: "Troels Arvin" <troels@xxxxxxxx>
Nyhedsgrupper: sslug.teknik
Til: <sslug-teknik@xxxxxxxx>
Sendt: 31. december 2000 16:52
Emne: Re: [TEKNIK] MySQL


> Kristian Engh Lundgreen wrote:
>
> > Hvordan opretter man brugere i MySQL ??
>
> Som MySQL's "root"-bruger, i MySQL's command-line shell:
>
> grant select,insert,update,delete
> on databasenavn.*
> to brugernavn@localhost
> identified by 'some_password';
>
> Intet behov for genstart af MySQL eller lign.
>
> /Troels
>
sådan(kap 6.13 i mysql manual):

mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
           IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
           IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

- steen