<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                #### 1. 前提是Docker已經安裝好了 > 沒有安裝的可以看這篇文章-->[# centos7安裝docker](http://kanclouds.roes.top/linux/1592928) #### 2.拉取mysql鏡像 ```shell docker pull mysql:5.7 docker images ``` * 宿主機創建幾個文件夾用于容器文件掛載 ```shell mkdir -p /home/service/mysql/data mkdir -p /home/service/mysql/conf/my.cnf ``` 在my.cnf追加如下數據 ``` [mysqld] user=mysql character-set-server=utf8 default_authentication_plugin=mysql_native_password default-time_zone = '+8:00' [client] default-character-set=utf8 [mysql] default-character-set=utf8 ``` * 然后運行命令啟動mysql ``` docker run -p 3306:3306 --name mysql \ -v /home/service/mysql/data:/var/lib/mysql \ -v /home/service/mysql/conf/my.cnf:/etc/my.cnf \ -e MYSQL_ROOT_PASSWORD=123456\ -e TZ=Asia/Shanghai \ -d mysql ``` ``` docker run -p 3306:3306 --name mysql -v /home/service/mysql/logs:/logs -v /home/service/mysql/data:/mysql_data -e MYSQL_ROOT_PASSWORD=123456 -d mysql ``` > 命令講解 > ```-p``` 3306:3306:將容器的3306端口映射到主機的3306端口 > ```-e``` MYSQL_ROOT_PASSWORD=123456:初始化root用戶的密碼 > ```-e``` TZ=Asia/Shanghai 修改容器默認時區為上海 > ```-v```=/mysqltest/config/my.cnf:/etc/my.cnf:映射配置文件 > ```-v```=/mysqltest/data:/var/lib/mysql:映射數據目錄 注意:不同mysql版本可能配置文件目錄和路徑不一樣,mysql5.7的容器路徑為 /etc/mysql/mysql.conf.d/mysqld.cnf。 * 進入容器 ```shell docker exec -it mysql bash ``` * 登陸mysql ```shell mysql -uroot -p ``` ![image.png](https://upload-images.jianshu.io/upload_images/7100414-ac556c2879060cb5.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240) * 創建mysql用戶 ```mysql CREATE USER 'admin'@'%' IDENTIFIED BY '123456'; GRANT ALL ON *.* TO 'admin'@'%'; flush privileges; ``` * 然后就可以使用admin用戶登陸了,因為mysql8與mysql5.7授權有一些不一樣,mysql必須先創建用戶才能授權,不然會出錯。 ### 3、修改時區 ``` docker exec -it mysql /bin/bash cd /etc/mysql/mysql.conf.d apt-get update apt-get install vim vim mysqld.cnf ``` 加入如下一行 ``` default-time_zone = '+8:00' ``` 或者直接追加寫入 ``` echo "default-time_zone = '+8:00'" >> mysqld.cnf ``` * 修改時區 在我們備份數據庫的時候,有用到時間因素,但是 Docker 容器中默認為 +0 時區,而我們是 +8 時區,我們將宿主機的時區文件映射過去就行。 ``` -v /etc/localtime:/etc/localtime:ro ``` 退出容器重啟容器 ``` docker restart mysql ``` 查看時區命令 ```sql show variables like '%time_zone%'; ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看