MySQL 8.0 Docker安装

拉取镜像

docker pull mysql:8.0

查看拉取的镜像

docker images

创建配置

创建mysql根目录 /opt/docker/mysql8

• my.cnf : MySQL 的配置文件;

• conf.d: 自定义配置文件放在这里；

• logs: 日志文件；

• data: 数据

$ mkdir -p /opt/docker/mysql8/conf.d /opt/docker/mysql8/logs /opt/docker/mysql8/data

在 /opt/docker/mysql8下创建my.cnf文件

[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000
bind-address=0.0.0.0
default-time-zone = '+08:00'
skip-name-resolve
lower_case_table_names=1
[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

运行 MySQL 镜像

docker run --restart=always --privileged=true -p 3306:3306 --name mysql8 \
-v /opt/docker/mysql8/my.cnf:/etc/mysql/my.cnf \
-v /opt/docker/mysql8/conf.d:/etc/mysql/conf.d \
-v /opt/docker/mysql8/logs:/var/log/mysql \
-v /opt/docker/mysql8/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql

查看 MySQL 镜像运行日志

docker logs -f mysql8

设置时区

否则和宿主机相差8个小时，以及远程连接出现中断的情况
docker cp /usr/share/zoneinfo/Asia/Shanghai mysql8:/etc/localtime

进入MySQL的Docker容器

进入mysql8 容器

$ docker exec -it mysql8 bash

MySQL基本操作

登录

$ mysql -uroot -p  #输入密码

修改root密码

>> ALTER user 'root'@'%' IDENTIFIED BY '12345678';
>> flush privileges;

查询用户表

>> show databases;
>> use mysql;
>> select host,user from user;

修改root用户可以访问的主机地址

>> update user set host='%' where user='root';
>> flush privileges;

给用户授权远程访问

>> grant all privileges on *.* to 'root'@'%' with grant option;
>> flush privileges;

问题

问题一

Authentication plugin 'caching_sha2_password' cannot be loaded

解决

>> CREATE USER mc_test@'192.168.31.%' IDENTIFIED BY '123456' WITH mysql_native_password;
或
>> ALTER USER 'nce_document' IDENTIFIED WITH mysql_native_password BY '123456';

问题二

ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

解决

先登录mysql
$ mysql -u root -p
输入密码
	
mysql> use mysql;
mysql> select user,host from user;