469,939 Members | 2,344 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,939 developers. It's quick & easy.

Same database name

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.

Oct 27 '06 #1
3 2996
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.
Oct 30 '06 #2
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.
Oct 30 '06 #3
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
---------------------------------------------------------------
Oct 30 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andy Visniewski | last post: by
2 posts views Thread by =?Utf-8?B?Tkg=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.