1.查询全局变量:
SHOW GLOBAL VARIABLES [LIKE '%search key%'];
![](https://img-blog.csdnimg.cn/img_convert/680081dc3a35d3c6f79e29abbe574e75.png)
2.修改全局变量:
SET GLOBAL auto_increment_increment = 1;
3.刷新即时生效
flush privileges
1.查询全局变量:
SHOW GLOBAL VARIABLES [LIKE '%search key%'];
2.修改全局变量:
SET GLOBAL auto_increment_increment = 1;
3.刷新即时生效
flush privileges