Hi MySQL Powerusers,

I was wondering if there is a way to prevent useres from creating
databases. The scenario is for a web hosting environment where I would
like to let users only use their pre-defined database and not be able
to create any additional database (e.g. via phpmyadmin).

Thanks, Dave.

David Meier wrote:

> I was wondering if there is a way to prevent useres from creating
> databases.

Users don't have permission to create databases by default, except the
root user. So you don't need to prevent anything, just don't give them
permission to do that.