MySQL Bugs: #29004: in 'SHOW DATABASES' a database named DATABASE shows up

Bug #29004	in 'SHOW DATABASES' a database named DATABASE shows up
Submitted:	9 Jun 2007 3:35	Modified:	9 Jun 2007 3:40
Reporter:	Ace Suares	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Linux (ubuntu-server (dapper))
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
In /var/lib/mysql there is a directory called DATABASE and it's contents is a file called 'db.opt'.

However, when using the SHOW DATABASES command, this shows up as a database.

So if you had 3 databases in /var/lib/mysql, your  SHOW command would show:

| adatabase   |
| cdatabase   |
| DATABASE    |
| pdatabase   |

How to repeat:
Issue 'SHOW DATABASES' from the mysql command line

Blush... this happened because of the following command:

mysqladmin CREATE DATABASE

(I forgot to replace the DATABASE by a real database name, so it created a database called DATABASE....)

Sorry. I now just did

mysqladmin drop DATABASE

and it's gone.