docker安装mysql

1 安装docker.io

2 安装docker-compose

3 配置docker-compose.yml

version: '3'
services:
  #服务名称
  mysql:
   #容器名称
   container_name: mysql-5.7.30
   #镜像名称
   image: mysql:5.7.30
   #自动启动
   restart: always
   #端口映射
   ports:
     - "23306:3306"
   #环境变量
   environment:
     - MYSQL_ROOT_PASSWORD=root-password
     - MYSQL_USER=user
     - MYSQL_PASS=password
   #挂载
   volumes:
     - /home/ubuntu/docker-iamges/mysql-5.7.30/conf.d:/etc/mysql/conf.d
     - /home/ubuntu/docker-iamges/mysql-5.7.30/logs:/logs
     - /home/ubuntu/docker-iamges/mysql-5.7.30/data:/var/lib/mysql

4 启动容器

docker-compose up -d

5 进入容器

docker exec -it mysql-5.7.30 bash

6 配置普通用户

create user user identified by 'password';

#grant privilegesCode on dbName.tableName to username@host identified by "password";
grant all privileges on testdb.* to user@'%' identified by 'password';
flush privileges;
show grants for 'halo';

#修改密码
update mysql.user set password = password('password') where user = 'user' and host = '%';
flush privileges;