docker 安装mysql 8.x

 linux 虚拟机网卡配置  参考  Linux 虚拟机配置桥接网卡_大大蚊子的博客-CSDN博客

linux 安装docker 参考 Linux 安装docker engine_大大蚊子的博客-CSDN博客_docker engine

docker 常用命令参考 docker 常用命令及参数_大大蚊子的博客-CSDN博客

官网参考  Install Portainer CE with Docker Swarm on WSL / Docker Desktop - Portainer Documentation

dockerhub  Docker

环境：

centos虚拟机，已安装docker-engine

运行

docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql

进入容器

docker exec -it mysql bash

连接mysql 在容器内操作

mysql -uroot -p123456

开启binlog  (debezium连接必须打开)    log_bin = ON 为打开

show variables like 'log_%';

查看binlog_format 为ROW              binlog_format = ROW 

show variables like '%format%';

修改binlog配置   查找文件   mysqld --verbose --help | grep my.cnf

root@2c63214e5d5c:/# mysqld --verbose --help | grep my.cnf
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf 
                      my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default

创建测试库、表及数据

create database dbz_mysql;
use dbz_mysql;
create table dbz_mysql.aa(id int not null);
insert into dbz_mysql.aa values(1);
select count(1) from dbz_mysql.aa;
select * from dbz_mysql.aa order by id desc limit 10;

创建用户  以下为8.x版本创建授权步骤

create user 'mysqluser'@'%' identified by 'mysqluser';
grant select,reload,show databases,replication slave,replication client on *.* to 'mysqluser' with grant option;
flush privileges;
select host,user,select_priv,reload_priv,show_db_priv,repl_slave_priv,repl_client_priv from mysql.user where user = 'mysqluser';

常见问题

Public Key Retrieval is not allowed

解决

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

字符集查询

-- 服务器字符集
SHOW VARIABLES LIKE 'character%';

-- 数据库字符集
Select SCHEMA_NAME,DEFAULT_CHARACTER_SET_NAME,DEFAULT_COLLATION_NAME,SQL_PATH from information_schema.SCHEMATA;

-- 表字符集    databasename 替换成对应的库
show table status from databasename;

未提交事务查询

select * from information_schema.processlist;

select * from information_schema.innodb_trx;

kill XXX;