Why are you creating a database and then deleting it again? If you delete/drop a database then it's gone and you are starting again. In which case, the command you mentioned is correct. The reason for all the options is that if you don't do that you get your server defaults. This worked for you - *this time* - but is basically undefined. Use the options.