innbitcodes/MySQL: Create DB in UTF8

Last active October 12, 2017 21:20

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/innbitcodes/4012269.js"></script>
Save innbitcodes/4012269 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL: Create Database in UTF8

Raw

MySQL: Create DB in UTF8

	CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

	GRANT ALL ON dbname.* TO 'dbuser' IDENTIFIED BY 'dbpassword';

	flush privileges;

aradnom commented Oct 12, 2017

Thanks. Totally had a "but what was the bit to set the encoding" brain fart moment.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment