Florian Lindner wrote:
> Hallo,
> I use phpMyAdmin (most recent version) to adminstrate an MySQL 5.0
> server.
>
> I have created an user wuhr who permission for the DB wuhr\_%:
> SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
> TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER
> ROUTINE, EXECUTE
>
> Now I'm suprised that the user is permitted to create new databases.
> CREATE gives according to phpMyAdmin the permission to create tables
> and DBs. Now I want to the user to be able to create tables but not
> DBs.
>
> How can I do that?
>
> Thanks,
>
> Florian

Set the user's scope to be a particular database (or set of databases).