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