千家信息网

树莓派4B如何安装mysql5.7.32

发表于:2024-09-22 作者:千家信息网编辑
千家信息网最后更新 2024年09月22日,小编给大家分享一下树莓派4B如何安装mysql5.7.32,希望大家阅读完这篇文章之后都有所收获,下面让我们一起去探讨吧!硬件:Raspberry Pi 4B(4g或8g版本)系统:Ubuntu 20
千家信息网最后更新 2024年09月22日树莓派4B如何安装mysql5.7.32

小编给大家分享一下树莓派4B如何安装mysql5.7.32,希望大家阅读完这篇文章之后都有所收获,下面让我们一起去探讨吧!

硬件:Raspberry Pi 4B(4g或8g版本)
系统:Ubuntu 20.04 LTS

最近有个项目需要在树莓派Pi4上安装mysql5.7.32版本,查了下launchpad,发现目前已经支持mysql5.7系列的5.7.33版本,我们暂时没需求,还是先用5.7.32.

  • 下载相关deb文件

wget http://launchpadlibrarian.net/503346130/mysql-server-5.7_5.7.32-0ubuntu0.18.04.1_arm64.debwget  http://launchpadlibrarian.net/503346131/mysql-server-core-5.7_5.7.32-0ubuntu0.18.04.1_arm64.debwget http://launchpadlibrarian.net/355862128/libevent-core-2.1-6_2.1.8-stable-4build1_arm64.debwget http://launchpadlibrarian.net/503346130/mysql-server-5.7_5.7.32-0ubuntu0.18.04.1_arm64.debwget http://launchpadlibrarian.net/355861262/libevent-core-2.1-6_2.1.8-stable-4build1_arm64.debwget http://launchpadlibrarian.net/503346128/mysql-client-5.7_5.7.32-0ubuntu0.18.04.1_arm64.debwget http://launchpadlibrarian.net/503346129/mysql-client-core-5.7_5.7.32-0ubuntu0.18.04.1_arm64.deb
  • 安装mysql

# 这次很顺利,直接一遍安装成功dpkg -i *.deb# 默认服务# systemctl list-units --all --type=service|grep mysql  mysql.service                                            loaded    active     running      MySQL Community Server # 配置文件root@ubuntu:~/mysql# cat /etc/mysql/my.cnf## The MySQL database server configuration file.## You can copy this to one of:# - "/etc/mysql/my.cnf" to set global options,# - "~/.my.cnf" to set user-specific options.# # One can use all long options that the program supports.# Run program with --help to get a list of available options and with# --print-defaults to see which it would actually understand and use.## For explanations see# http://dev.mysql.com/doc/mysql/en/server-system-variables.html## * IMPORTANT: Additional settings that can override those from this file!#   The files must end with '.cnf', otherwise they'll be ignored.#!includedir /etc/mysql/conf.d/!includedir /etc/mysql/mysql.conf.d/
  • 访问mysql

# mysql的root用户密码默认为空mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.32-0ubuntu0.18.04.1 (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.32, for Linux (aarch74) using  EditLine wrapperConnection id:          2Current database:Current user:           root@localhostSSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.7.32-0ubuntu0.18.04.1 (Ubuntu)Protocol version:       10Connection:             Localhost via UNIX socketServer characterset:    latin1Db     characterset:    latin1Client characterset:    utf8Conn.  characterset:    utf8UNIX socket:            /var/run/mysqld/mysqld.sockUptime:                 22 min 7 secThreads: 1  Questions: 5  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 98  Queries per second avg: 0.003

看完了这篇文章,相信你对"树莓派4B如何安装mysql5.7.32"有了一定的了解,如果想了解更多相关知识,欢迎关注行业资讯频道,感谢各位的阅读!

0