mac os：Monterey
mac version：12.4 (21F79)
mac type: MacBook Air (M1, 2020), Apple M1

docker desktop version：v4.10.0
docker version：v20.10.17
docker-compose version: v1.29.2

# 如果你比较懒可以使用最后的“MySQL8自动安装脚本”，mac电脑通用
https://hub.docker.com/_/mysql/tags

git clone git@gitee.com:xiaoyaojiugui/technical.git

# 1.跳转到下载脚本的根目录，执行命令：
cd /technical/docker/foundations/database/mysql

# 2.执行安装脚本，执行命令：
sh ./mysql.sh

# 3.选择待安装的 MySQL 序号

---------------函数开始执行---------------

---------------环境变量初始化开始---------------
1.1、请选择要安装的 MySQL 版本，例如：MySQL8，输入“1”回车。
1、MySQL8 (Mac with Apple chip or Intel chip)
2、MySQL8 (Linux)
3、MySQL5
请输入序号:
1

1.2、你选择了安装：MySQL8 (Mac with Apple chip or Intel chip)
1.3、初始化 MySQL 环境变量
image_alias=mysql8
image_name=mysql/mysql-server:latest
mysql_port=33306
os_path=/Users/jason.zhuo/data/docker/volumes/mysql8
---------------环境变量初始化完毕---------------

1.1、执行创建容器操作，跳过此步骤，镜像已存在[mysql/mysql-server:latest]
1.2、执行创建容器操作，创建目录并授权，执行命令：sudo mkdir -p -v /Users/jason.zhuo/data/docker/volumes/mysql8/{data,logs,conf} && sudo chown -R jason.zhuo /Users/jason.zhuo/data/docker/volumes/mysql8
1.3、执行创建容器操作，创建文件my.cnf并将配置写到文件中[/Users/jason.zhuo/data/docker/volumes/mysql8/conf/my.cnf]
1.4、执行创建容器操作，执行命令：docker run -d -p 33306:3306 -d --restart=always --privileged=true -e MYSQL_ROOT_PASSWORD=root123456 -v /Users/jason.zhuo/data/docker/volumes/mysql8/conf/:/etc/mysql/conf.d/ -v /Users/jason.zhuo/data/docker/volumes/mysql8/data:/var/lib/mysql -v /Users/jason.zhuo/data/docker/volumes/mysql8/logs:/var/log/mysql --name mysql8 mysql/mysql-server:latest
1.5.1、查看容器状态，执行命令：docker inspect --format='{{.State.Status}}' mysql8
1.5.2、查看容器状态，[running]
1.5.3、查看容器详情，执行命令：docker ps | grep mysql/mysql-server:latest

2.1、其他待执行命令，登录容器其命令为：docker exec -it mysql8 mysql -uroot -proot
---------------函数执行完毕---------------

# 1.跳转到下载脚本的根目录，执行命令：
cd /technical/docker/foundations/database/mysql

# 2.执行安装脚本，执行命令：
sh ./create-user.sh

# 3.选择待安装的 MySQL 序号

---------------函数开始执行---------------

---------------环境变量初始化开始---------------
1.1、请选择要安装的 MySQL 版本，例如：MySQL8，输入“1” 回车。
1、MySQL8 (Mac with Apple chip or Intel chip)
2、MySQL8 (Linux)
3、MySQL5 (通用)
请输入序号:
1

1.2、你选择了安装：MySQL8 (Mac with Apple chip or Intel chip)
1.3、初始化 MySQL 环境变量
image_alias=mysql8
image_name=mysql/mysql-server:latest
mysql_port=33306
os_path=/Users/jason.zhuo/data/docker/volumes/mysql8

---------------环境变量初始化完毕---------------

1、创建数据库用户(admin)并授权，执行命令：docker exec -it mysql8 mysql -uroot -proot123456
spawn docker exec -it mysql8 mysql -uroot -proot123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.27 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> create user 'admin'@'localhost' identified by 'admin123456';
Query OK, 0 rows affected (0.02 sec)

mysql> grant all privileges on *.* to 'admin'@'localhost';
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'admin'@'%' identified by 'admin123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'admin'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select host, user, plugin from user;
+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| %         | admin            | caching_sha2_password |
| localhost | admin            | caching_sha2_password |
| localhost | healthchecker    | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+
7 rows in set (0.00 sec)

mysql> exit
Bye
2、成功创建数据库用户：admin
---------------函数执行完毕---------------