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.
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@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.
>
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@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.
> >
On 30 Oct 2006 09:59:46 -0800, in mailing.database.mysql
javier.ortega@gmail.com
<1162231186.335572.144010@b28g2000cwb.googlegroups.com> wrote:
>| 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@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.
>| > >
------------------------------------------------------------ ---
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
------------------------------------------------------------ ---