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?
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.