made it possible for openstack_citest MySQL user to create new
databases in tests on demand (which is very useful for parallel
running of tests on MySQL and PostgreSQL, thank you, guys!).
Unfortunately, openstack_citest user can only create tables in the
created databases, but not to perform SELECT/UPDATE/INSERT queries.
Please see the bug  filed by Joshua Harlow.
In PostgreSQL the user who creates a database, becomes the owner of
the database (and can do everything within this database), and in
MySQL we have to GRANT those privileges explicitly. But
openstack_citest doesn't have the permission to do GRANT (even on its
I think, we could overcome this issue by doing something like this
while provisioning a node:
GRANT ALL on
and then create databases giving them names starting with the prefix value.
Is it an acceptable solution? Or am I missing something?