Renaming Database, Get Error "#1044 - Access denied"

[Sparhawk]

I am simply trying to rename one of my databases using OPS.
After accessing the database in OPS, I click on "Operations", enter the new name in the "Rename database to:" field, and click "Go".

I get the error message:
#1044 - Access denied for user 'sparhawk'@'10.%' to database 'familysites'

And the rename doesn't occur.
What would cause this, and how do I fix it?

[IanS]

This could be a side effect of upgrade and re-mapping of the actual location of the database. Contact support and include the screenshot. They'll probably tell you 'how' to do this, with the method you've used. If that happens get back in touch with them immediately.

[HalfaBee]

It doesn't work because renaming a DB is effectively creating a DB, copying the contents and deleting the old DB.
We cannot CREATE DB's.

[Sparhawk]

You're right, it looks like mysqladmin won't allow me to create a new database.

However, I got it to work by doing the following:
* I created a new database in OPS
* Used mysqladmin to copy the data & structure to the new database
* Went back to OPS to delete ("drop") the original database.

Now I have a new database with the correct name, with the data & structure from the old one.