Same database name

[javier.ortega]

hello,

We are running mysql 4.1.18

Is there a way to prevent users from creating the same database name?
for example
our name schema goes like: mysql_1234, mysql_32143, mysql_....
But we found out that some one could create MYSQL_1234 while mysql_1234
already exists.
I guess what we need to know is that if there is away for mysql to not
allow same names even though its different case characters.

thanks,
Javier.

[lark]

the case insensitive directive is in your .cnf or .ini file. change it
so that it wouldn't matter to the server whether it's upper or lower case.

ja***********@gmail.com wrote:

hello,

We are running mysql 4.1.18

Is there a way to prevent users from creating the same database name?
for example
our name schema goes like: mysql_1234, mysql_32143, mysql_....
But we found out that some one could create MYSQL_1234 while mysql_1234
already exists.
I guess what we need to know is that if there is away for mysql to not
allow same names even though its different case characters.

thanks,
Javier.

[javier.ortega]

Hey lark,

I guess what I'm trying to say, is that I want to know if its possible
to prevent same name databases.

lark wrote:

the case insensitive directive is in your .cnf or .ini file. change it
so that it wouldn't matter to the server whether it's upper or lower case.

ja***********@gmail.com wrote:

hello,

We are running mysql 4.1.18

Is there a way to prevent users from creating the same database name?
for example
our name schema goes like: mysql_1234, mysql_32143, mysql_....
But we found out that some one could create MYSQL_1234 while mysql_1234
already exists.
I guess what we need to know is that if there is away for mysql to not
allow same names even though its different case characters.

thanks,
Javier.

[Jeff North]

On 30 Oct 2006 09:59:46 -0800, in mailing.database.mysql
ja***********@gmail.com
<11**********************@b28g2000cwb.googlegroups .comwrote:

>| Hey lark,
|
| I guess what I'm trying to say, is that I want to know if its possible
| to prevent same name databases.

SHOW DATABASES [LIKE 'pattern']

>| lark wrote:
| the case insensitive directive is in your .cnf or .ini file. change it
| so that it wouldn't matter to the server whether it's upper or lower case.
| >
| ja***********@gmail.com wrote:
| hello,
|
| We are running mysql 4.1.18
|
| Is there a way to prevent users from creating the same database name?
| for example
| our name schema goes like: mysql_1234, mysql_32143, mysql_....
| But we found out that some one could create MYSQL_1234 while mysql_1234
| already exists.
| I guess what we need to know is that if there is away for mysql to not
| allow same names even though its different case characters.
|
| thanks,
| Javier.
|

---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------