Drupal 10: SQL To Create The Drupal Database

Run the following SQL to create the Drupal database.

CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

It isn't possible to run this through Drush since Drush will attempt to connect to the database, which won't exist.

You will need to either log into the MySQL client and run the command, or pass the command to MySQL like this.

mysql -u user -p -h localhost -e "CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";

This will prompt you for the database password.