8g ubuntu 树莓派4b_Raspberry Pi 4B（4g或8g版本）

硬件：Raspberry Pi 4B(4g或8g版本)

系统：Ubuntu 20.04 LTS Docker：18.09.9

mysql镜像：biarms/mysql:5.7.30-linux-arm64v8

注意：因为我们树莓派4B本身并非x86，而是arm架构，且我们的系统装的是64位ubuntu，因此镜像只能选择arm64v8架构的镜像。

配置文件：/home/docker/server/mysql/my.cnf

[mysqld]

##

server_id=1

##

binlog-ignore-db=mysql

##

log-bin=replicas-mysql-bin

##

binlog_cache_size=1M

##

binlog_format=mixed

##

expire_logs_days=7

max_allowed_packet=125M

max_connections=200

max_connect_errors=10000

datadir =/opt/mysql/data

socket =/opt/mysql/data/mysql.sock

#Encoding

collation-server = utf8_unicode_ci

init-connect=‘SET NAMES utf8‘

character-set-server = utf8

log_error=error.log

[client]

# default-character-set = utf8

socket =/opt/mysql/data/mysql.sock

数据目录：/home/docker/server/mysql/data

启动mysql

docker run -itd --name mysqld -p 3306:3306 --restart always --privileged=true -e TZ=Asia/Shanghai -e MYSQL_ROOT_PASSWORD=example -v /home/docker/server/mysql/my.cnf:/etc/mysql/my.cnf -v /home/docker/server/mysql/data:/var/lib/mysql biarms/mysql:5.7.30-linux-arm64v8

访问mysql

# mysql的root用户密码为example

docker exec -it mysqld mysql -uroot -pexample

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 3

Server version: 5.7.30-0ubuntu0.18.04.1-log (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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> status

--------------

mysql Ver 14.14 Distrib 5.7.30, for Linux (aarch64) using EditLine wrapper

Connection id:3

Current database:

Current user:root@localhost

SSL:Not www.lecaixuanzc.cnuse

Current pager:stdout

Using outfile:‘‘

Using delimiter:www.jinf2zc.cn;

Server version:5.7.30-0ubuntu0.18.04.1-log (Ubuntu)

Protocol version:10

Connection:Localhost via UNIX socket

Server characterset:utf8

Db characterset:utf8

Client characterset:latin1

Conn. characterset:latin1

UNIX socket:www.wdyldi.cn

Uptime:2 hours 22 min 33 sec

Threads: 1 Questions: 10 Slow queries: 0 Opens: 108 Flush tables: www.jmzx666.cn Open tables: 101 Queries per second avg: 0.001

参考

树莓派4B安装 Ubuntu 20.04 LTS

树莓派4B安装 docker18.09.9