thank you victoria! -----Original Message----- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Friday, November 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: re: mysql permissions
Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a user (besides root) that can show databases, Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases if mysqld is running without --skip-show-database option. SS> show tables SS> from every database, User can't see tables if he doesn't have any rights on them. SS> lock all tables, There is Lock_tables_priv since 4.0.2, before 4.0.2 user must have SELECT, UPDATE, DELETE, INSERT to lock tables. SS> and flush all tables. You need RELOAD_priv. SS> what permissions SS> should i grant to this user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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 --------------------------------------------------------------------- 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