docker安装 mysql

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

# 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

service docker start

ps -ef|grep docker

docker search mysql

docker pull mysql

docker images

cd /opt/
mkdir mysql_docker
cd mysql_docker/
echo $PWD

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

docker ps -a

docker exec -it mysqlserver bash
mysql -uroot -p

use mysql;
select host,user,plugin from user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;

#查看进程
docker ps -a
#关闭docker中mysql容器
docker stop mysqlserver
#重启docker中mysql重启
docker restart     xxxxxxx
#重启docker
systemctl restart docker
#关闭docker
systemctl stop docker