Bug #76860 Database creation with name "database"
Submitted: 28 Apr 2015 7:13 Modified: 28 Apr 2015 7:40
Reporter: Safder Qasim Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.5 OS:Linux (Ubuntu 3.2.0)
Assigned to: CPU Architecture:Any
Tags: bug with name database, Database name

[28 Apr 2015 7:13] Safder Qasim
I had mistakenly created database with the name "database" but when I trying to drop this database its giving me following error :
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1

How to repeat:
mysqladmin -u root -p'password' create database

drop database database;
[28 Apr 2015 7:40] Umesh Shastry
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Please use back tick character (`), please reference manual page - https://dev.mysql.com/doc/refman/5.5/en/identifiers.html

mysql> create database `database`;
Query OK, 1 row affected (0.00 sec)

Thank you for your interest in MySQL.