List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 23 2002 11:14pm
Subject:Re: mysqlimport
View as plain text  
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'.

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