docker安装 mysql

docker-compose.yml
```
version: "3"
networks:
  mbsnet:
    external: true

services:
  mysql:
      restart: always
      image: mysql
      hostname: mysql
      container_name: mysql
      privileged: true
      ports:
        - 3306:3306
      #  - 80:80
      volumes:     
        - /etc/localtime:/etc/localtime:ro
        - /data-compose/mysql/conf:/etc/mysql
        - /data-compose/mysql/logs:/var/log/mysql
        - /data-compose/mysql/dbdata/mysql/:/var/lib/mysql
        - /data-compose/mysql/dbdata/mysql-files:/var/lib/mysql-files
      environment:
        MYSQL_ROOT_PASSWORD: 12345678
      #command: --default-authentication-plugin=mysql_native_password
      command: --lower_case_table_names=1
      networks:
        mbsnet:
            ipv4_address: 172.10.0.10
```

my.cnf [/data-compose/mysql/conf]
```
# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL

# Custom config should go here
!includedir /etc/mysql/conf.d/
max_connections=1000
wait_timeout=120
interactive_timeout=300
lower_case_table_names=1
```


 docker安装 mysql


 1、启动docker

<pre class="brush:bash;toolbar:false">service docker start</pre>

 2、查看docker是否启动成功

<pre class="brush:bash;toolbar:false">ps -ef|grep docker</pre>

 1、查询mysql

<pre class="brush:bash;toolbar:false;">docker search mysql</pre>

 2、安装mysql

<pre class="brush:bash;toolbar:false">docker pull mysql</pre>

 3、查看镜像

<pre class="brush:bash;toolbar:false">docker images</pre>

 4、在opt下创建文件夹

<pre class="brush:bash;toolbar:false">cd /opt/
mkdir mysql_docker
cd mysql_docker/
echo $PWD</pre>

 5、启动mysql容器，

<pre class="brush:bash;toolbar:false">docker run \
	-p 3306:3306 \
	--name mysql \
	--restart=always \
	-v /opt/mysql/conf:/etc/mysql \
	-v /opt/mysql/logs:/var/logs/mysql \
	-v /dbdata:/var/lib/mysql \
	-e MYSQL_ROOT_PASSWORD=123456\
	-d mysql</pre>

 6、查看mysql进程

<pre class="brush:bash;toolbar:false">docker ps -a</pre>

 7、进入mysql容器，并登陆mysql

<pre class="brush:bash;toolbar:false">docker exec -it mysqlserver bash
mysql -uroot -p</pre>

 8、开启远程访问权限

<pre class="brush:bash;toolbar:false">use mysql;
select host,user,plugin from user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;</pre>

 查看docker日志


 1、docker ps -a 找到ID


 2、docker logs -f --tail 10 xxxxxxxx //最后10条记录


 常用命令

<pre class="brush:bash;toolbar:false">#查看进程
docker ps -a
#关闭docker中mysql容器
docker stop mysqlserver
#重启docker中mysql重启
docker restart xxxxxxx
#重启docker
systemctl restart docker
#关闭docker
systemctl stop docker</pre>

docker安装 mysql

添加新评论

关于博主

文章分类

最受欢迎的文章

最近回复

其它