grant privileges for users....

[dino]

I have to grant privileges for users to use databases that start from spm only. So I used the following syntax:

grant all on `spm%`.* to username@'%' identified by 'password';

This works fine. Now I log in as the user and create a database named spmtest. After that if I try to use the database spmtest it gives access denied errors.
For ex:

mysql> create database spmtest2;
Query OK, 1 row affected (0.00 sec)

mysql> use database spmtest2;
ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'database'

Can anyone tell me how can we allow users to create databases and then have full rights to the databases they create. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[xena]

Originally Posted by dino

mysql> use database spmtest2;
ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'database'

Look at that error very carefully, you've made a very simple mistake in your statement.

Aside from that, I'm quite surprised that granting ALL privileges to a wildcard database name allowed you to CREATE any database within that name parameter. Scary. I would assume it also gives you blanket DROP privs as well? Might want to rethink your policy... -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --