【SH】Ubuntu Server 24服务器搭建MySQL数据库研发笔记
文章目录
- 搭建服务器
- 在线安装
- 1. 更新软件包列表
- 2. 安装MySQL
- 3. 检查MySQL状态
- 4. 修改密码
- 5. 新增用户
- 6. 设置局域网访问
- 离线安装
- 下载安装包
- 常用命令
- 参考文档
- 在线安装日志
搭建服务器
作者羊大侠搭建的是 Ubuntu Server 24.04 LTS 服务器环境
搭建参考文档：【SH】VMware虚拟机安装Ubuntu Server 24系统研发笔记
在线安装
1. 更新软件包列表
sudo apt update 在进行任何软件安装之前，请确保你的系统的软件包列表是最新的。
2. 安装MySQL
查看可使用的安装包 sudo apt search mysql-sever，安装指定版本 sudo apt install mysql-server-8.0
# 安装最新版本
sudo apt install mysql-server
# 安装指定版本
sudo apt install mysql-server-8.0
sh@sheephero:~$ sudo apt install mysql-server-8.0
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7t64 libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perllibhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite32t64libtimedate-perl liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-core-8.0
Suggested packages:libdata-dump-perl libipc-sharedcache-perl libio-compress-brotli-perl libbusiness-isbn-perl libregexp-ipv6-perl libwww-perl mailx tinyca
The following NEW packages will be installed:libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7t64 libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perllibhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite32t64libtimedate-perl liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0mysql-server-core-8.0
0 upgraded, 27 newly installed, 0 to remove and 68 not upgraded.
Need to get 29.6 MB of archives.
After this operation, 242 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
3. 检查MySQL状态
sudo systemctl status mysql 查看运行情况
# 安装完成后，MySQL服务会自动启动，未启动则使用以下命令启动MySQL服务
sudo systemctl start mysql
# 将MySQL设置为开机自启动
sudo systemctl enable mysql
# 检查MySQL状态
sudo systemctl status mysql
# mysql安装位置
sh@sheephero:~$ which mysql
/usr/bin/mysql
4. 修改密码
默认安装是没有设置密码的，需要我们自己设置密码。
# 登录mysql，在默认安装时如果没有让我们设置密码，则直接回车就能登录成功。
sudo mysql -uroot -p
# 设置密码 mysql8.0
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
# 刷新缓存
FLUSH PRIVILEGES;
5. 新增用户
# 创建新用户并设置密码：
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
# 授予用户权限：
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' WITH GRANT OPTION; # 所有数据库的所有权限
# 或者（运行一句即可）
GRANT ALL PRIVILEGES ON `数据库名字`.* TO '用户名'@'%'; # 特定数据库
# 刷新权限：
FLUSH PRIVILEGES;
这里的WITH GRANT OPTION允许将其拥有的权限授予其他用户。
6. 设置局域网访问
修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf，将bind-address = 127.0.0.0修改为bind-address = 0.0.0.0，保存重启mysql服务sudo systemctl restart mysql
# 退出mysql
mysql> exit;
Bye
sh@sheephero:~$ cd /etc/mysql/mysql.conf.d/
sh@sheephero:/etc/mysql/mysql.conf.d$ ls
mysql.cnf mysqld.cnf
sh@sheephero:/etc/mysql/mysql.conf.d$ sudo vim mysqld.cnf
sh@sheephero:/etc/mysql/mysql.conf.d$ sudo systemctl restart mysql
sh@sheephero:/etc/mysql/mysql.conf.d$
这样你就可以通过Windows平台常用的数据库管理工具查看安装在服务器上的MySQL数据库啦！🤡
离线安装
下载安装包
下载地址：https://dev.mysql.com/downloads/mysql/
作者选择的是：【DEB Package, MySQL Server】【mysql-community-server_8.4.3-1ubuntu24.04_amd64.deb】【65.8K】
安装包已进行资源绑定，可以自行下载。
常用命令
| 命令 | 说明 |
|---|---|
| sudo systemctl start mysql | 启动服务 |
| sudo systemctl enable mysql | 开机启动 |
| sudo systemctl status mysql | 检查状态 |
| sudo systemctl restart mysql | 重启服务 |
| sudo systemctl stop mysql | 关闭服务 |
| sudo mysql -u root -p | 连接数据库 |
| which mysql | 查看安装位置 |
参考文档
【1】在Ubuntu 22.04 LTS 上安装 MySQL两种方式：在线方式和离线方式
在线安装日志
sh@sheephero:~$ sudo apt install mysql-server-8.0
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7t64 libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perllibhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite32t64libtimedate-perl liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-core-8.0
Suggested packages:libdata-dump-perl libipc-sharedcache-perl libio-compress-brotli-perl libbusiness-isbn-perl libregexp-ipv6-perl libwww-perl mailx tinyca
The following NEW packages will be installed:libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7t64 libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perllibhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite32t64libtimedate-perl liburi-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0mysql-server-core-8.0
0 upgraded, 27 newly installed, 0 to remove and 68 not upgraded.
Need to get 29.6 MB of archives.
After this operation, 242 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 mysql-common all 5.8+1.1.0build1 [6,746 B]
Get:2 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble-updates/main amd64 mysql-client-core-8.0 amd64 8.0.40-0ubuntu0.24.04.1 [2,765 kB]
Get:3 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble-updates/main amd64 mysql-client-8.0 amd64 8.0.40-0ubuntu0.24.04.1 [22.5 kB]
Get:4 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libevent-pthreads-2.1-7t64 amd64 2.1.12-stable-9ubuntu2 [7,982 B]
Get:5 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libmecab2 amd64 0.996-14ubuntu4 [201 kB]
Get:6 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libprotobuf-lite32t64 amd64 3.21.12-8.2build1 [238 kB]
Get:7 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble-updates/main amd64 mysql-server-core-8.0 amd64 8.0.40-0ubuntu0.24.04.1 [17.5 MB]
Get:8 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble-updates/main amd64 mysql-server-8.0 amd64 8.0.40-0ubuntu0.24.04.1 [1,432 kB]
Get:9 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libhtml-tagset-perl all 3.20-6 [11.3 kB]
Get:10 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 liburi-perl all 5.27-1 [88.0 kB]
Get:11 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libhtml-parser-perl amd64 3.81-1build3 [85.8 kB]
Get:12 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libcgi-pm-perl all 4.63-1 [185 kB]
Get:13 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libfcgi0t64 amd64 2.4.2-2.1build1 [26.8 kB]
Get:14 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libfcgi-perl amd64 0.82+ds-3build2 [21.7 kB]
Get:15 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libcgi-fast-perl all 1:2.17-1 [10.3 kB]
Get:16 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libclone-perl amd64 0.46-1build3 [10.7 kB]
Get:17 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libencode-locale-perl all 1.05-3 [11.6 kB]
Get:18 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libfcgi-bin amd64 2.4.2-2.1build1 [11.2 kB]
Get:19 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libhtml-template-perl all 2.97-2 [60.2 kB]
Get:20 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libtimedate-perl all 2.3300-2 [34.0 kB]
Get:21 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libhttp-date-perl all 6.06-1 [10.2 kB]
Get:22 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libio-html-perl all 1.004-3 [15.9 kB]
Get:23 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 liblwp-mediatypes-perl all 6.04-2 [20.1 kB]
Get:24 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 libhttp-message-perl all 6.45-1ubuntu1 [78.2 kB]
Get:25 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 mecab-utils amd64 0.996-14ubuntu4 [4,804 B]
Get:26 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 mecab-ipadic all 2.7.0-20070801+main-3 [6,718 kB]
Get:27 http://mirrors.tuna.tsinghua.edu.cn/ubuntu noble/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-3 [4,384 B]
Fetched 29.6 MB in 3s (9,339 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 121855 files and directories currently installed.)
Preparing to unpack .../0-mysql-common_5.8+1.1.0build1_all.deb ...
Unpacking mysql-common (5.8+1.1.0build1) ...
Selecting previously unselected package mysql-client-core-8.0.
Preparing to unpack .../1-mysql-client-core-8.0_8.0.40-0ubuntu0.24.04.1_amd64.deb ...
Unpacking mysql-client-core-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../2-mysql-client-8.0_8.0.40-0ubuntu0.24.04.1_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Selecting previously unselected package libevent-pthreads-2.1-7t64:amd64.
Preparing to unpack .../3-libevent-pthreads-2.1-7t64_2.1.12-stable-9ubuntu2_amd64.deb ...
Unpacking libevent-pthreads-2.1-7t64:amd64 (2.1.12-stable-9ubuntu2) ...
Selecting previously unselected package libmecab2:amd64.
Preparing to unpack .../4-libmecab2_0.996-14ubuntu4_amd64.deb ...
Unpacking libmecab2:amd64 (0.996-14ubuntu4) ...
Selecting previously unselected package libprotobuf-lite32t64:amd64.
Preparing to unpack .../5-libprotobuf-lite32t64_3.21.12-8.2build1_amd64.deb ...
Unpacking libprotobuf-lite32t64:amd64 (3.21.12-8.2build1) ...
Selecting previously unselected package mysql-server-core-8.0.
Preparing to unpack .../6-mysql-server-core-8.0_8.0.40-0ubuntu0.24.04.1_amd64.deb ...
Unpacking mysql-server-core-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Setting up mysql-common (5.8+1.1.0build1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 122074 files and directories currently installed.)
Preparing to unpack .../00-mysql-server-8.0_8.0.40-0ubuntu0.24.04.1_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Selecting previously unselected package libhtml-tagset-perl.
Preparing to unpack .../01-libhtml-tagset-perl_3.20-6_all.deb ...
Unpacking libhtml-tagset-perl (3.20-6) ...
Selecting previously unselected package liburi-perl.
Preparing to unpack .../02-liburi-perl_5.27-1_all.deb ...
Unpacking liburi-perl (5.27-1) ...
Selecting previously unselected package libhtml-parser-perl:amd64.
Preparing to unpack .../03-libhtml-parser-perl_3.81-1build3_amd64.deb ...
Unpacking libhtml-parser-perl:amd64 (3.81-1build3) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../04-libcgi-pm-perl_4.63-1_all.deb ...
Unpacking libcgi-pm-perl (4.63-1) ...
Selecting previously unselected package libfcgi0t64:amd64.
Preparing to unpack .../05-libfcgi0t64_2.4.2-2.1build1_amd64.deb ...
Unpacking libfcgi0t64:amd64 (2.4.2-2.1build1) ...
Selecting previously unselected package libfcgi-perl.
Preparing to unpack .../06-libfcgi-perl_0.82+ds-3build2_amd64.deb ...
Unpacking libfcgi-perl (0.82+ds-3build2) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../07-libcgi-fast-perl_1%3a2.17-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.17-1) ...
Selecting previously unselected package libclone-perl:amd64.
Preparing to unpack .../08-libclone-perl_0.46-1build3_amd64.deb ...
Unpacking libclone-perl:amd64 (0.46-1build3) ...
Selecting previously unselected package libencode-locale-perl.
Preparing to unpack .../09-libencode-locale-perl_1.05-3_all.deb ...
Unpacking libencode-locale-perl (1.05-3) ...
Selecting previously unselected package libfcgi-bin.
Preparing to unpack .../10-libfcgi-bin_2.4.2-2.1build1_amd64.deb ...
Unpacking libfcgi-bin (2.4.2-2.1build1) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../11-libhtml-template-perl_2.97-2_all.deb ...
Unpacking libhtml-template-perl (2.97-2) ...
Selecting previously unselected package libtimedate-perl.
Preparing to unpack .../12-libtimedate-perl_2.3300-2_all.deb ...
Unpacking libtimedate-perl (2.3300-2) ...
Selecting previously unselected package libhttp-date-perl.
Preparing to unpack .../13-libhttp-date-perl_6.06-1_all.deb ...
Unpacking libhttp-date-perl (6.06-1) ...
Selecting previously unselected package libio-html-perl.
Preparing to unpack .../14-libio-html-perl_1.004-3_all.deb ...
Unpacking libio-html-perl (1.004-3) ...
Selecting previously unselected package liblwp-mediatypes-perl.
Preparing to unpack .../15-liblwp-mediatypes-perl_6.04-2_all.deb ...
Unpacking liblwp-mediatypes-perl (6.04-2) ...
Selecting previously unselected package libhttp-message-perl.
Preparing to unpack .../16-libhttp-message-perl_6.45-1ubuntu1_all.deb ...
Unpacking libhttp-message-perl (6.45-1ubuntu1) ...
Selecting previously unselected package mecab-utils.
Preparing to unpack .../17-mecab-utils_0.996-14ubuntu4_amd64.deb ...
Unpacking mecab-utils (0.996-14ubuntu4) ...
Selecting previously unselected package mecab-ipadic.
Preparing to unpack .../18-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 .../19-mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb ...
Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
Setting up libprotobuf-lite32t64:amd64 (3.21.12-8.2build1) ...
Setting up libmecab2:amd64 (0.996-14ubuntu4) ...
Setting up mysql-client-core-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Setting up libclone-perl:amd64 (0.46-1build3) ...
Setting up libevent-pthreads-2.1-7t64:amd64 (2.1.12-stable-9ubuntu2) ...
Setting up libfcgi0t64:amd64 (2.4.2-2.1build1) ...
Setting up libhtml-tagset-perl (3.20-6) ...
Setting up liblwp-mediatypes-perl (6.04-2) ...
Setting up libfcgi-bin (2.4.2-2.1build1) ...
Setting up libencode-locale-perl (1.05-3) ...
Setting up mecab-utils (0.996-14ubuntu4) ...
Setting up libio-html-perl (1.004-3) ...
Setting up mysql-server-core-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Setting up libtimedate-perl (2.3300-2) ...
Setting up mysql-client-8.0 (8.0.40-0ubuntu0.24.04.1) ...
Setting up libfcgi-perl (0.82+ds-3build2) ...
Setting up liburi-perl (5.27-1) ...
Setting up mysql-server-8.0 (8.0.40-0ubuntu0.24.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 79557
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /usr/lib/systemd/system/mysql.service.
Setting up libhttp-date-perl (6.06-1) ...
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 ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|done!
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
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 ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|done!
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up libhtml-parser-perl:amd64 (3.81-1build3) ...
Setting up libhttp-message-perl (6.45-1ubuntu1) ...
Setting up libcgi-pm-perl (4.63-1) ...
Setting up libhtml-template-perl (2.97-2) ...
Setting up libcgi-fast-perl (1:2.17-1) ...
Processing triggers for man-db (2.12.0-4build2) ...
Processing triggers for libc-bin (2.39-0ubuntu8.3) ...
Scanning processes...
Scanning linux images...Pending kernel upgrade!
Running kernel version:6.8.0-50-generic
Diagnostics:The currently running kernel version is not the expected kernel version 6.8.0-51-generic.Restarting the system to load the new kernel will not be handled automatically, so you should consider rebooting.No services need to be restarted.No containers need to be restarted.No user sessions are running outdated binaries.No VM guests are running outdated hypervisor (qemu) binaries on this host.
相关文章：
【SH】Ubuntu Server 24服务器搭建MySQL数据库研发笔记
文章目录 搭建服务器在线安装1. 更新软件包列表2. 安装MySQL3. 检查MySQL状态4. 修改密码5. 新增用户6. 设置局域网访问 离线安装下载安装包 常用命令参考文档在线安装日志 搭建服务器 作者羊大侠搭建的是 Ubuntu Server 24.04 LTS 服务器环境 搭建参考文档：【SH】…...
编译原理复习---正则表达式+有穷自动机
适用于电子科技大学编译原理期末考试复习。 1. 正则表达式 正则表达式（Regular Expression，简称regex或regexp）是一种用于描述、匹配和操作文本模式的强大工具。它由一系列字符和特殊符号组成，这些字符和符号定义了一种搜索模式…...
知识图谱+RAG学习
GraphRAG（Graph-based Retrieval-Augmented Generation）是微软在2024年推出的一项开源技术，旨在通过结合知识图谱和检索增强生成（RAG）方法，为大型语言模型（LLM）的数据处理提供全新解…...
消息队列技术的发展历史
消息队列技术的演进历程宛如一幅波澜壮阔的科技画卷，历经多个标志性阶段，各阶段紧密贴合不同的技术需求与市场风向，下面为您详细道来。 第一阶段：消息中间件的起源（1970 年代末期 - 1980 年代中期） 在计算…...
每天40分玩转Django：Django部署
Django部署 一、今日学习内容概述 学习模块重要程度主要内容生产环境配置⭐⭐⭐⭐⭐settings配置、环境变量WSGI服务器⭐⭐⭐⭐⭐Gunicorn配置、性能优化Nginx配置⭐⭐⭐⭐反向代理、静态文件安全设置⭐⭐⭐⭐⭐SSL证书、安全选项 二、生产环境配置 2.1 项目结构调整 mypr…...
搭建Elastic search群集
一、实验环境 二、实验步骤 Elasticsearch 是一个分布式、高扩展、高实时的搜索与数据分析引擎Elasticsearch目录文件： /etc/elasticsearch/elasticsearch.yml#配置文件 /etc/elasticsearch/jvm.options#java虚拟机 /etc/init.d/elasticsearch#服务启动脚本 /e…...
解析 Ingress-Nginx 故障：排查思路与方法
文章目录 一、什么是Ingress-Nginx二、故障排除1.1Ingress-Controller日志和事件检查 Ingress 资源事件检查 Nginx 配置检查使用的服务是否存在调试日志 1.2对 Kubernetes API 服务器的认证服务认证服务账户Kube-Config 1.3使用GDB和Nginx1.4在 Nginx 4.2.5 或其他版本…...
2024 楚慧杯 re wp
go_bytes 附件拖入ida 输入长度为0x28，每两位字符的4bit拼接 与一个常量值经过运算后的值进行异或，并且判断是否相等 脚本 bouquet 附件拖入ida。简单去一下花 构建了一个二叉树，然后递归调用函数 重新排列一下再层序遍历读出即可 zistel 附件…...
【物联网技术与应用】实验10：蜂鸣器实验
实验10 蜂鸣器实验 【实验介绍】 蜂鸣器是音频信号装置。蜂鸣器可分为有源蜂鸣器和无源蜂鸣器。 【实验组件】 ● Arduino Uno主板* 1 ● USB数据线* 1 ● 有源蜂鸣器* 1 ● 无源蜂鸣器* 1 ● 面包板* 1 ● 9V方型电池* 1 ● 跳线若干 【实验原理】 如图所示&#x…...
单片机：实现矩阵键盘控制LCD屏幕（附带源码）
单片机实现矩阵键盘控制LCD屏幕 矩阵键盘（Matrix Keypad）是一种常用的输入设备，广泛应用于嵌入式系统中。在许多嵌入式应用中，我们常常需要通过按键输入来控制系统的功能。结合LCD显示屏，我们可以实现一个简单的界面&…...
鸿蒙Next之包体积极限优化
鸿蒙应用包大小优化全解析 在鸿蒙应用开发中，减小应用包大小对于提升应用下载和安装体验起着关键作用。通过压缩、精简或复用应用中的代码与资源，能有效降低包体积，减少空间占用并加快下载与安装速度。下面详细介绍一下鸿蒙应用包大小优化的…...
Android实战经验篇-log工具
详细代码实现及系列文章请转如下链接 Android实战经验篇-系列文章汇总 Android Display Graphics系列文章-汇总 一、基础知识 1.1 Logging简述 我们写的第一个计算机C程序一般是printf(“Hello world!”);这就是一个log输出。Linux内核有Kernel log以及配套的Log工具&#x…...
DPU编程技术解析与实践应用
一、引言 1.1 研究背景与目的 随着信息技术的飞速发展，数据中心在现代社会中的地位日益凸显，成为支撑各行业数字化转型的关键基础设施。在数据中心内部，数据的处理速度、效率和安全性成为了影响整体性能的核心要素。为了应对不断增长的数据…...
红帽认证的含金量和价值如何？怎么报名红帽认证考试？
红帽企业 Linux（RHEL）是由红帽公司提供的一款商业支持、专为生产环境设计的Linux发行版。随着IT系统和工作负载日益复杂化，底层基础设施及操作系统必须兼具可靠性、可扩展性，并能有效促进性能提升。红帽认证在全球范围享有盛誉&am…...
VS Code Copilot 与 Cursor 对比
选手简介 VS Code Copilot：算是“老牌”编程助手了，虽然Copilot在别的编辑器上也有扩展，不过体验最好的还是VS Code，毕竟都是微软家的所以功能集成更好一些；主要提供的是Complete和Chat能力，也就是代码补全…...
蓝桥杯嵌入式备赛教程(1、led，2、lcd，3、key)
一、工程模版创建流程 第一步 创建新项目 第二步 选择型号和管脚封装 第三步 RCC使能 外部时钟，高速外部时钟 第四步晶振时钟配置 由数据手册7.1可知外部晶振频率为24MHz 最后一项设置为80 按下回车他会自动配置时钟 第五步，如果不勾选可能程序只会…...
取多个集合的交集
1.我们取多个集合的交集，先把各个集合放入list中 List < Set < String > > listnew ArrayList<>();HashSet<String> set1new HashSet<>();set1.add( "A" );set1.add("B" );set1.add("C" );HashSet<…...
如何实现电子发票XML文件的合规性存档？
随着国家税务改革的推进，企业对电子发票的管理和存档要求越来越高。尤其是《财政部 国家税务总局关于进一步深化增值税发票管理改革的通知》（财会〔2023〕18号文）的发布，明确规定了电子发票的存档要求。这为企业在财务管理中的电子…...
IOT、MES、WMS、MOM 和 EPMS 系统综合技术与业务文档
IOT、MES、WMS、MOM 和 EPMS 系统综合技术与业务文档 一、引言 在现代制造业和工业管理领域，IOT（物联网）、MES（制造执行系统）、WMS（仓库管理系统）、MOM（制造运营管理系统ÿ…...
IntelliJ IDEA Docker集成
一、概述 Docker是一种用于在隔离和可复制环境中部署和运行可执行文件的工具。这可能很有用，例如，在与生产相同的环境中测试代码。 IntelliJ IDEA集成了Docker功能，并为创建Docker映像、运行Docker容器、管理Docker Compose应用程序、使用公…...
【react项目】从零搭建react项目[nodejs安装]
〇、模板git下载地址 下载即用的模板地址： http:https://e.coding.net/uijiio/init_app/react_init_app.git ssh:gite.coding.net:uijiio/init_app/react_init_app.git 目前更新至:登录与主页跳转，主页包含菜单和容器区 一、搭建基础空白React项目 1.准备…...
【专题】2024年悦己生活消费洞察报告汇总PDF洞察（附原数据表）
原文链接： https://tecdat.cn/?p38654 在当今时代背景下，社会发展日新月异，人们的生活方式与消费观念正经历深刻变革。MoonFox 月狐数据的《2024 年悦己生活消费洞察报告》聚焦于这一充满活力与变化的消费领域。随着就业、婚姻等社会压力的…...
Github——网页版上传文件夹
第一步：创建一个新的仓库或进入已存在的仓库页面 第二步：点进对应的文件夹下，然后 点击 “Upload files” 第三步：将文件夹拖拽到上传区域 打开资源管理器，将要上传的文件夹从计算机中拖拽到上传区域。 注意…...
LMDeploy 量化部署进阶实践
1 配置LMDeploy环境 1.1 InternStudio开发机创建与环境搭建 打开InternStudio平台，进入如下界面创建环境 在终端中，让我们输入以下指令，来创建一个名为lmdeploy的conda环境，python版本为3.10，创建成功后激活环境并安…...
MFC/C++学习系列之简单记录9——简单加法
MFC/C学习系列之简单记录9——简单加法 前言界面设计控件添加添加变量添加事件 后台代码总结 前言 基本的一些使用已经了解，那么就做个简单的加法来练手吧！ 界面设计 控件添加 在工具箱中选择Edit control和Static Text两个控件，分别设置为…...
二分查找题目：两球之间的磁力
文章目录 题目标题和出处难度题目描述要求示例数据范围 解法思路和算法代码复杂度分析 题目 标题和出处 标题：两球之间的磁力 出处：1552. 两球之间的磁力 难度 5 级 题目描述 要求 在代号为地球 C-137 的世界中，Rick 发现如果他将两个…...
OpenCV相机标定与3D重建(28)估计两个三维点集之间的最优平移变换函数estimateTranslation3D()的使用
操作系统：ubuntu22.04 OpenCV版本：OpenCV4.9 IDE:Visual Studio Code 编程语言：C11 算法描述 计算两个3D点集之间的最优平移。 它计算 [ x y z ] [ X Y Z ] [ b 1 b 2 b 3 ] \begin{bmatrix} x\\ y\\ z\\ \end{bmatrix} \begin{bmatri…...
UE5仿漫威争锋灵蝶冲刺技能
这两天玩了一下漫威争锋Marvel Rivals，发现是UE5做的，对里面一些角色技能挺感兴趣的，想简单复刻一下技能功能，顺便复习一下学过的知识 首先把摄像机设置调整一下 CameraBoom里搜索lag 把摄像机延迟关掉 ，这样摄像机就…...
CSS盒子模型（溢出隐藏，块级元素和行级元素的居中对齐，元素样式重置）
overflow：值 规定了内容溢出元素框时所发生的事情 visible：内容不会被修剪，会显示在元素框之外，默认值 overflow: visible; hidden：内容会被修剪，溢出内容不可见 overflow: hidden; scroll：内…...
语音增强的损失函数选择
一、最优尺度不变信噪比（OSISNR）损失函数 参考：论文解读 --Optimal scale-invariant signal-to-noise ratio and curriculum learning for monaural multi-spea 最优尺度不变信噪比（OSI-SNR）是一种用于评估信号质量…...