树莓派4B如何使用docker安装mysql5.7.30
这篇文章主要介绍了树莓派4B如何使用docker安装MySQL5.7.30,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。
创新互联建站是一家专业提供石景山企业网站建设,专注与成都网站设计、成都做网站、H5网站设计、小程序制作等业务。10年已为石景山众多企业、政府机构等服务。创新互联专业网站制作公司优惠进行中。
硬件: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 (aarch74) using EditLine wrapper Connection id: 3 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; 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: /opt/mysql/data/mysql.sock Uptime: 2 hours 22 min 33 sec Threads: 1 Questions: 10 Slow queries: 0 Opens: 108 Flush tables: 1 Open tables: 101 Queries per second avg: 0.001
感谢你能够认真阅读完这篇文章,希望小编分享的“树莓派4B如何使用docker安装mysql5.7.30”这篇文章对大家有帮助,同时也希望大家多多支持创新互联,关注创新互联行业资讯频道,更多相关知识等着你来学习!
网页标题:树莓派4B如何使用docker安装mysql5.7.30
本文URL:http://myzitong.com/article/jeiosh.html