Mysql

安装

docker compose

• 先注释掉配置文件的映射
• 将配置文件复制到本地
• 解除注释重启容器

docker compose up
docker cp school-mysql:/etc/mysql conf
docker cp school-mysql:/var/lib/mysql data
docker cp school-mysql:/var/log/mysql logs

version: '3.7'
services:
  mysql:
    hostname: mysql
    container_name: school-mysql
    image: registry.cn-hangzhou.aliyuncs.com/wjn0918/soft:mysql-8.0.41
    restart: always
    ports:
      - "3306:3306"
    volumes:
      - ./conf:/etc/mysql
      - ./data:/var/lib/mysql
      - ./logs:/var/log/mysql
    privileged: true
    environment:
      - MYSQL_ROOT_PASSWORD="Mysql@2024"

手动

rpm 安装

# 移除mariadb依赖
yum -y remove mariadb-libs-*.el7.x86_64
for i in `ls`; do rpm -i $i --force --nodeps; done;


systemctl start mysqld
more /var/log/mysqld.log | grep root@localhost | awk -F 'root@localhost: ' '{print $2}'


ALTER USER USER() IDENTIFIED BY 'Mysql@2023';
grant all on *.* to root@'%' identified by 'Mysql@2023' with grant option;
flush privileges;

创建用户

create database hive default character set utf8;
CREATE USER 'hive'@'%' IDENTIFIED BY 'Hive@2023';
GRANT ALL PRIVILEGES ON hive. * TO 'hive'@'%' IDENTIFIED by 'Hive@2023';
FLUSH PRIVILEGES;

client 安装

yum remove -y mariadb-libs-*.el7.x86_64
rpm -ivh mysql-community-common-8.0.34-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-plugins-8.0.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.34-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-8.0.34-1.el7.x86_64.rpm

docker exec -i school-mysql sh -c 'exec mysql -uroot -pMysqlWjn@2025 ' <<C 
> select 1 
> C

docker exec -i school-mysql sh -c 'exec mysql -uroot -p"Mysql"' < /some/path/on/your/host/all-databases.sql