TaiShan200 kunpeng920 docker 创建并启动 mysql5.7.30

最新推荐文章于 2024-01-21 14:13:20 发布

闭关苦炼内功

最新推荐文章于 2024-01-21 14:13:20 发布

阅读量425

点赞数 1

分类专栏： Linux docker MySQL 文章标签：鲲鹏 MySQL Docker Dockerfile 远程连接

本文链接：https://blog.csdn.net/frdevolcqzyxynjds/article/details/119499188

版权

Linux 同时被 3 个专栏收录

327 篇文章 31 订阅

订阅专栏

MySQL

41 篇文章 0 订阅

订阅专栏

docker

40 篇文章 7 订阅

订阅专栏

一直以来都想直接安逸的在鲲鹏上搞mysql，终于搞通了

vi Dockerfile

#!/bin/bash

FROM swr.cn-north-4.myhuaweicloud.com/hwstaff_imagemarket/mysql-onlinelab:5.7.30-arm64v8

vi build

#!/bin/sh

docker build -t docker-mysql:5.7.30-armv8 .

chmod u+x build

vi run

#!/bin/bash

cmd=(
    docker run
    -dit
    --name mysql57-1
    --hostname=mysql57
    --privileged=true
    -p 3306:3306
    -e MYSQL_ROOT_PASSWORD=xxx
    docker-mysql:5.7.30-armv8
    /usr/sbin/init
)

"${cmd[@]}"

chmod u+x run

./build
./run
docker ps
docker logs container-ID
docker exec -it container-ID bash
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'demo'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

然后通过远程连接数据库的工具连接测试

打完收工！