[mysqld]
basedir=D:\Program Files\mysql-5.7
datadir=D:\Program Files\mysql-5.7\data
port=3306
skip-grant-tables
创建mysql服务
mysqld –install
mysqld —initialize-insecure —user=mysql

打开mysql服务

net start mysql

事务

隔离级别

  1. read uncommitted 存在脏读
  2. read committed 存在不可重复读
  3. repeatable read 存在幻读
  4. serializable (串行) 效率低
    查看隔离级别
    1. select @@transaction_isolation;

设置隔离级别

设置提交方式

开启事务