MySQL: “CREATE DATABASE mydb” command hangs [closed]

Posted on

Question :

On my MySQL 5.6 server, when logged in as root, the command CREATE DATABASE hangs. No error message – nothing. The MySQL error log doesn’t show anything special either.

What could I look into to troubleshoot the problem?

Answer :

A short time afterwards I noticed the database was created, and further commands CREATE DATABASE succeeded. Most likely, the issue was caused by a database lock that was eventually released later.

Leave a Reply

Your email address will not be published. Required fields are marked *