Shulou(Shulou.com)06/02 Report--

This article mainly introduces the raspberry pie 4B how to use docker to install mysql5.7.30, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to know about it.

Hardware: Raspberry Pi 4B (4G or 8g version)

System: Ubuntu 20.04 LTS Docker:18.09.9

Mysql image: biarms/mysql:5.7.30-linux-arm64v8

Note: because our raspberry pie 4B itself is not x86, but arm architecture, and our system is equipped with 64-bit ubuntu, so the image can only choose the image of arm64v8 architecture.

Configuration file: / 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=7max_allowed_packet=125Mmax_connections=200max_connect_errors=10000datadir = / opt/mysql/datasocket = / opt/mysql/data/mysql.sock # Encodingcollation-server = utf8_unicode_ciinit-connect='SET NAMES utf8'character-set-server = utf8 log_error=error.log [client] # default-character-set = utf8socket = / opt/mysql/data/mysql.sock

Data directory: / home/docker/server/mysql/data

Start mysql

Docker run-itd-- name mysqld-p 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

Visit mysql

The root password for # mysql is exampledocker exec-it mysqld mysql-uroot-pexamplemysql: [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 3Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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 wrapperConnection id: 3Current database: Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile:''Using delimiter: Server version: 5.7.30-0ubuntu0.18.04.1-log (Ubuntu) Protocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: latin1Conn. Characterset: latin1UNIX socket: / opt/mysql/data/mysql.sockUptime: 2 hours 22 min 33 secThreads: 1 Questions: 10 Slow queries: 0 Opens: 108 Flush tables: 1 Open tables: 101 Queries per second avg: 0.001 Thank you for reading this article carefully. I hope the article "Raspberry pie 4B how to use docker to install mysql5.7.30" shared by the editor will be helpful to you, and I hope you will support it. Pay attention to the industry information channel, more related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.