Problem trying to rename a DB

[billyrad]

I haven't had anyy major problems with MySQL or phpMyAdmin in the past until lately. The latest one is minor....

I logged in to ops and clicked on the DB 'administrate' link like usual, bringing me to phpMyAdmin and tried to rename a database (not being used) and got this error..

Error
SQL query:

CREATE DATABASE `spineinfo_dewlinks` ;

MySQL said:

#1044 - Access denied for user 'spineinfo'@'10.%' to database 'spineinfo_dewlinks'

Any ideas?

I might just switch over to www.mysqlquickadmin.com instead of phpMyAdmin as Halfabee suggested.

[HalfaBee]

You can't rename a DB.
You have to export the DB, create a new one in ops and import the data.

[billyrad]

Thanks for the quick response. Yeah, that's how I've done it before, but then found the opttion to rename. Why would phpMyAdmin give you the option to do so then?
.

[HalfaBee]

Because it assumes you have "CREATE" priveleges, and at Powweb you don't.