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

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

docker logs -f mysql8

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

进入mysql8 容器

$ docker exec -it mysql8 bash

$ mysql -uroot -p  #输入密码

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

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

>> 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;