MySQL Disable auto-commit settings

MySQL disables auto-commit settings,

Add the following sentence to the My.ini file

init_connect= ' SET autocommit=0 '

But there is a problem, the root user of the autocommit variable query, this value is still 1, that is, also automatically committed

A query that makes autocommit variables for other users, which is 0, that is, does not automatically commit

View variables for autocommit

SELECT @ @autocommit;

Setting the value
SET @ @global. autocommit=1;
FLUSH privileges;

MySQL Disable auto-commit settings