2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: > 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
