if i could add to this question a bit:
what are the steps in adding a user that will have access to only one database?
i've tried using both:
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON uview.* TO user@% IDENTIFIED BY
"password"; (then did a FLUSH PRIVILEGES)
and i've tried adding directly yo the users database:
NSERT INTO user
VALUES('localhost','USERNAME',PASSWORD('some_pass'),'SELECT','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
but i can't seem to get things to work. i've looked over the manual and a small
tutorial.
are there some steps i'm missing?
thanks.
jason upton
6/20/2002 4:30:47 PM, "Emma Grant" <[EMAIL PROTECTED]> wrote:
>Hi, I am just starting out with mysql.
>
>MySQL allows anon access so I don't have to log on to the sql just the
>linu server.
>
>I am trying to create a test database 'test2'. I am logged on as my user
>'emil' (not root) on a test linux server. When I go to create the
>database:
>
>mySQL> CREATE DATABASE test2;
>
>It gives me the following error.
>
>Error: 1044: Access denied for user '@localhost' for database test2
>
>I then log in as root and change my privelages:
>
>mySQL> GRANT ALL ON test2.* for emil;
>
>But still I get the same error when I try to create it.
>
>In fact, I can't get on to a database even if the root creates it and
>then I GRANT the user 'emil' ALL to the newly created database.
>
>Can someone direct me in the right place?
>
>Thanks,
>
>Emma
>
>
>
>---------------------------------------------------------------------
>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 <[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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
