Pada Wed, 24 Jul 2002 18:52:44 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> I have an existing mysql user that I wish to add the INDEX privilege. Is
> there a command that I can use to add a privilege without first deleting the
> user and then recreating with the GRANT command?
you can run :
grant <privilege> on <db>.<table> to <username>@<host>;
flush privileges;
it will add/update new privilege for user;
or you can edit the values on DB mysql ... with table user or db ;-)
--
"Who is General Failure and why is he reading my hard disk?"
Microsoft spel chekar vor sail, worgs grate !!
-- Felix von Leitner, [EMAIL PROTECTED]
MySQL 3.23.51 : up 33 days, Queries : 353.598 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
