re: Making MySQL ignore non-database directories in datadir

2003-03-21 Thread Victoria Reznichenko 
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

Making MySQL ignore non-database directories in datadir

2003-03-20 Thread John Hardin 
All:

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.)

-- 
John Hardin  KA7OHZ   [EMAIL PROTECTED]
Internal Systems Administratorvoice: (425) 672-1304
Apropos Retail Management Systems, Inc. fax: (425) 672-0192
---
 To disable the Internet to save EMI and Disney is the moral
  equivalent of burning down the library of Alexandria to ensure the
  livelihood of monastic scribes.
-- John Ippolito of the Guggenheim
---
 63 days until The Matrix Reloaded


-
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