Skip to content

Instantly share code, notes, and snippets.

@jacurtis

jacurtis/mysql-cli.sql

Created January 26, 2019 02:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jacurtis/385f776c8cb44798e1a2477c04b61941 to your computer and use it in GitHub Desktop.
Save jacurtis/385f776c8cb44798e1a2477c04b61941 to your computer and use it in GitHub Desktop.
Download ZIP
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.
Raw
mysql-cli.sql
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