[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服务
事务
隔离级别
- read uncommitted 存在脏读
- read committed 存在不可重复读
- repeatable read 存在幻读
- serializable (串行) 效率低
查看隔离级别
select @@transaction_isolation;