PHWinfo - Afficher un message

21/08/2007, 03h51

2007/8/21, Jay Pipes <jay@mysql.com>:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everytime a new DB is added. Is there a way to do this?
>
> GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname'
> IDENTIFIED BY 'password';
>

That's well but why not,
grant all on *.* to 'user'@'host' identified by 'pwd'; ?

21/08/2007, 03h51	#8
solidzh Messages: n/a Hébergeur:	Re: user permissions to all DB 2007/8/21, Jay Pipes <jay@mysql.com>: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid having to modify > > permissions everytime a new DB is added. Is there a way to do this? > > GRANT SELECT, INSERT, CREATE, ... ON . TO 'username'@'hostname' > IDENTIFIED BY 'password'; > That's well but why not, grant all on . to 'user'@'host' identified by 'pwd'; ?