MySQL

docker-compose.yml

version: '3.1'
services:
  mysql:
    image: mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: root
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
    ports:
      - 3306:3306
    volumes:
      - ./data:/var/lib/mysql

注意

1.查看日志
docker logs -f -t --tail 容器Id
2..进入容器
docker exec -it 94bd3fe89001 /bin/bash
3.登录mysql
mysql -u root -p
4.重新登陆
docker attach 容器Id
5.注意最新版mysql容器需要修改密码加密规则，不然连接的navcat会报错
update user set host = '%' where user = 'root';
select host, user from user;