distal-attribute
distal-attribute
distal-attribute
distal-attribute

Database cannot be deleted -- SQL Error 1049: Unknown database

WaveLength posted 2 years ago in General
When I go to localhost, a database called test1 is listed in the left panel. I want to drop it, but when I click on it, I get this error message:

SQL Error (1049): Unknown database test1

If I run

drop database test1

then I get error 1008 ("database doesn't exist")

I have several of these fantom databases, and I'd like to delete them. Is there any way to do that?

Thanks.


ansgar posted 2 years ago
Do these databases show up in a SHOW DATABASES query result?
WaveLength posted 2 years ago
No, they do not appear after a SHOW DATABASES query.
WaveLength posted 2 years ago
I solved the problem, as follows:

Open the Session Manager, select localhost, choose an individual database from the Databases drop-down list, click save, click cancel, exit HeidiSQL, reopen HeidiSQL, select localhost, click Open. The phantom databases are gone.
ansgar posted 2 years ago
Very strange. Where do you think did they appear from?

Please login to leave a reply, or register at first.