MySQL锁表

1、查询是否锁表
show OPEN TABLES where In_use > 0;
2、查询进程
show processlist
关闭进程
kill id

查看正在锁的事务 
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;  
查看等待锁的事务 
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; 

授权： grant select,insert,update,delete on mylams.PS_QH_DEPT_IF to ‘bdetl_dml’@’%’