目录
一、p40命令行验证MySQL的隔离级别,grant报错ERROR 1064 (42000)
一、p40命令行验证MySQL的隔离级别,grant报错ERROR 1064 (42000)
mysql> create user jerry@'localhost' identified by 'abc123';
Query OK, 0 rows affected (0.01 sec)
mysql> grant select,insert,delete,update on test.* to jerry@'localhost';
Query OK, 0 rows affected (0.01 sec)
二、查看事务隔离级别
shk写的tx_isolation在8.0已过时,正确写法:
mysql> select @@transaction_isolation;
+-------------------------+
| @@transaction_isolation |
+-------------------------+
| REPEATABLE-READ |
+-------------------------+
1 row in set (0.00 sec)
修改隔离级别: