OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: user permissions to all DB

From: solidzh (solidzhgmail.com)
Date: Mon Aug 20 2007 - 21:51:25 CDT

2007/8/21, Jay Pipes <jaymysql.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'; ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql