【鲁班猫门禁系统】安装mysql
安装现在，我们将通过 apt 包管理器安装 mysql。执行下udo apt install mysql-server。具体日志如下：
cat@lubancat:~/lugl/my_project$ sudo apt install mysql-serverreading package lists... donebuilding dependency tree... donereading state information... donethe following packages were automatically installed and are no longer required: accountsservice-ubuntu-schemas activity-log-manager apg aptdaemon aptdaemon-data cracklib-runtime gedit gedit-common gir1.2-accountsservice-1.0 gir1.2-adw-1 gir1.2-gck-1 gir1.2-gcr-3 gir1.2-gdesktopenums-3.0 gir1.2-gdm-1.0 gir1.2-geoclue-2.0 gir1.2-gnomebluetooth-3.0 gir1.2-gnomedesktop-3.0 gir1.2-graphene-1.0 gir1.2-gtk-4.0 gir1.2-gtksource-4 gir1.2-gweather-3.0 gir1.2-javascriptcoregtk-4.0 gir1.2-json-1.0 gir1.2-mutter-10 gir1.2-nma-1.0 gir1.2-peas-1.0 gir1.2-rsvg-2.0 gir1.2-soup-2.4 gir1.2-upowerglib-1.0 gir1.2-vte-2.91 gkbd-capplet gnome-bluetooth-3-common gnome-bluetooth-common gnome-control-center-data gnome-control-center-faces gnome-menus gnome-remote-desktop gnome-settings-daemon gnome-shell-common gsfonts imagemagick-6-common language-selector-gnome libabsl20210324 libadwaita-1-0 libcolord-gtk1 libcrack2 libdca0 libde265-0 libdee-1.0-4 libdjvulibre-text libdjvulibre21 libebackend-1.2-10 libebook-1.2-20 libebook-contacts-1.2-3 libedata-book-1.2-26 libedata-cal-2.0-1 libfaad2 libfftw3-double3 libfluidsynth3 libfreeaptx0 libfreerdp-client2-2 libfreerdp-server2-2 libfreerdp2-2 libgdm1 libgeoclue-2-0 libgeocode-glib0 libgeonames-common libgeonames0 libgjs0g libgnome-autoar-0-0 libgnome-bluetooth-3.0-13 libgnome-bluetooth13 libgnome-menu-3-0 libgnomekbd8 libgsound0 libgspell-1-2 libgspell-1-common libgssdp-1.2-0 libgtksourceview-4-0 libgtksourceview-4-common libgupnp-1.2-1 libgupnp-av-1.0-3 libgupnp-igd-1.0-4 libgweather-3-16 libgweather-common libheif1 libinstpatch-1.0-2 libjxr-tools libjxr0 libkate1 liblqr-1-0 libltc11 libmagickcore-6.q16-6 libmagickcore-6.q16-6-extra libmagickwand-6.q16-6 libmediaart-2.0-0 libmjpegutils-2.1-0 libmodplug1 libmozjs-102-0 libmpcdec6 libmpeg2encpp-2.1-0 libmplex2-2.1-0 libmutter-10-0 libnice10 libopenh264-6 libopenni2-0 libpeas-1.0-0 libpeas-common libphonenumber8 libprotobuf23 libpulsedsp libpwquality-common libpwquality1 libqrencode4 libqt5multimedia5 libqt5multimediaquick5 libqt5multimediawidgets5 librest-0.7-0 librygel-core-2.6-2 librygel-db-2.6-2 librygel-renderer-2.6-2 librygel-server-2.6-2 libsoundtouch1 libsoup-gnome2.4-1 libspandsp2 libspeexdsp1 libsrtp2-1 libtimezonemap-data libtimezonemap1 libtumbler-1-0 libunity-control-center1 libvncserver1 libvo-aacenc0 libvo-amrwbenc0 libwhoopsie-preferences0 libwildmidi2 libwinpr2-2 libwmflite-0.2-7 libxcb-xv0 libxcvt0 libzbar0 libzeitgeist-2.0-0 libzxingcore1 mutter-common power-profiles-daemon pulseaudio-utils python3-aptdaemon python3-aptdaemon.gtk3widgets python3-defer python3-macaroonbakery python3-nacl python3-protobuf python3-pymacaroons python3-rfc3339 python3-tz qml-module-qtmultimedia switcheroo-control timgm6mb-soundfont tumbler-common ubuntu-wallpapers ubuntu-wallpapers-jammy whoopsie whoopsie-preferences xwayland yaru-theme-gnome-shell zeitgeist-core zenity-commonuse 'sudo apt autoremove' to remove them.the following additional packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl libmecab2 libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0 mysql-server-core-8.0suggested packages: libipc-sharedcache-perl mailx tinycathe following new packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl libmecab2 libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server mysql-server-8.0 mysql-server-core-8.00 upgraded, 18 newly installed, 0 to remove and 95 not upgraded.need to get 28.4 mb of archives.after this operation, 236 mb of additional disk space will be used.do you want to continue? [y/n] yget:1 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mysql-common all 5.8+1.0.8 [7212 b]get:2 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-client-core-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [2877 kb]get:3 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-client-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [22.7 kb]get:4 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libaio1 arm64 0.3.112-13build1 [7018 b]get:5 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libmecab2 arm64 0.996-14build9 [188 kb]get:6 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 libprotobuf-lite23 arm64 3.12.4-1ubuntu7.22.04.1 [192 kb]get:7 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server-core-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [16.9 mb]get:8 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [1230 kb]get:9 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libcgi-pm-perl all 4.54-1 [188 kb]get:10 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi0ldbl arm64 2.4.2-2build2 [28.0 kb]get:11 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi-perl arm64 0.82+ds-1build1 [22.3 kb]get:12 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libcgi-fast-perl all 1:2.15-1 [10.5 kb]get:13 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi-bin arm64 2.4.2-2build2 [10.7 kb]get:14 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libhtml-template-perl all 2.97-1.1 [59.1 kb]get:15 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-utils arm64 0.996-14build9 [4830 b]get:16 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-ipadic all 2.7.0-20070801+main-3 [6718 kb]get:17 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-ipadic-utf8 all 2.7.0-20070801+main-3 [4384 b]get:18 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server all 8.0.32-0ubuntu0.22.04.2 [9458 b]fetched 28.4 mb in 2s (11.9 mb/s)preconfiguring packages ...selecting previously unselected package mysql-common.(reading database ... 159629 files and directories currently installed.)preparing to unpack .../0-mysql-common_5.8+1.0.8_all.deb ...unpacking mysql-common (5.8+1.0.8) ...selecting previously unselected package mysql-client-core-8.0.preparing to unpack .../1-mysql-client-core-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package mysql-client-8.0.preparing to unpack .../2-mysql-client-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package libaio1:arm64.preparing to unpack .../3-libaio1_0.3.112-13build1_arm64.deb ...unpacking libaio1:arm64 (0.3.112-13build1) ...selecting previously unselected package libmecab2:arm64.preparing to unpack .../4-libmecab2_0.996-14build9_arm64.deb ...unpacking libmecab2:arm64 (0.996-14build9) ...selecting previously unselected package libprotobuf-lite23:arm64.preparing to unpack .../5-libprotobuf-lite23_3.12.4-1ubuntu7.22.04.1_arm64.deb ...unpacking libprotobuf-lite23:arm64 (3.12.4-1ubuntu7.22.04.1) ...selecting previously unselected package mysql-server-core-8.0.preparing to unpack .../6-mysql-server-core-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up mysql-common (5.8+1.0.8) ...update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto modeselecting previously unselected package mysql-server-8.0.(reading database ... 159843 files and directories currently installed.)preparing to unpack .../00-mysql-server-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package libcgi-pm-perl.preparing to unpack .../01-libcgi-pm-perl_4.54-1_all.deb ...unpacking libcgi-pm-perl (4.54-1) ...selecting previously unselected package libfcgi0ldbl:arm64.preparing to unpack .../02-libfcgi0ldbl_2.4.2-2build2_arm64.deb ...unpacking libfcgi0ldbl:arm64 (2.4.2-2build2) ...selecting previously unselected package libfcgi-perl:arm64.preparing to unpack .../03-libfcgi-perl_0.82+ds-1build1_arm64.deb ...unpacking libfcgi-perl:arm64 (0.82+ds-1build1) ...selecting previously unselected package libcgi-fast-perl.preparing to unpack .../04-libcgi-fast-perl_1%3a2.15-1_all.deb ...unpacking libcgi-fast-perl (1:2.15-1) ...selecting previously unselected package libfcgi-bin.preparing to unpack .../05-libfcgi-bin_2.4.2-2build2_arm64.deb ...unpacking libfcgi-bin (2.4.2-2build2) ...selecting previously unselected package libhtml-template-perl.preparing to unpack .../06-libhtml-template-perl_2.97-1.1_all.deb ...unpacking libhtml-template-perl (2.97-1.1) ...selecting previously unselected package mecab-utils.preparing to unpack .../07-mecab-utils_0.996-14build9_arm64.deb ...unpacking mecab-utils (0.996-14build9) ...selecting previously unselected package mecab-ipadic.preparing to unpack .../08-mecab-ipadic_2.7.0-20070801+main-3_all.deb ...unpacking mecab-ipadic (2.7.0-20070801+main-3) ...selecting previously unselected package mecab-ipadic-utf8.preparing to unpack .../09-mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb ...unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...selecting previously unselected package mysql-server.preparing to unpack .../10-mysql-server_8.0.32-0ubuntu0.22.04.2_all.deb ...unpacking mysql-server (8.0.32-0ubuntu0.22.04.2) ...setting up libmecab2:arm64 (0.996-14build9) ...setting up mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up libfcgi0ldbl:arm64 (2.4.2-2build2) ...setting up libcgi-pm-perl (4.54-1) ...setting up libfcgi-bin (2.4.2-2build2) ...setting up libhtml-template-perl (2.97-1.1) ...setting up libprotobuf-lite23:arm64 (3.12.4-1ubuntu7.22.04.1) ...setting up mecab-utils (0.996-14build9) ...setting up mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up libfcgi-perl:arm64 (0.82+ds-1build1) ...setting up libaio1:arm64 (0.3.112-13build1) ...setting up mecab-ipadic (2.7.0-20070801+main-3) ...compiling ipa dictionary for mecab. this takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% |###########################################|/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/postp.csv ... 146reading /usr/share/mecab/dic/ipadic/noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/filler.csv ... 19reading /usr/share/mecab/dic/ipadic/others.csv ... 2reading /usr/share/mecab/dic/ipadic/noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/symbol.csv ... 208reading /usr/share/mecab/dic/ipadic/prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/noun.org.csv ... 16668emitting double-array: 100% |###########################################|reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% |###########################################|done!update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto modesetting up libcgi-fast-perl (1:2.15-1) ...setting up mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...compiling ipa dictionary for mecab. this takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% |###########################################|/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/postp.csv ... 146reading /usr/share/mecab/dic/ipadic/noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/filler.csv ... 19reading /usr/share/mecab/dic/ipadic/others.csv ... 2reading /usr/share/mecab/dic/ipadic/noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/symbol.csv ... 208reading /usr/share/mecab/dic/ipadic/prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/noun.org.csv ... 16668emitting double-array: 100% |###########################################|reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% |###########################################|done!update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto modesetting up mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto moderenaming removed key_buffer and myisam-recover options (if present)mysqld will log errors to /var/log/mysql/error.logmysqld is running as pid 3901created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.setting up mysql-server (8.0.32-0ubuntu0.22.04.2) ...processing triggers for man-db (2.10.2-1) ...processing triggers for libc-bin (2.35-0ubuntu3.1) ...我们看到mysqld is running as pid 3901，说明mysql服务已经启动，当然我们也可以用命令sudo service mysql status来查看信息：
cat@lubancat:~/lugl/my_project$ sudo service mysql status● mysql.service - mysql community server loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) active: active (running) since wed 2023-04-26 18:07:49 cst; 4min 35s ago process: 4076 execstartpre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/success) main pid: 4084 (mysqld) status: server is operational memory: 364.6m cpu: 7.808s cgroup: /system.slice/mysql.service └─4084 /usr/sbin/mysqld进入mysql控制台：cat@lubancat:~/lugl/my_project$ sudo mysqlwelcome to the mysql monitor. commands end with ; or \\g.your mysql connection id is 8server version: 8.0.32-0ubuntu0.22.04.2 (ubuntu)copyright (c) 2000, 2023, oracle and/or its affiliates.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>在这里我就可以进入命令行的日常操作了
mysql> select user,authentication_string,plugin,host from mysql.user;+------------------+------------------------------------------------------------------------+-----------------------+-----------+| user | authentication_string | plugin | host |+------------------+------------------------------------------------------------------------+-----------------------+-----------+| debian-sys-maint | $a$005$}zcg'crfv3c8yinxkte5t9evbgjaoj45trkiyxqp4fyygikl.uambrqdlc | caching_sha2_password | localhost || mysql.infoschema | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || mysql.session | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || mysql.sys | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || root | | auth_socket | localhost |+------------------+------------------------------------------------------------------------+-----------------------+-----------+5 rows in set (0.01 sec)输入以下命修改登录密码
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'temppwd123@' -> ;query ok, 0 rows affected (0.25 sec)mysql> flush privileges;query ok, 0 rows affected (0.04 sec)mysql>完成后，我们需要确认 root 用户不再使用 auth_socket 进行身份验证。通过再次运行以下命令来执行此操作。
mysql> create user 'root'@'192.168.3.192' identified by 'password'
-> ^c
mysql> create user 'root'@'192.168.3.192' identified by 'temppwd123@';
query ok, 0 rows affected (0.07 sec)
mysql> grant all privileges on . to 'root'@'192.168.3.192' with grant option
-> ;
query ok, 0 rows affected (0.07 sec)
mysql> flush privileges;
query ok, 0 rows affected (0.03 sec)
mysql>
安装pymysql执行sudo apt install python3-pymysql
测试cat@lubancat:~$ python3python 3.10.6 (main, mar 10 2023, 10:55:28) [gcc 11.3.0] on linuxtype help, copyright, credits or license for more information.>>> import pymysql>>> conn = pymysql.connect(host='127.0.0.1',database='mysql',user='root',password='temppwd123@')>>> print(conn)到此，mysql了安装成功，并完成了测试。
P沟MOSFET,P沟MOSFET是什么意思
机器人国产芯片（三）：更多的优质厂商，更汹涌的机器人换芯潮
高可靠性超薄高效率单路输出医疗电源-CUS150M1
液流储能电池特点
工业PCBA清洗设备需要满足哪些要求？
【鲁班猫门禁系统】安装mysql
A10200产品介绍
eval和ast.literal_eavl区别
我心中的MWC：那些值得期待的移动处理器
技术解读：小米CyberDog中文名为“铁蛋”，仿生机器人有多难？
5G有望改变4G时代射频前端的“模组鸿沟”
大功率电机停机跳闸的原因及解决
基于USB的硬度计数据通信的实现
物联网时代网页设计可能不好过了
长江存储发布严正声明
普渡科技携多款智能机器人产品亮相第十届中国电子信息博览会
到底要不要升级苹果iOS 15呢
关于低功耗传感器LIS2DW12TR3轴加速度计测量精度剖析
单表多用户模块化智能电表系统的原理及设计
意法半导体:存储器产品解决方案
cat@lubancat:~/lugl/my_project$ sudo apt install mysql-serverreading package lists... donebuilding dependency tree... donereading state information... donethe following packages were automatically installed and are no longer required: accountsservice-ubuntu-schemas activity-log-manager apg aptdaemon aptdaemon-data cracklib-runtime gedit gedit-common gir1.2-accountsservice-1.0 gir1.2-adw-1 gir1.2-gck-1 gir1.2-gcr-3 gir1.2-gdesktopenums-3.0 gir1.2-gdm-1.0 gir1.2-geoclue-2.0 gir1.2-gnomebluetooth-3.0 gir1.2-gnomedesktop-3.0 gir1.2-graphene-1.0 gir1.2-gtk-4.0 gir1.2-gtksource-4 gir1.2-gweather-3.0 gir1.2-javascriptcoregtk-4.0 gir1.2-json-1.0 gir1.2-mutter-10 gir1.2-nma-1.0 gir1.2-peas-1.0 gir1.2-rsvg-2.0 gir1.2-soup-2.4 gir1.2-upowerglib-1.0 gir1.2-vte-2.91 gkbd-capplet gnome-bluetooth-3-common gnome-bluetooth-common gnome-control-center-data gnome-control-center-faces gnome-menus gnome-remote-desktop gnome-settings-daemon gnome-shell-common gsfonts imagemagick-6-common language-selector-gnome libabsl20210324 libadwaita-1-0 libcolord-gtk1 libcrack2 libdca0 libde265-0 libdee-1.0-4 libdjvulibre-text libdjvulibre21 libebackend-1.2-10 libebook-1.2-20 libebook-contacts-1.2-3 libedata-book-1.2-26 libedata-cal-2.0-1 libfaad2 libfftw3-double3 libfluidsynth3 libfreeaptx0 libfreerdp-client2-2 libfreerdp-server2-2 libfreerdp2-2 libgdm1 libgeoclue-2-0 libgeocode-glib0 libgeonames-common libgeonames0 libgjs0g libgnome-autoar-0-0 libgnome-bluetooth-3.0-13 libgnome-bluetooth13 libgnome-menu-3-0 libgnomekbd8 libgsound0 libgspell-1-2 libgspell-1-common libgssdp-1.2-0 libgtksourceview-4-0 libgtksourceview-4-common libgupnp-1.2-1 libgupnp-av-1.0-3 libgupnp-igd-1.0-4 libgweather-3-16 libgweather-common libheif1 libinstpatch-1.0-2 libjxr-tools libjxr0 libkate1 liblqr-1-0 libltc11 libmagickcore-6.q16-6 libmagickcore-6.q16-6-extra libmagickwand-6.q16-6 libmediaart-2.0-0 libmjpegutils-2.1-0 libmodplug1 libmozjs-102-0 libmpcdec6 libmpeg2encpp-2.1-0 libmplex2-2.1-0 libmutter-10-0 libnice10 libopenh264-6 libopenni2-0 libpeas-1.0-0 libpeas-common libphonenumber8 libprotobuf23 libpulsedsp libpwquality-common libpwquality1 libqrencode4 libqt5multimedia5 libqt5multimediaquick5 libqt5multimediawidgets5 librest-0.7-0 librygel-core-2.6-2 librygel-db-2.6-2 librygel-renderer-2.6-2 librygel-server-2.6-2 libsoundtouch1 libsoup-gnome2.4-1 libspandsp2 libspeexdsp1 libsrtp2-1 libtimezonemap-data libtimezonemap1 libtumbler-1-0 libunity-control-center1 libvncserver1 libvo-aacenc0 libvo-amrwbenc0 libwhoopsie-preferences0 libwildmidi2 libwinpr2-2 libwmflite-0.2-7 libxcb-xv0 libxcvt0 libzbar0 libzeitgeist-2.0-0 libzxingcore1 mutter-common power-profiles-daemon pulseaudio-utils python3-aptdaemon python3-aptdaemon.gtk3widgets python3-defer python3-macaroonbakery python3-nacl python3-protobuf python3-pymacaroons python3-rfc3339 python3-tz qml-module-qtmultimedia switcheroo-control timgm6mb-soundfont tumbler-common ubuntu-wallpapers ubuntu-wallpapers-jammy whoopsie whoopsie-preferences xwayland yaru-theme-gnome-shell zeitgeist-core zenity-commonuse 'sudo apt autoremove' to remove them.the following additional packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl libmecab2 libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0 mysql-server-core-8.0suggested packages: libipc-sharedcache-perl mailx tinycathe following new packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl libmecab2 libprotobuf-lite23 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server mysql-server-8.0 mysql-server-core-8.00 upgraded, 18 newly installed, 0 to remove and 95 not upgraded.need to get 28.4 mb of archives.after this operation, 236 mb of additional disk space will be used.do you want to continue? [y/n] yget:1 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mysql-common all 5.8+1.0.8 [7212 b]get:2 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-client-core-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [2877 kb]get:3 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-client-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [22.7 kb]get:4 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libaio1 arm64 0.3.112-13build1 [7018 b]get:5 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libmecab2 arm64 0.996-14build9 [188 kb]get:6 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 libprotobuf-lite23 arm64 3.12.4-1ubuntu7.22.04.1 [192 kb]get:7 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server-core-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [16.9 mb]get:8 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server-8.0 arm64 8.0.32-0ubuntu0.22.04.2 [1230 kb]get:9 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libcgi-pm-perl all 4.54-1 [188 kb]get:10 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi0ldbl arm64 2.4.2-2build2 [28.0 kb]get:11 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi-perl arm64 0.82+ds-1build1 [22.3 kb]get:12 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libcgi-fast-perl all 1:2.15-1 [10.5 kb]get:13 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libfcgi-bin arm64 2.4.2-2build2 [10.7 kb]get:14 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 libhtml-template-perl all 2.97-1.1 [59.1 kb]get:15 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-utils arm64 0.996-14build9 [4830 b]get:16 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-ipadic all 2.7.0-20070801+main-3 [6718 kb]get:17 http://mirrors.ustc.edu.cn/ubuntu-ports jammy/main arm64 mecab-ipadic-utf8 all 2.7.0-20070801+main-3 [4384 b]get:18 http://mirrors.ustc.edu.cn/ubuntu-ports jammy-security/main arm64 mysql-server all 8.0.32-0ubuntu0.22.04.2 [9458 b]fetched 28.4 mb in 2s (11.9 mb/s)preconfiguring packages ...selecting previously unselected package mysql-common.(reading database ... 159629 files and directories currently installed.)preparing to unpack .../0-mysql-common_5.8+1.0.8_all.deb ...unpacking mysql-common (5.8+1.0.8) ...selecting previously unselected package mysql-client-core-8.0.preparing to unpack .../1-mysql-client-core-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package mysql-client-8.0.preparing to unpack .../2-mysql-client-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package libaio1:arm64.preparing to unpack .../3-libaio1_0.3.112-13build1_arm64.deb ...unpacking libaio1:arm64 (0.3.112-13build1) ...selecting previously unselected package libmecab2:arm64.preparing to unpack .../4-libmecab2_0.996-14build9_arm64.deb ...unpacking libmecab2:arm64 (0.996-14build9) ...selecting previously unselected package libprotobuf-lite23:arm64.preparing to unpack .../5-libprotobuf-lite23_3.12.4-1ubuntu7.22.04.1_arm64.deb ...unpacking libprotobuf-lite23:arm64 (3.12.4-1ubuntu7.22.04.1) ...selecting previously unselected package mysql-server-core-8.0.preparing to unpack .../6-mysql-server-core-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up mysql-common (5.8+1.0.8) ...update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto modeselecting previously unselected package mysql-server-8.0.(reading database ... 159843 files and directories currently installed.)preparing to unpack .../00-mysql-server-8.0_8.0.32-0ubuntu0.22.04.2_arm64.deb ...unpacking mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...selecting previously unselected package libcgi-pm-perl.preparing to unpack .../01-libcgi-pm-perl_4.54-1_all.deb ...unpacking libcgi-pm-perl (4.54-1) ...selecting previously unselected package libfcgi0ldbl:arm64.preparing to unpack .../02-libfcgi0ldbl_2.4.2-2build2_arm64.deb ...unpacking libfcgi0ldbl:arm64 (2.4.2-2build2) ...selecting previously unselected package libfcgi-perl:arm64.preparing to unpack .../03-libfcgi-perl_0.82+ds-1build1_arm64.deb ...unpacking libfcgi-perl:arm64 (0.82+ds-1build1) ...selecting previously unselected package libcgi-fast-perl.preparing to unpack .../04-libcgi-fast-perl_1%3a2.15-1_all.deb ...unpacking libcgi-fast-perl (1:2.15-1) ...selecting previously unselected package libfcgi-bin.preparing to unpack .../05-libfcgi-bin_2.4.2-2build2_arm64.deb ...unpacking libfcgi-bin (2.4.2-2build2) ...selecting previously unselected package libhtml-template-perl.preparing to unpack .../06-libhtml-template-perl_2.97-1.1_all.deb ...unpacking libhtml-template-perl (2.97-1.1) ...selecting previously unselected package mecab-utils.preparing to unpack .../07-mecab-utils_0.996-14build9_arm64.deb ...unpacking mecab-utils (0.996-14build9) ...selecting previously unselected package mecab-ipadic.preparing to unpack .../08-mecab-ipadic_2.7.0-20070801+main-3_all.deb ...unpacking mecab-ipadic (2.7.0-20070801+main-3) ...selecting previously unselected package mecab-ipadic-utf8.preparing to unpack .../09-mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb ...unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...selecting previously unselected package mysql-server.preparing to unpack .../10-mysql-server_8.0.32-0ubuntu0.22.04.2_all.deb ...unpacking mysql-server (8.0.32-0ubuntu0.22.04.2) ...setting up libmecab2:arm64 (0.996-14build9) ...setting up mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up libfcgi0ldbl:arm64 (2.4.2-2build2) ...setting up libcgi-pm-perl (4.54-1) ...setting up libfcgi-bin (2.4.2-2build2) ...setting up libhtml-template-perl (2.97-1.1) ...setting up libprotobuf-lite23:arm64 (3.12.4-1ubuntu7.22.04.1) ...setting up mecab-utils (0.996-14build9) ...setting up mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up libfcgi-perl:arm64 (0.82+ds-1build1) ...setting up libaio1:arm64 (0.3.112-13build1) ...setting up mecab-ipadic (2.7.0-20070801+main-3) ...compiling ipa dictionary for mecab. this takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% |###########################################|/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/postp.csv ... 146reading /usr/share/mecab/dic/ipadic/noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/filler.csv ... 19reading /usr/share/mecab/dic/ipadic/others.csv ... 2reading /usr/share/mecab/dic/ipadic/noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/symbol.csv ... 208reading /usr/share/mecab/dic/ipadic/prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/noun.org.csv ... 16668emitting double-array: 100% |###########################################|reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% |###########################################|done!update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto modesetting up libcgi-fast-perl (1:2.15-1) ...setting up mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...setting up mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...compiling ipa dictionary for mecab. this takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% |###########################################|/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/postp.csv ... 146reading /usr/share/mecab/dic/ipadic/noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/filler.csv ... 19reading /usr/share/mecab/dic/ipadic/others.csv ... 2reading /usr/share/mecab/dic/ipadic/noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/symbol.csv ... 208reading /usr/share/mecab/dic/ipadic/prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/noun.org.csv ... 16668emitting double-array: 100% |###########################################|reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% |###########################################|done!update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto modesetting up mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto moderenaming removed key_buffer and myisam-recover options (if present)mysqld will log errors to /var/log/mysql/error.logmysqld is running as pid 3901created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.setting up mysql-server (8.0.32-0ubuntu0.22.04.2) ...processing triggers for man-db (2.10.2-1) ...processing triggers for libc-bin (2.35-0ubuntu3.1) ...我们看到mysqld is running as pid 3901，说明mysql服务已经启动，当然我们也可以用命令sudo service mysql status来查看信息：
cat@lubancat:~/lugl/my_project$ sudo service mysql status● mysql.service - mysql community server loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) active: active (running) since wed 2023-04-26 18:07:49 cst; 4min 35s ago process: 4076 execstartpre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/success) main pid: 4084 (mysqld) status: server is operational memory: 364.6m cpu: 7.808s cgroup: /system.slice/mysql.service └─4084 /usr/sbin/mysqld进入mysql控制台：cat@lubancat:~/lugl/my_project$ sudo mysqlwelcome to the mysql monitor. commands end with ; or \\g.your mysql connection id is 8server version: 8.0.32-0ubuntu0.22.04.2 (ubuntu)copyright (c) 2000, 2023, oracle and/or its affiliates.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>在这里我就可以进入命令行的日常操作了
mysql> select user,authentication_string,plugin,host from mysql.user;+------------------+------------------------------------------------------------------------+-----------------------+-----------+| user | authentication_string | plugin | host |+------------------+------------------------------------------------------------------------+-----------------------+-----------+| debian-sys-maint | $a$005$}zcg'crfv3c8yinxkte5t9evbgjaoj45trkiyxqp4fyygikl.uambrqdlc | caching_sha2_password | localhost || mysql.infoschema | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || mysql.session | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || mysql.sys | $a$005$thisisacombinationofinvalidsaltandpasswordthatmustneverbrbeused | caching_sha2_password | localhost || root | | auth_socket | localhost |+------------------+------------------------------------------------------------------------+-----------------------+-----------+5 rows in set (0.01 sec)输入以下命修改登录密码
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'temppwd123@' -> ;query ok, 0 rows affected (0.25 sec)mysql> flush privileges;query ok, 0 rows affected (0.04 sec)mysql>完成后，我们需要确认 root 用户不再使用 auth_socket 进行身份验证。通过再次运行以下命令来执行此操作。
mysql> create user 'root'@'192.168.3.192' identified by 'password'
-> ^c
mysql> create user 'root'@'192.168.3.192' identified by 'temppwd123@';
query ok, 0 rows affected (0.07 sec)
mysql> grant all privileges on . to 'root'@'192.168.3.192' with grant option
-> ;
query ok, 0 rows affected (0.07 sec)
mysql> flush privileges;
query ok, 0 rows affected (0.03 sec)
mysql>
安装pymysql执行sudo apt install python3-pymysql
测试cat@lubancat:~$ python3python 3.10.6 (main, mar 10 2023, 10:55:28) [gcc 11.3.0] on linuxtype help, copyright, credits or license for more information.>>> import pymysql>>> conn = pymysql.connect(host='127.0.0.1',database='mysql',user='root',password='temppwd123@')>>> print(conn)到此，mysql了安装成功，并完成了测试。
P沟MOSFET,P沟MOSFET是什么意思
机器人国产芯片（三）：更多的优质厂商，更汹涌的机器人换芯潮
高可靠性超薄高效率单路输出医疗电源-CUS150M1
液流储能电池特点
工业PCBA清洗设备需要满足哪些要求？
【鲁班猫门禁系统】安装mysql
A10200产品介绍
eval和ast.literal_eavl区别
我心中的MWC：那些值得期待的移动处理器
技术解读：小米CyberDog中文名为“铁蛋”，仿生机器人有多难？
5G有望改变4G时代射频前端的“模组鸿沟”
大功率电机停机跳闸的原因及解决
基于USB的硬度计数据通信的实现
物联网时代网页设计可能不好过了
长江存储发布严正声明
普渡科技携多款智能机器人产品亮相第十届中国电子信息博览会
到底要不要升级苹果iOS 15呢
关于低功耗传感器LIS2DW12TR3轴加速度计测量精度剖析
单表多用户模块化智能电表系统的原理及设计
意法半导体:存储器产品解决方案