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 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. I only
> want to add a new user of a developer level. Anyone can help
> me out for this question.
>
> Thanks in advance for all reply!
>
> Alex
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
=====
---
Stefan Hinz <[EMAIL PROTECTED]>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: +49 30 46307-382 Mobil: +49 177 7841069
Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]>
BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN!
---
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---------------------------------------------------------------------
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
