Create a New Database for WordPress/Laravel Using MySQL Query

Every database has a character set and a collation. For WordPress and Laravel, it is recommended that the Character Set be set to utf8mb4 and the Collation utf8mb4_unicode_ci. You can use the MySQL query below to create a new database with the recommended character set and collation for WordPress/Laravel.

CREATE DATABASE new_db_name DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

References:

• Recommended character set for WordPress
• Recommended character set for Laravel