: 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.
Instead, allow users to create database through a gateway, such as CGI or some PHP application. Thus you will not have to do "GRANT ALL ON *.*". CGI aplication will connect to mysql server with a specific account priveleged only to CREATE accounts and will create requested database and grants permissions accordingly. sherzod --------------------------------------------------------------------- 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