事务查询SELECT @@tx_isolation SELECT r.`trx_id` waiting_trx_id, r.`trx_mysql_thread_id` waiting_thread, r.`trx_query

1 修改 /etc/my.cnf加上 [mysqld] skip-grant-tables 2. 重启mysqlservice mysql restart 3. 更改root密码mysql> USE mysql ;