Mysql表锁定解决

#查看进程
SELECT *
FROM information_schema.processlist
WHERE USER = 'root' AND state LIKE 'Waiting%';
#杀掉进程
KILL 1475395;

#显示user权限
SHOW GRANTS FOR root;

#开启mysql 连接的ip
GRANT ALL ON hiapk_market_debug.* TO 'root'@'localhost' IDENTIFIED BY 'himarket';
GRANT ALL ON hiapk_market_debug.* TO 'root'@'192.168.247.99' IDENTIFIED BY 'himarket';

#显示目前账户@ip的权限信息
SHOW GRANTS FOR root@192.168.247.99;

#更新权限
FLUSH PRIVILEGES;

 

SHOW GRANTS FOR root@192.168.247.41;

#取消用户权限
REVOKE ALL ON hiapk_market_debug.* FROM root@localhost ;
REVOKE ALL ON hiapk_market_debug.* FROM root@192.168.247.99 ;

FLUSH PRIVILEGES ;