Follow Us
Contribute
  • Register

ERROR 1007 (HY000): Can't create database (dbName); database exists

0 votes

This error message is seen in MySQL when the database we want to create, already exists in MySQL server.


requested 1 year ago by errorbase (169,970 points)

1 Solution

0 votes

The problem can be solved by either changing the database name in our "CREATE DATABASE" command or dropping the old database. You can drop a database by "DROP DATABASE" command.


mysql> DROP DATABASE (DatabaseName);

solved 1 year ago by errorbase (169,970 points)

Related errors

0 votes
1 solution
0 votes
1 solution
requested 1 year ago by errorbase (169,970 points)
+1 vote
1 solution
requested 1 year ago by errorbase (169,970 points)
0 votes
1 solution
+1 vote
1 solution