List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 24 2002 1:12am
Subject:Re: mysqlimport
View as plain text  
At 9:41 +1000 9/24/02, vinita vigine Murugiah wrote:
>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??

As far as I can tell, you're not making any sense:

- First you say you want to grant permission for a given database, and
   *NOT* to access other databases.
- Now you say you don't want to have to specify permissions for given
   databases.

You can't have it both ways.  Do you want permission for a specific
database, or for all databases?

If I am misinterpreting you, then please be more specific.

>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 <mysql-thread120358@stripped>
>>To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
>>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 <mysql-thread120362@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
mysqlimportvinita vigine Murugiah23 Sep
  • re: mysqlimportEgor Egorov23 Sep
    • Re: mysqlimportvinita vigine Murugiah24 Sep
      • Re: mysqlimportPaul DuBois24 Sep
    • Re: mysqlimportvinita vigine Murugiah24 Sep
      • Re: mysqlimportPaul DuBois24 Sep
    • Re: mysqlimportvinita vigine Murugiah24 Sep