# MariaDB 数据库显示当前的连接配置

**URL:** <https://www.isharkfly.com/t/mariadb/17041>\
**Category:** 数据库\
**Tags:** mariadb, mysql\
**Created:** [March 10, 2025, 6:39pm UTC](https://www.isharkfly.com/t/mariadb/17041 "2025-03-10T18:39:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [March 10, 2025, 6:39pm UTC](https://www.isharkfly.com/t/mariadb/17041/1 "2025-03-10T18:39:16Z")

</div>

在登录数据库后，运行下面的 SQL

```auto
SHOW VARIABLES LIKE '%connect%';

```

## SESSION\_VARIABLES

| Variable\_name | Value |
| --- | --- |
| character\_set\_connection | utf8mb4 |
| collation\_connection | utf8mb4\_general\_ci |
| connect\_timeout | 10 |
| default\_master\_connection | |
| disconnect\_on\_expired\_password | OFF |
| extra\_max\_connections | 1 |
| init\_connect | |
| max\_connect\_errors | 100 |
| max\_connections | 1200 |
| max\_user\_connections | 0 |
| performance\_schema\_session\_connect\_attrs\_size | -1 |

 ![2025-03-10_14-37-23](https://cdn.isharkfly.com/com-isharkfly-www/discourse-uploads/original/3X/b/c/bcd87536c8662e6998cfd96daeff6537b07f89aa.jpeg)

上面的参数显示的是当前数据库可以接受的连接数量。

与我们修改的配置一致。