MySQL

配置MySQL

mkdir -p /docker/mysql
cat >>/docker/mysql/my.cnf << EOF


[mysql]

[mysqld]
default-time_zone = '+8:00'
default_authentication_plugin = mysql_native_password
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections = 2000
lower_case_table_names  = 1


EOF

创建Docker镜像

docker pull mysql:8.0.29

docker  network create  yyy

docker run -d \
-p 328:3306 \
-v /docker/mysql/my.cnf:/etc/mysql/conf.d/my.cnf \
-v /docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=nicaicai6789.. \
--restart always \
--network yyy \
--name mysqll \
mysql:8.0.29

# 带有备份目录的 命令
docker run -d \
-p 328:3306 \
-v /docker/mysql/my.cnf:/etc/mysql/conf.d/my.cnf \
-v /docker/mysql/data:/var/lib/mysql \
-v /docker/mysql/backup:/var/lib/backup \
-e MYSQL_ROOT_PASSWORD=nicaicai6789.. \
--network yyy \
--restart always \
--name mysqll \
mysql:8.0.29



# 带有备份目录的 命令
docker run -d \
-p 3306:3306 \
-v /db1/mysql/my.cnf:/etc/mysql/conf.d/my.cnf \
-v /db1/mysql/data:/var/lib/mysql \
-v /db1/mysql/backup:/var/lib/backup \
-e MYSQL_ROOT_PASSWORD=mysql@HzRoot.. \
--network yyy \
--restart always \
--name mysql \
mysql:8.0.29

```shell
#加入YYY网络

docker network connect yyy mysqll

配置外网访问

#进入容器：env LANG=C.UTF-8 避免容器中显示中文乱码
docker exec -it mysqll env LANG=C.UTF-8 /bin/bash
#进入容器内的mysql命令行
mysql -uroot -pnicaicai6789..
#修改默认密码校验方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'nicaicai6789..';

```plain
CREATE USER 'cloud'@'%' IDENTIFIED BY '40d826002fd16';
GRANT ALL PRIVILEGES ON `yyycloud`.* TO 'cloud'@'%';
FLUSH PRIVILEGES;

# 创建 cloud 用户 授权 yyycloud 库

```plain
mkdir -p /db1/mysql
cat >>/db1/mysql/my.cnf << EOF


[mysql]

[mysqld]
default-time_zone = '+8:00'
default_authentication_plugin = mysql_native_password
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections = 2000
lower_case_table_names  = 1


EOF

```plain
# 带有备份目录的 命令
docker run -d \
-p 3306:3306 \
-v /db1/mysql/my.cnf:/etc/mysql/conf.d/my.cnf \
-v /db1/mysql/data:/var/lib/mysql \
-v /db1/mysql/backup:/var/lib/backup \
-e MYSQL_ROOT_PASSWORD=mysql@adminEyz.. \
--network yyy \
--restart always \
--name mysqll \
mysql:8.0.29

```plain
#进入容器：env LANG=C.UTF-8 避免容器中显示中文乱码
docker exec -it mysqll env LANG=C.UTF-8 /bin/bash
#进入容器内的mysql命令行
mysql -uroot -pmysql@adminEyz..
#修改默认密码校验方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'mysql@adminEyz..';