Same database name

[javier.ortega@gmail.com]

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]

Re: Same database name

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.

javier.ortega@g mail.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@gmail.com]

Re: Same database name

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.
>
javier.ortega@g mail.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]

Re: Same database name

On 30 Oct 2006 09:59:46 -0800, in mailing.databas e.mysql
javier.ortega@g mail.com
<1162231186.335 572.144010@b28g 2000cwb.googleg roups.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.
>| >
>| javier.ortega@g mail.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.
>|

---------------------------------------------------------------
jnorthau@yourpa ntsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------