查看“命令行验证MySQL的隔离级别”的源代码

https://www.bilibili.com/video/BV1eJ411c7rf?p=40

=== 准备 ===
#Windows 下 cmd 进入命令行：<syntaxhighlight lang="powershell">
C:\Users\Administrator>mysql -uroot -p123456
</syntaxhighlight>
#创建一个新用户登录MySQL Server：<syntaxhighlight lang="powershell">
mysql> create user tom identified by 'abc123';
Query OK, 0 rows affected (0.03 sec)
</syntaxhighlight>用户名：tom     密码：abc123
#登录tom：<syntaxhighlight lang="powershell">
C:\Users\Administrator>mysql -utom -pabc123
</syntaxhighlight>
#查看 root 用户可以操作的数据库：<syntaxhighlight lang="powershell">
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db2019             |
| guns               |
| jdbc_test          |
| ke                 |
| m3u8_download      |
| mysql              |
| nacos_config       |
| performance_schema |
| sakila             |
| seata              |
| seata_account      |
| seata_order        |
| seata_storage      |
| sql                |
| sys                |
| world              |
+--------------------+
17 rows in set (0.00 sec)
</syntaxhighlight>
#查看 tom 用户可以操作的数据库：<syntaxhighlight lang="powershell">
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
</syntaxhighlight>
#为 tom 用户授权：<syntaxhighlight lang="powershell">
mysql> grant select,insert,update,delete on jdbc_test.* to tom@localhost identified by 'abc123';
Query OK, 0 rows affected, 1 warning (0.00 sec)
</syntaxhighlight>
#验证 tom 用户得到的授权：<syntaxhighlight lang="powershell">
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| jdbc_test          |
+--------------------+
2 rows in set (0.00 sec)
</syntaxhighlight>

=== 验证 ===

==== 查看初始数据 ====
<syntaxhighlight lang="powershell">
mysql> select * from user_table;
+------+----------+---------+
| user | password | balance |
+------+----------+---------+
| AA   | 123456   |    1000 |
| BB   | 654321   |    1000 |
+------+----------+---------+
2 rows in set (0.00 sec)
</syntaxhighlight>



==== 设置事务不自动提交 ====
tom 和 root 都是<syntaxhighlight lang="powershell">
mysql> set autocommit =false;
Query OK, 0 rows affected (0.00 sec)
</syntaxhighlight>


==== 查看 tom 用户当前的事务隔离级别 ====
<syntaxhighlight lang="powershell">
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation  |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set, 1 warning (0.00 sec)
</syntaxhighlight>