Re: new user privileges

[Stefan Hinz]

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 <stonix@stripped> 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 <mysql-thread81451@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-hinz=js-webshop.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 


=====
---
Stefan Hinz <hinz@stripped>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: [phone]  Mobil: [phone]
Antwortadresse dieser E-Mail: <hinz_stefan@stripped>
BITTE NUR IN DRINGENDEN F---

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/