I got the same error and it is really easy to come out of this, here is the solution below:
Just type the below command on your shell:
mysql -u root
Then rewrite the command to create a database, your error will go off.
I hope this works for you.