Unable to create new database

[phantom666]

Username: demon666

Domain: phantomtest.heliohost.org

Server: johnny

 

Hi,

 

I've recreated my account on johnny, and now I am in the process of setting up my databases.  However, I seem unable to create a database (demon666_contactdb) because it's says it already exists, but I can't seem to see this database anywhere.  If this database does indeed exist, I would like it removed.

 

Please can anyone assist?

 

Thanks in advance.

 

D

 

[rajdis]

You can check it by going into phpMyAdmin

[phantom666]

Hi,

 

When I go into phpMyAdmin, there only appears to be one database I created present (demon666_world), which would imply that the database demon666_contactdb does not exist.  When I go into MySQL Databases from cPanel, again, I can only see the database demon666_world present, but when I attempt to create a new database with the name of demon666_contactdb, I get an error message informing me that this database already exists, even though I cannot see it anywhere, so I am not sure why I am presented with this error.

 

Cheers,

 

D

[DmC]

What happens if you run the sql command from phpmyadmin:

 

DROP DATABASE demon666_contactdb;

[phantom666]

I get the following error message in phpmyadmin when attempting to run the above command:

 

Error

SQL query:

 

DROP DATABASE demon666_contactdb

 

MySQL said: 

"DROP DATABASE" statements are disabled.

[phantom666]

Apologies for sounding impatient, but can someone offer any assistance to the issue I have described above?

 

In short, I am unable to create a new database because apparently it already exists, however, I can't seem to see this database anywhere, and I am unable to manually run any commands to force a deletion.

 

Any assistance will be greatly appreciated.  Thanks in advance.

 

Cheers,

 

D

[wolstech]

Best bet is to just use a different database name.

 

The one you're having issues with won't drop for me either, so it's probably half-created and corrupt.

[phantom666]

Looks like I'm going to have to create the database using a different name, which means updating my any scripts with the new name accordingly

 

Anyway, thanks to everyone for their assistance.