mysql8搭建

mysql8搭建

• 拉取mysql

docker pull mysql

cd /usr/local/
mkdir docker
cd docker
mkdir mysql
cd mysql
vi docker-compose.yml

• docker-composer.yml内容如下：

version: '3.1'
services:
    mysql:
        image: mysql
        restart: always
        environment:
            TZ: Asia/Shanghai
            MYSQL_ROOT_PASSWORD: Qas919293
        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
            --max_allowed_packet=128M;
        ports:
            - 3306:3306
        volumes:
            - ./data:/var/lib/mysql
            - ./conf:/etc/mysql/conf.d

• 运行docker-compose.yml

docker-compose -f docker-compose.yml up -d

• 进入mysql容器

docker exec -it mysql bash   #进入容器

mysql -uroot -pQas919293    #进入mysql