Skip to content

Instantly share code, notes, and snippets.

@jacurtis
Created January 26, 2019 02:04
Show Gist options
  • Save jacurtis/385f776c8cb44798e1a2477c04b61941 to your computer and use it in GitHub Desktop.
Save jacurtis/385f776c8cb44798e1a2477c04b61941 to your computer and use it in GitHub Desktop.
This is the command I use to create all of my new MySQL databases in the CLI. Insert your own database name. This sets up new databases using the utf8mb4 character set in the most popular method.
CREATE DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment