MySQL 8.4.1 LTS 版本和 9.0 是同一天上线的，都是7月1日，只是大家都聚焦在了 9.0 而没注意到 8.4.1，关于 9.0 的内容请戳这里：
MySQL 8.4.1 变更
MySQL 8.4.1 LTS 的 Rel Notes 已经发布，链接为：
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
对比 MySQL 8.4.1 和 MySQL 9.0.0，有一条变更项未包含在 9.0.0 里。
Authentication Notes
- Improved log messages to provide clear reasons for access denied errors when using the authentication_ldap_sasl plugin without proxying. (Bug #35317691)
关于支持的操作系统，MySQL 8.4.1 可以运行在 Fedora 40 上，意味着即将支持 EL10 平台。目前，仍旧提供了 RHEL 7 的安装包。
同时，提供了 Ubuntu Linux 24.04 和 22.04 的 DEB 安装包，不要再说不支持啦~
MySQL 8.4.1 容器
MySQL 8.4.1 容器镜像已经可以下载了，run 起来。
$ podman run --name m84 -e MYSQL_ROOT_PASSWORD=1 -d mysql:8.4.1
a3d678caa10b1154e9d55a1c28791397d53289a6d6bac7e296dc887b3114c2e6连接容器，查看状态。
$ podman exec -it m84 mysql -uroot -p1
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 8
Server version: 8.4.1 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> \s
--------------
mysql Ver 8.4.1 for Linux on x86_64 (MySQL Community Server - GPL)
Connection id: 8
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.4.1 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Binary data as: Hexadecimal
Uptime: 34 sec
Threads: 2 Questions: 7 Slow queries: 0 Opens: 119 Flush tables: 3 Open tables: 38 Queries per second avg: 0.205
--------------
mysql>MySQL 8.4.1/9.0.0 变化
MySQL 8.4.1 中，全局变量 622 个，全局状态 328 个，关键字 734 个。
-- 8.4.1
mysql> select count(*) from performance_schema.global_variables;
+----------+
| count(*) |
+----------+
| 622 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from performance_schema.global_status;
+----------+
| count(*) |
+----------+
| 328 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from information_schema.keywords;
+----------+
| count(*) |
+----------+
| 734 |
+----------+
1 row in set (0.00 sec)MySQL 9.0.0 中，全局变量 621 个，全局状态 328 个，关键字 735 个。
-- 9.0.0
mysql> select count(*) from performance_schema.global_variables;
+----------+
| count(*) |
+----------+
| 621 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from performance_schema.global_status;
+----------+
| count(*) |
+----------+
| 328 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from information_schema.keywords;
+----------+
| count(*) |
+----------+
| 735 |
+----------+
1 row in set (0.00 sec)少的一个全局变量是什么呢？这在文档里有记载。
mysql_native_password_proxy_users: Whether mysql_native_password authentication plugin does proxying. Removed in MySQL 9.0.0.
mysql_native_password_proxy_users 参数从 MySQL 5.7.7 引入，8.0.16 被废弃，9.0.0 随 mysql_native_password 认证插件一并被移除。
🌻 往期精彩 ▼
[Oracle]
[MySQL]
[TiDB]
[PG]
- [[RL9] Rocky Linux 9.4 搭载 PG 16.1](https://mp.weixin.qq.com/s/-LYgMoaktYXZ1UG5V5neow)
- 即将告别PG 12，建议升级到PG 16.3版本
- 后 EL 7 时代，PG 16 如何在 CentOS 7 上运行
-- / END / --
👉 这里可以找到我
如果这篇文章为你带来了灵感或启发，就请帮忙点『赞』or『在看』or『转发』吧，感谢！ღ( ´･ᴗ･` )~
本文由mdnice多平台发布
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用。你还可以使用@来通知其他用户。