create database privileges

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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

David Meier wrote:

Quoted text here. Click to load it

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.

Site Timeline