Hey there!
Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic privileges for just such. However, he is asking for privileges to be able to use CHECK, ANALYZE, and REPAIR table. He has privileges for OPTIMIZE. So I'm not sure how to grant him these privileges, or whether that would open a big security whole in MySQL if I did. I've checked the manual, but it is rather unspecific about these things. In fact, I couldn't find what References_priv represented privileges for either, so maybe that is it? Thanks for any and all help! -Mike [EMAIL PROTECTED] --------------------------------------------------------------------- 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
