docker-mysql

发布 2021-03-15
更新 2021-03-15
阅读

next hexonext butterfly volantis yearn yilia shoka indigo apollo landscape cactus matery icarus fluid material

mysql安装

可以酌情修改内存大小和交换内存大小。

# filename: $HOME/data/mysql/conf/docker.cnf
[mysqld]
performance_schema_max_table_instances=400
table_definition_cache=400
table_open_cache=256
performance_schema = off
skip-host-cache
skip-name-resolve

docker run \
  --cpus 0.2 \
  -d -e MYSQL_ROOT_PASSWORD=123456 \
  --name mysql \
  -v $HOME/data/mysql/data:/var/lib/mysql \
  -v $HOME/data/mysql/conf:/etc/mysql/conf.d \
  -p 3306:3306 \
  mysql

允许远程登录

1
2
3

docker exec -it mysql bash
mysql -u root -p123456
ALTER USER 'root'@'%' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY '123456';

感谢您的阅读。 🙏 关于转载请看这里