MySQL 连接权限修改
select * from mysql.user
修改host为 %
解决mysql 无法修改表结构 死锁问题,事务问题
SELECt
concat( 'KILL ', id, ‘;’ )
FROM
information_schema.PROCESSLIST p INNER
join information_schema.INNODB_TRX x on p.id=x.trx_mysql_thread_id
#查看正在锁的事务
SELECt * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
#查看等待锁的事务
SELECt * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
#首先查询是否锁表
SHOW OPEN TABLES WHERe In_use > 0;
#查询进程
SHOW PROCESSLIST;



