e.g. for some user k, I want them to be able to have complete access to any database named k_*.
I know this can be done. The test database is setup this way by default.
Here is what I tried:
grant all on k_*.* to 'user'@'somedomain' identified by 'somepassword'
It replies with an 'you have an error in you SQL syntax somewhere.'
However, I can do this:
grant all on k_db.* to 'user'@'somedomain' identified by 'somepassword' update db set db = 'k\_%' where user = 'user'
This is how the test database looked in the mysql.db table, so I mirrored it. And that works.
But, can this be done in a grant statement? I was fairly sure I did this before, but this is a new installation and it doesn't work.
I've tried variations of the *. I tried k_%.* k_%, "k\_%.*", etc. None of these work.
I have looked in the mysql manual in the user creation section, but I haven't found anything similar to what I'm trying to do. The grant/revoke syntax also tells nothing. It just says db_name.* if you want to grant privileges on a database.
My mysql version is 4.0.18.
Thanks,
John Ratliff
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
