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'.
