Skip to content

Instantly share code, notes, and snippets.

@kirmorozov
Last active September 29, 2020 05:14
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 kirmorozov/dbe69e022a7db59ace5bf97a409b70e2 to your computer and use it in GitHub Desktop.
Save kirmorozov/dbe69e022a7db59ace5bf97a409b70e2 to your computer and use it in GitHub Desktop.
run locally mysql 8 with mysql_native_password authentication.
docker run -d --name mysql8 \
-p 3306:3306 -p 33060:33060 \
-e MYSQL_ROOT_PASSWORD=123123qa \
--restart always mysql \
/entrypoint.sh mysqld --default-authentication-plugin=mysql_native_password \
--connect-timeout=31536000 \
--wait-timeout=31536000 \
--lock-wait-timeout=31536000 \
--character-set-server=utf8 \
--collation-server=utf8_general_ci \
--thread-cache-size=100 \
--table-open-cache=10000 \
--innodb-buffer-pool-size=12G \
--innodb-flush-method=O_DIRECT \
--innodb-flush-log-at-trx-commit=2 \
--innodb-log-file-size=512M \
--max-allowed-packet=512M \
--disable-log-bin \
--general_log=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment