Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save Eduard-gan/6589af54ab7ec4082a7872b06490d3eb to your computer and use it in GitHub Desktop.
Save Eduard-gan/6589af54ab7ec4082a7872b06490d3eb to your computer and use it in GitHub Desktop.
MySQL Chore
docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
# Show active connections
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
# Show some shit;
show processlist;
# Create Database with PROPPER unicode encoding
create database animarender 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