這篇文章主要介紹了樹莓派4B如何使用docker安裝MySQL5.7.30,具有一定借鑒價值,感興趣的朋友可以參考下,希望大家閱讀完這篇文章之后大有收獲,下面讓小編帶著大家一起了解一下。
創(chuàng)新互聯(lián)建站是一家專業(yè)提供石景山企業(yè)網(wǎng)站建設,專注與成都網(wǎng)站設計、成都做網(wǎng)站、H5網(wǎng)站設計、小程序制作等業(yè)務。10年已為石景山眾多企業(yè)、政府機構(gòu)等服務。創(chuàng)新互聯(lián)專業(yè)網(wǎng)站制作公司優(yōu)惠進行中。
硬件:Raspberry Pi 4B(4g或8g版本)
系統(tǒng):Ubuntu 20.04 LTS Docker:18.09.9
mysql鏡像:biarms/mysql:5.7.30-linux-arm64v8
注意:因為我們樹莓派4B本身并非x86,而是arm架構(gòu),且我們的系統(tǒng)裝的是64位ubuntu,因此鏡像只能選擇arm64v8架構(gòu)的鏡像。
配置文件:/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
數(shù)據(jù)目錄:/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”這篇文章對大家有幫助,同時也希望大家多多支持創(chuàng)新互聯(lián),關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道,更多相關(guān)知識等著你來學習!