Pada Mon, 29 Jul 2002 11:47:30 +0200
KSausW <[EMAIL PROTECTED]> menulis :

> How can I grant a privilege to a specified user to a specific DB?
> If I grant
>     Host="%"
>     User="joe"
> in the user table, "joe" can access a l l  DBs on the server - even the 
> "mysql"-DB.

grant <set_of_privileges> on <db>.<table> to <user>@<host> identified by "<password>";


-- 
printk("??? No FDIV bug? Lucky you...\n");
        2.2.16 /usr/src/linux/include/asm-i386/bugs.h
 
MySQL 3.23.51 : up 38 days, Queries : 353.795 per second (avg).

--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.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

Reply via email to