mysql8.0.32升级到8.0.40

上篇8.0.32库的准备:mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No suc-CSDN博客

此篇测试升级到8.0.40

MySQL :: Download MySQL Community Server

root@jyc:~# mysql -u root -pabcd1234
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 9
Server version: 8.0.32 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> create database jyc;
Query OK, 1 row affected (0.00 sec)

mysql> use jyc;
Database changed
mysql> create table test(id int);
Query OK, 0 rows affected (0.02 sec)

mysql> insert into test values(1);
Query OK, 1 row affected (0.01 sec)

mysql> select * from test;
+------+
| id   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

mysql> 

mysql> exit
Bye
root@jyc:~# systemctl stop mysql
root@jyc:~# pwd
/root
root@jyc:~# ll
total 2047552
drwx------  5 root root       4096 Oct 31 12:37 ./
drwxr-xr-x 20 root root       4096 Oct 31 08:08 ../
-rw-------  1 root root       2412 Oct 31 09:34 .bash_history
-rw-r--r--  1 root root       3106 Dec  5  2019 .bashrc
drwx------  2 root root       4096 Oct 31 07:47 .cache/
-rw-r--r--  1 root root  610315332 Oct 31 07:52 mysql-8.0.32-linux-glibc2.12-x86_64.tar.xz
-rw-r--r--  1 root root   60201944 Oct 31 11:31 mysql-8.0.32-linux-glibc2.17-x86_64-minimal.tar.xz
-rw-r--r--  1 root root 1360436040 Oct 31 08:21 mysql-8.0.40-linux-glibc2.12-x86_64.tar.xz
-rw-r--r--  1 root root   60957800 Oct 31 11:30 mysql-8.0.40-linux-glibc2.17-x86_64-minimal.tar.xz
-rw-r--r--  1 root root      68620 Dec 16  2022 mysql-common_8.0.32-1ubuntu22.04_amd64.deb
-rw-r--r--  1 root root    2457710 Oct 31 11:43 mysql-community-client_8.0.32-1ubuntu22.04_amd64.deb
-rw-r--r--  1 root root    2183834 Oct 31 11:52 mysql-community-client-core_8.0.32-1ubuntu22.04_amd64.deb
-rw-------  1 root root        484 Oct 31 12:37 .mysql_history
-rw-r--r--  1 root root        161 Dec  5  2019 .profile
drwx------  3 root root       4096 Oct 31 07:25 snap/
drwx------  2 root root       4096 Oct 31 07:25 .ssh/
-rw-------  1 root root       9170 Oct 31 08:38 .viminfo
root@jyc:~# tar -xvf mysql-8.0.40-linux-glibc2.17-x86_64-minimal.tar.xz
mysql-8.0.40-linux-glibc2.17-x86_64-minimal/bin/
.......

root@jyc:~# 

root@jyc:~# pwd
/root
root@jyc:~# cd /data/
root@jyc:/data# ll
total 16
drwxr-xr-x  4 root  root  4096 Oct 31 08:24 ./
drwxr-xr-x 20 root  root  4096 Oct 31 08:08 ../
drwxr-xr-x 10 mysql mysql 4096 Oct 31 12:37 mysql/
drwxr-xr-x  8 mysql mysql 4096 Oct 31 12:37 mysql_data/
root@jyc:/data# mv mysql mysql.8.0.32
root@jyc:/data# mv /root/mysql-8.0.40-linux-glibc2.17-x86_64-minimal /data/mysql

root@jyc:/data# ll /data/mysql
total 292
drwxr-xr-x  9 root root    4096 Oct 31 12:38 ./
drwxr-xr-x  5 root root    4096 Oct 31 12:39 ../
drwxr-xr-x  2 7161 31415   4096 Sep 18 11:03 bin/
drwxr-xr-x  2 7161 31415   4096 Sep 18 11:03 docs/
drwxr-xr-x  3 7161 31415   4096 Sep 18 11:03 include/
drwxr-xr-x  6 7161 31415   4096 Sep 18 11:03 lib/
-rw-r--r--  1 7161 31415 257478 Sep 18 10:08 LICENSE
drwxr-xr-x  4 7161 31415   4096 Sep 18 11:03 man/
-rw-r--r--  1 7161 31415    666 Sep 18 10:08 README
drwxr-xr-x 28 7161 31415   4096 Sep 18 11:03 share/
drwxr-xr-x  2 7161 31415   4096 Sep 18 11:03 support-files/
root@jyc:/data# mkdir /data/mysql/log
root@jyc:/data# chown -R mysql:mysql /data/mysql

root@jyc:/data# which mysql
/data/mysql/bin/mysql
root@jyc:/data# /data/mysql/bin/mysql -V
/data/mysql/bin/mysql  Ver 8.0.40 for Linux on x86_64 (MySQL Community Server - GPL)
root@jyc:/data# systemctl start mysql
root@jyc:/data# systemctl status mysql
● mysql.service - LSB: start and stop MySQL
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: active (running) since Thu 2024-10-31 12:40:58 UTC; 4s ago
       Docs: man:systemd-sysv-generator(8)
    Process: 7319 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
      Tasks: 39 (limit: 9443)
     Memory: 484.1M
     CGroup: /system.slice/mysql.service
             ├─7355 /bin/sh /data/mysql/bin/mysqld_safe --datadir=/data/mysql_data --pid-file=/data/mysql_data/jyc.pid
             └─7715 /data/mysql/bin/mysqld --basedir=/data/mysql --datadir=/data/mysql_data --plugin-dir=/data/mysql/lib/plugin --user=mysql --log-error=jyc.err --pid-file=/data/mysql_data/jyc.pi>

Oct 31 12:40:48 jyc systemd[1]: Starting LSB: start and stop MySQL...
Oct 31 12:40:48 jyc mysql[7319]: Starting MySQL
Oct 31 12:40:58 jyc mysql[7319]: .......... *
Oct 31 12:40:58 jyc systemd[1]: Started LSB: start and stop MySQL.
root@jyc:/data# ps -ef|grep mysql
root        7355       1  0 12:40 ?        00:00:00 /bin/sh /data/mysql/bin/mysqld_safe --datadir=/data/mysql_data --pid-file=/data/mysql_data/jyc.pid
mysql       7715    7355 44 12:40 ?        00:00:08 /data/mysql/bin/mysqld --basedir=/data/mysql --datadir=/data/mysql_data --plugin-dir=/data/mysql/lib/plugin --user=mysql --log-error=jyc.err --pid-file=/data/mysql_data/jyc.pid --socket=/data/mysql/mysql.sock --port=3306
root        8028    5850  0 12:41 pts/0    00:00:00 grep --color=auto mysql
root@jyc:/data# mysql -u root -pabcd1234
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 10
Server version: 8.0.40 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

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> \h

For information about MySQL products and services, visit:
   http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
   http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other products, visit:
   https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command, if enabled
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
resetconnection(\x) Clean session context.
query_attributes Sets string parameters (name1 value1 name2 value2 ...) for the next query to pick up.
ssl_session_data_print Serializes the current SSL session data to stdout or file

For server side help, type 'help contents'

mysql> \s
--------------
mysql  Ver 8.0.40 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:          10
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.40 MySQL Community Server - GPL
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:            /data/mysql/mysql.sock
Binary data as:         Hexadecimal
Uptime:                 43 sec

Threads: 2  Questions: 11  Slow queries: 0  Opens: 558  Flush tables: 4  Open tables: 37  Queries per second avg: 0.255
--------------

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.40    |

+-----------+
1 row in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| jyc                |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

mysql> use jyc;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from test;
+------+
| id   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

mysql> 

检查日志记录:

root@jyc:/data/mysql_data# systemctl stop mysql
root@jyc:/data/mysql_data# systemctl start mysql
root@jyc:/data/mysql_data# more jyc.err
2024-10-31T12:04:34.179682Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-10-31T12:04:34.179722Z 0 [System] [MY-010116] [Server] /data/mysql/bin/mysqld (mysqld 8.0.32) starting as process 5406
2024-10-31T12:04:34.193901Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-31T12:04:34.436376Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-31T12:04:34.801896Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-31T12:04:34.801957Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-31T12:04:34.835140Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-10-31T12:04:34.835328Z 0 [System] [MY-010931] [Server] /data/mysql/bin/mysqld: ready for connections. Version: '8.0.32'  socket: '/data/mysql/mysql.sock'  port: 3306  MySQL Community Server -
 GPL.
2024-10-31T12:34:59.313115Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.32).
2024-10-31T12:35:00.786434Z 0 [System] [MY-010910] [Server] /data/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.32)  MySQL Community Server - GPL.
2024-10-31T12:35:04.891460Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-10-31T12:35:04.891503Z 0 [System] [MY-010116] [Server] /data/mysql/bin/mysqld (mysqld 8.0.32) starting as process 7190
2024-10-31T12:35:04.908498Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-31T12:35:05.152290Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-31T12:35:05.422534Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-31T12:35:05.422620Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-31T12:35:05.470567Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-10-31T12:35:05.470672Z 0 [System] [MY-010931] [Server] /data/mysql/bin/mysqld: ready for connections. Version: '8.0.32'  socket: '/data/mysql/mysql.sock'  port: 3306  MySQL Community Server -
 GPL.
2024-10-31T12:37:44.192653Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.32).
2024-10-31T12:37:44.868463Z 0 [System] [MY-010910] [Server] /data/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.32)  MySQL Community Server - GPL.
2024-10-31T12:40:49.034557Z 0 [Warning] [MY-011069] [Server] The syntax '--character-set-client-handshake' is deprecated and will be removed in a future release.
2024-10-31T12:40:49.034756Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-10-31T12:40:49.034790Z 0 [System] [MY-010116] [Server] /data/mysql/bin/mysqld (mysqld 8.0.40) starting as process 7715
2024-10-31T12:40:49.050205Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-31T12:40:49.394465Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-31T12:40:52.035278Z 4 [System] [MY-013381] [Server] Server upgrade from '80032' to '80040' started.
2024-10-31T12:40:57.436638Z 4 [System] [MY-013381] [Server] Server upgrade from '80032' to '80040' completed.
2024-10-31T12:40:57.627002Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-31T12:40:57.627074Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-31T12:40:57.667120Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-10-31T12:40:57.667178Z 0 [System] [MY-010931] [Server] /data/mysql/bin/mysqld: ready for connections. Version: '8.0.40'  socket: '/data/mysql/mysql.sock'  port: 3306  MySQL Community Server -
 GPL.
2024-10-31T12:41:19.539816Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use cach
ing_sha2_password instead'
2024-10-31T13:04:54.629658Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.40).
2024-10-31T13:04:55.266680Z 0 [System] [MY-010910] [Server] /data/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.40)  MySQL Community Server - GPL.
2024-10-31T13:05:04.925055Z 0 [Warning] [MY-011069] [Server] The syntax '--character-set-client-handshake' is deprecated and will be removed in a future release.
2024-10-31T13:05:04.925221Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-10-31T13:05:04.925257Z 0 [System] [MY-010116] [Server] /data/mysql/bin/mysqld (mysqld 8.0.40) starting as process 8572
2024-10-31T13:05:04.939248Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-31T13:05:05.217637Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-31T13:05:05.489395Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-10-31T13:05:05.489464Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-10-31T13:05:05.534184Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-10-31T13:05:05.534258Z 0 [System] [MY-010931] [Server] /data/mysql/bin/mysqld: ready for connections. Version: '8.0.40'  socket: '/data/mysql/mysql.sock'  port: 3306  MySQL Community Server -
 GPL.

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:/a/905458.html

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈qq邮箱809451989@qq.com,一经查实,立即删除!

相关文章

高阶数据结构--图(graph)

图&#xff08;graph&#xff09; 1.并查集1. 并查集原理2. 并查集实现3. 并查集应用 2.图的基本概念3. 图的存储结构3.1 邻接矩阵3.2 邻接矩阵的代码实现3.3 邻接表3.4 邻接表的代码实现 4. 图的遍历4.1 图的广度优先遍历4.2 广度优先遍历的代码 1.并查集 1. 并查集原理 在一…

go 聊天系统项目-1

1、登录界面 说明&#xff1a;这一节的内容采用 go mod 管理【GO111MODULE‘’】的模块&#xff0c;从第二节开始使用【GO111MODULE‘off’】GOPATH 管理模块。具体参见 go 包相关知识 1.1登录界面代码目录结构 代码所在目录/Users/zld/Go-project/day8/chatroom/ 1.2登录…

支持向量机背后的数学奥秘

一、基本概念与原理 1.1 支持向量机的定义 支持向量机是一种二分类模型&#xff0c;其核心思想是在样本空间中寻找一个超平面&#xff0c;将不同类别的样本分开。这个超平面被称为决策边界或分隔超平面。支持向量是距离决策边界最近的点&#xff0c;这些点决定了决策边界的位…

C语言指针和数组相关习题

目录 sizeof和一维int数组sizeof和一维char数组strlen()和一维char数组sizeof和字符串strlen()和字符串指针变量指向字符串字面常量易错点sizeof(a):sizeof是操作符 当心整型提升sizeof和二维数组复习一下相关知识点练习题 一个离谱的错误指针1指针2指针3指针4指针5指针6指针7指…

Centos安装ZooKeeper教程(单机版)

本章教程介绍,如何在Centos7中,安装ZooKeeper 3.9.3版本。 一、什么是ZooKeeper ? Apache ZooKeeper 是一个分布式协调服务,用于大型分布式系统中的管理和协调。它为分布式应用提供了一个高性能的通信框架,简化了开发人员在构建复杂分布式系统的任务。ZooKeeper 能够解决一…

出国工作——常用英语——网站注册

Please set your password for your new Qt Account. Password must be at least 8 characters in length. 请为您的新 Qt 账户设置密码。密码长度必须至少为 8 个字符。 Password Password strength: BadThis is similar to a commonly used password. TIP: Add another wor…

江协科技STM32学习- P25 UART串口协议

&#x1f680;write in front&#x1f680; &#x1f50e;大家好&#xff0c;我是黄桃罐头&#xff0c;希望你看完之后&#xff0c;能对你有所帮助&#xff0c;不足请指正&#xff01;共同学习交流 &#x1f381;欢迎各位→点赞&#x1f44d; 收藏⭐️ 留言&#x1f4dd;​…

Servlet 3.0 新特性全解

文章目录 Servlet3.0新特性全解Servlet 3.0 新增特性Servlet3.0的注解Servlet3.0的Web模块支持servlet3.0提供的异步处理提供异步原因实现异步原理配置servlet类成为异步的servlet类具体实现异步监听器改进的ServletAPI(上传文件) Servlet3.0新特性全解 tomcat 7以上的版本都支…

mysql 通过GROUP BY 聚合并且拼接去重另个字段

我的需求&#xff1a; 我想知道同一个手机号出现几次&#xff0c;并且手机号出现在哪些地方。下面是要的效果。 源数据: CREATE TABLE bank (id bigint(20) unsigned NOT NULL AUTO_INCREMENT,user_id int(11) NOT NULL DEFAULT 0,tel varchar(255) COLLATE utf8mb4_unicode_…

新加坡托管服务器VS香港托管服务器:AI时代的选择策略

在人工智能迅速发展的今天&#xff0c;服务器作为数据存储与计算的核心基础设施&#xff0c;其性能、稳定性和地理位置对于用户体验和业务效率至关重要。对于中国用户而言&#xff0c;在选择服务器时&#xff0c;新加坡服务器和香港服务器无疑是两个极具吸引力的选项。两者同属…

Linux的硬盘管理

硬盘有价&#xff0c;数据无价 1. 硬盘的概念 硬盘是一种计算机的存储设备&#xff0c;通常是由一个或者多个磁性盘片组成。硬盘即可以安装在计算机的内部&#xff0c;也可以外接计算机。 保存数据 数据&#xff1a;操作系统&#xff0c;应用程序&#xff0c;文档多媒体文件…

震惊,盖子居然重现CSDN?

盖子奇迹般重回C站 众所周知&#xff0c;盖子上次发布文章是在2024年5月18号&#xff08;感兴趣的可以回去看一下&#xff0c;链接放在下面了&#xff09; 盖子的c小课堂——第二十七讲&#xff1a;背包变形题_恰好装满的01背包-CSDN博客https://blog.csdn.net/m0_73334782/a…

PostgreSQL的学习心得和知识总结(一百五十七)|新的 COPY 选项 LOG_VERBOSITY

目录结构 注&#xff1a;提前言明 本文借鉴了以下博主、书籍或网站的内容&#xff0c;其列表如下&#xff1a; 1、参考书籍&#xff1a;《PostgreSQL数据库内核分析》 2、参考书籍&#xff1a;《数据库事务处理的艺术&#xff1a;事务管理与并发控制》 3、PostgreSQL数据库仓库…

【力扣打卡系列】二叉树的最近公共祖先

坚持按题型打卡&刷&梳理力扣算法题系列&#xff0c;语言为go&#xff0c;Day18 二叉树的最近公共祖先 题目描述 解题思路 最近公共祖先分类讨论 当前节点是空节点&#xff08;返回当前节点&#xff09;当前节点是p&#xff08;返回当前节点&#xff09;当前节点是q&am…

Redis常见面试题总结(上)

Redis 基础 什么是 Redis? Redis &#xff08;REmote DIctionary Server&#xff09;是一个基于 C 语言开发的开源 NoSQL 数据库&#xff08;BSD 许可&#xff09;。与传统数据库不同的是&#xff0c;Redis 的数据是保存在内存中的&#xff08;内存数据库&#xff0c;支持持久…

Training-free layout control with cross-attention guidance

https://zhuanlan.zhihu.com/p/666445024https://zhuanlan.zhihu.com/p/666445024 支持两种模式,1.sd文生图;2.绑定了dreambooth和text inversion的图像编辑。 # ------------------ example input ------------------examples &

‌Spring MVC的主要组件有哪些?

前言 SpringMVC的核心组件包括DispatcherServlet、Controller、HandlerMapping、HandlerAdapter、ViewResolver、ModelAndView等&#xff0c;它们协同工作以支持基于MVC架构的Web应用程序开发。这些组件使得开发人员能够以一种声明式和模块化的方式构建Web应用程序&#xff0c…

Python突破浏览器TLS/JA3 指纹

初识指纹遇到一个网站,忽然发现无论如何如何更换UA和代理请求都是403&#xff0c;curl_cffi 可模拟真实浏览器的 TLS | JA3 指纹。 查看 tls 指纹的网站&#xff1a; https://tls.browserleaks.com/json不同网站的生成的指纹可能有差异&#xff0c;但是多次访问同一个网站生成…

Redis新数据类型

新数据类型 Bitmaps 命令 setbit 实例 getbit 实例 bitcount 实例 bitop 实例 Bitmaps与set 对比 HyperLogLog 命令 pfadd 实例 pfcount 实例 pfmerge 实例 Geospatial 命令 geoadd 实例 geopos 实例 geodist 实例 georadius 实例 Bitmaps Ⅰ.B…

【Qt】QTableView添加下拉框过滤条件

实现通过带复选框的下拉框来为表格添加过滤条件 带复选框的下拉框 .h文件 #pragma once #include <QCheckBox> #include <QComboBox> #include <QEvent> #include <QLineEdit> #include <QListWidget>class TableComboBox : public QComboBox …