Kevin, > Is there a safe way to allow ordinary users, who should not have MySQL root >privileges, to create databases using any name they choose? It seems to me that I >would need to use "GRANT ALL ON *.* TO > user WITH GRANT OPTION". This would be dangerous because of the other user's >databases and the mysql database itself. All the reference books I have talk about >the GRANT CREATE privilege with > regard to tables, not databases.
mysql> GRANT create ON *.* TO 'creator'@'localhost'; 'creator' can CREATE databases and tables within existing (and self-created) databases, nothing else. I don't know if that's what you really want. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
