mysql -e 'CREATE DATABASE mydb CHARACTER SET utf8mb4;'
Create a database with full Unicode support
utf8mb4 is the full-Unicode character set that stores emoji and any script; the older utf8 only covers a subset. Add COLLATE to choose sort rules. Related: SHOW DATABASES to confirm.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.