How to kill mysql process through C#.

Posted by deepesh khatri on Stack Overflow See other posts from Stack Overflow or by deepesh khatri
Published on 2010-05-17T08:46:57Z Indexed on 2010/05/17 8:50 UTC
Read the original article Hit count: 435

Filed under:
|
|

I am getting "too many connections" problem in an Asp .Net Mvc application which get fix when i manually kill process through Mysql v6.56 IDE, But on remote hosting computer where i can't kill process each time how can i fix this error. I have tried making a connection to information_schema DB's PROCESSLIST table but when connection is about to execute command there comes an error "access denied of root@loclahostto information_schema". I also have tried to grant all privileges to root@loclahost but still i am not able to fix this problem. I have been coding the same way from last two years but in this application i am getting this problem i have use close each connection in every method. Please if some one have ever got this problem or know the answer.Please help me. Thanx in advance

© Stack Overflow or respective owner

Related posts about mysql

Related posts about c#