Dear Alex,
> to add a new user with full privileges on only 'abcdb'. How
I assume "abcdb" is a database, not a table. Try this:
GRANT ALL ON abcdb.* TO "newuser"@"localhost" IDENTIFIED BY "pw"
Regards,
--- Stonix <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm new in mysql admin. I have question
Hi,
I'm new in mysql admin. I have question on create new user.
Suppose I have created a database called 'abcdb'. Now I want
to add a new user with full privileges on only 'abcdb'. How
should I do? I tried 'grant all privileges on abcdb.*'
but still the new user has the superuser privileges.