Hi paul Paul DuBois wrote:
> 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.* Then I can ONLY create database called "db_name", then every time when I create a database, I have to ask the root to give me create permission on xxx database. This is inconvenient. Is there any other work around?? Thanks > > >> 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 > > --------------------------------------------------------------------- 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