create database privileges

create database privileges

am 26.05.2006 10:46:21 von David Meier

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.

Re: create database privileges

am 26.05.2006 16:58:49 von Aggro

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.