solidzh wrote:
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'; ?
Because then you give the user SUPER, FILE, ALTER, SHUTDOWN, and PROCESS
privileges, which probably isn't a good idea... :)
Cheers,
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]