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.
Any suggestions? Thank you. -Kevin Zembower ----- E. Kevin Zembower Unix Administrator Johns Hopkins University/Center for Communications Programs 111 Market Place, Suite 310 Baltimore, MD 21202 410-659-6139 --------------------------------------------------------------------- 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
