I am getting this error : I changed perms tinyint(3) to 30 from 10 for the admin user, i am no SSH expert How do i resolve this. I have a dedicated server.
How to close them, is there any code or string? to check or close the connections! A little help here will help!
You need to kill all processes that using those connections (probably php scripts that never ended up)
Yes, in the code that opens them. You have some program that's using the database that's not closing its connections. No other program can close them - the bug in the program that's not closing connections has to be fixed. Killing the process may or may not fix the problem. (And if the "process" is httpd - IOW, if the problem is with a script you're running on your website - you can't kill the process. Aside from kicking you off the server, the hosting company would probably sue you. You'd be killing every site on that server.)
As you posted this is a dedicated server, you can simply comment out "max_user_connections" from your my.cnf/my.ini file and restart sql or you can just a easily raise "max_user_connections" if its set and then restart sql. #max_user_connections (comment out) or max_user_connections = 200 (raise as needed) It would be better to comment it out completely, also verify that none of your scripts have a persistent connection setting, if it does, make sure to disable it.
I must have some strange bug - all I see in the original post is "How do i resolve this. I have a . "
I know, I saw that in your quote of his post, which is why I made the comment. I was responding thinking he was on shared hosting. I guess I'm not the only one in this room with cataracts - my monitor caught them from me.