[ale] [OT] MySQL privileges question.....

[Keith Morris]

Hi all.

I'm trying to create mysql users who have near root privileges:
SELECT,INSERT, UPDATE,DELETE, CREATE, DROP, INDEX, ALTER, REFERENCES,
SHOW DATABASES

The problem is, I want to give them these privileges ONLY on the
databases that they create, not any other's databases and I want this to
happen automatically so I don't have to police the databases and be
setting permissions all the time.

When I explicity deny the user priviliges in the mysql.db table, and run
the flush privileges command....no effect.  It seems as if the
mysql.user privileges are overriding the mysql.db privilegs... is this
right?

I've been trying to find reference to anything about database ownership
in MySQL but have not had much luck.

I would appreciate any information you might have.

Thanks in advance.

Keith Morris