Paul DuBois wrote:
> 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.
HI sorry for the confusion.
well...... I want to create a database where I can give *any* name
(ofcourse, the database doesn't exist).
Are you trying to say, I need to ask the root, to give me create
privilege on database "xxx", even before it exist, then only I can
create the database "xxx". Then every time when I want to create a new
database, I need to ask the root to give create privilege ???
thanks
>
>> 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
>
>
>
---------------------------------------------------------------------
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