docker mysql8.x

docker安装mysql8.x 简单步骤

docker pull mysql
cd ~/mysql/conf
sudo touch my.cnf
sudo vim my.cnf

把下面的内容加到my.cnf文件中去

[client]
port = 3307
default-character-set = utf8mb4
 
[mysql]
port = 3307
default-character-set = utf8mb4
 
[mysqld]
# bind-address = 0.0.0.0
# port = 3306
 
max_connections=10000
 
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
 
# 设置时区和字符集
# default-time-zone='+8:00'
character-set-client-handshake=FALSE
init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'
 
gtid-mode=ON
enforce-gtid-consistency = ON

启动镜像

docker run  --restart=always  --name mysqlnew  -v ~/mysql/conf:/etc/mysql  -v ~/mysql/data:/var/lib/mysql  -v ~/mysql/log:/var/log  -v ~/mysql/mysql-files:/var/lib/mysql-files -p 3307:3306  -e MYSQL_ROOT_PASSWORD=‘root’   -d mysql

开启远程访问

docker exec -it mysqlnew bash
mysql -u root -p
# 然后直接回车，如果要输密码就输

# 创建一个账号aaa，用来进行远程访问；
create user 'aaa'@'%' identified by '123456';
		 
# 赋予所有权限给之前创建的账号:aaa
grant all on *.* to 'aaa'@'%';
		 	 
# 刷新权限
FLUSH PRIVILEGES;