On Thursday 20 March 2003 22:42, John Hardin wrote: > It would be really nice if there were some way (a variable) to make > MySQL totally ignore certain directories in the datadir - for example, > "lost+found", "RCS", and suchlike. > > The listed dirs should not show up in SHOW DATABASES and you should not > be able to CREATE a database with a name that's on the list. > > (Sorry if this has come up before and been hashed to death. Google > couldn't find much on this subject.)
First of all it's not a good idea to put non-database directory to the datadir. Second, if the user doesn't have SHOW DATABASE privilege or doesn't have privileges on the database at all, he can't see database in the SHOW DATABASE output. Third, you can't forbid creating databases with certain names on the MySQL server level. -- 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
