Mysql表锁定解决
摘要：
#查看进程SELECT *FROM information_schema.processlistWHERE USER = 'root' AND state LIKE 'Waiting%';#杀掉进程KILL 1475395;#显示user权限SHOW GRANTS FOR root;#开启mysql 连接的ipGRANT ALL ON hiapk_market_debug.* TO 'root'@'localhost' IDENTIFIED BY 'himarket';GRANT ALL ON hiapk_mark 阅读全文
posted @ 2014-03-05 20:07 由来已久 阅读(186) 评论(0) 推荐(0) 编辑
