List:General Discussion« Previous MessageNext Message »
From:vinita vigine Murugiah Date:September 23 2002 11:41pm
Subject:Re: mysqlimport
View as plain text  
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 <mysql-thread120358@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