Users creating databases

Two MySQL servers appear to be configured the same. One allows users to
create new databases; the other doesn't (and neither should).

On both servers, the mysql.User table shows only root as having the
Create_priv column yet to Y.

Any ideas on what settings I should look at?

--
Christoph Burschka
Math.-Techn. Assistent i.A.

RWTH Aachen
Rechen- und Kommunikationszentrum
Dienstgebäude Seffenter Weg 23
52074 Aachen

Tel: +49 (241) 80-20376
Fax: +49 (241) 80-29100

== Quote from Christoph Burschka (christoph.burschka@rwth-aachen.de)'s article
> Two MySQL servers appear to be configured the same. One allows users to
> create new databases; the other doesn't (and neither should).
> On both servers, the mysql.User table shows only root as having the
> Create_priv column yet to Y.
> Any ideas on what settings I should look at?

you also need to look at super_priv!
--
POST BY: lark with PHP News Reader

lark schrieb:
> == Quote from Christoph Burschka (christoph.burschka@rwth-aachen.de)'s article
>
>>Two MySQL servers appear to be configured the same. One allows users to
>>create new databases; the other doesn't (and neither should).
>>On both servers, the mysql.User table shows only root as having the
>>Create_priv column yet to Y.
>>Any ideas on what settings I should look at?
>
>
> you also need to look at super_priv!
> --
> POST BY: lark with PHP News Reader

Thanks for your help!

However, this didn't turn up anything different: Both Create_priv and
Super_priv are only granted to the root user - on either server...

--
Christoph Burschka
Math.-Techn. Assistent i.A.

RWTH Aachen
Rechen- und Kommunikationszentrum
Dienstgebäude Seffenter Weg 23
52074 Aachen

Tel: +49 (241) 80-20376
Fax: +49 (241) 80-29100