1 Topic by Enemy

  • From: Moldova, Rep. of
  • Registered: 2006-09-11
  • Posts: 34

Topic: MySQL user privileges

Hi, it's me again, trying to get my head around MySQL, with great help of you all, of course :)

I've created MySQL user in PHPMyAdmin and I want to grant him ALL privileges (including creating new databases) EXCEPT modifying and reading one special database.

In other words, smth like that:

 
GRANT ALL PRIVILEGES ON * . * !exceptionDB TO 'user'@ 'localhost' WITH GRANT OPTION ...;

Please, help me with right syntax.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: MySQL user privileges

I don't think there's a query to do that (at best, you would have to do multiple queries).
I think the best you could do would be to grant all on all databases and then grant certain privileges on the global level (eg: create database). The issue then would be when another user creates a database, you wouldn't have access to it