At 9:05 +1000 9/24/02, vinita vigine Murugiah wrote: >HI Egor > OK, I want to create new databases, to do that I need database >create privilege. > >Grant CREATE ON ###### >to ddb@localhost IDENTIFIED BY 'passwd' > >What should go into #####, is it a *? but I should NOT given >permission to access other databases.
No, it should be db_name.* >Thanks > >Egor Egorov wrote: > >>vinita, >>Monday, September 23, 2002, 9:12:24 AM, you wrote: >> >>vvM> I can create a database called test, >>vvM> mysql> create database test; >>vvM> Query OK, 1 row affected (0.03 sec) >> >>vvM> BUT I can't create any other databases??? >> >>vvM> mysql> create database tem; >>vvM> ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem' >> >>vvM> mysql> create database proj; >>vvM> ERROR 1044: Access denied for user: 'ddb@localhost' to database 'proj' >> >>Seems user 'ddb' or anonymous user has privileges only on the database >>'test'. --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php