View Single Post

  #3 (permalink)  
Old 10-26-2007
Florian Lindner
 
Posts: n/a
Default Re: Permission to create DB

Paul Lautman wrote:

> 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).


Sorry, I don't really can follow you. What's scope in this context?

Thanks for details,

Florian
Reply With Quote