create database dbname; to create database.
but I want it to created with Character set UTF-8
Anyone know what is the command to use?
option when creating your database, like so:
also, read the docs...
If database name contains nonalphanumeric chars use "`" to quote:
When using in shell script quote the quotes with "\"