这篇文章主要为大家展示了“树莓派4B如何安装mysql5.7.28”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“树莓派4B如何安装mysql5.7.28”这篇文章吧。
硬件:Raspberry Pi 4B(4g或8g版本)
系统:Ubuntu 20.04 LTS
下载相关deb文件
wget http://launchpadlibrarian.net/451652941/mysql-server_5.7.28-0ubuntu0.18.04.4_all.deb wget http://launchpadlibrarian.net/451655612/mysql-server-5.7_5.7.28-0ubuntu0.18.04.4_arm64.deb wget http://launchpadlibrarian.net/451655610/mysql-client-5.7_5.7.28-0ubuntu0.18.04.4_arm64.deb wget http://launchpadlibrarian.net/353280751/mysql-common_5.8+1.0.4_all.deb wget http://launchpadlibrarian.net/451655611/mysql-client-core-5.7_5.7.28-0ubuntu0.18.04.4_arm64.deb wget http://launchpadlibrarian.net/451655613/mysql-server-core-5.7_5.7.28-0ubuntu0.18.04.4_arm64.deb wget http://launchpadlibrarian.net/355861262/libevent-core-2.1-6_2.1.8-stable-4build1_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 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.28-0ubuntu0.18.04.4 (Ubuntu) Copyright (c) 2000, 2019, 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.28, for Linux (aarch74) using EditLine wrapper Connection id: 2 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.7.28-0ubuntu0.18.04.4 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 5 min 13 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 105 Flush tables: 1 Open tables: 98 Queries per second avg: 0.015
以上是“树莓派4B如何安装mysql5.7.28”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。