1. 执行命令装置mysql

    docker run -d --privileged=true \--restart=always \--name mysql \-v /usr/local/mysql/data:/var/lib/mysql \-v /usr/local/mysql/conf:/etc/mysql \-v /usr/local/mysql/log:/var/log/mysql \-p 8306:3306 \-e TZ=Asia/Shanghai \-e MYSQL_ROOT_PASSWORD=123456 \mysql:5.6 \--character-set-server=utf8mb4 \--collation-server=utf8mb4_general_ci
    装置mysql5.7会报错
  2. 进入mysql容器,登录mysql

    docker exec -it mysql bashmysql -u root -p 123456
  3. 批改root明码,并容许近程登录

    set password for [email protected] = password('新密码');set password for [email protected]'%' = password('新密码');GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '新密码' WITH GRANT OPTION;
    装置结束