jacurtis/mysql-cli.sql

Created January 26, 2019 02:04

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jacurtis/385f776c8cb44798e1a2477c04b61941.js"></script>
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