Reset user connection on mysql

please i am getting this error through my php application i think i need to reset the established user connections:

Could not connect: User opt_admin already has more than 'max_user_connections' active connections

can some body tell me the best way to reset this.
I-CanAsked:
Who is Participating?
 
shobinsunCommented:
Hi,

Better to contact the hosting provider to increase the mysql max user connection
0
 
shobinsunCommented:
HI,

Set max_user_connections in php.ini and restart mysql and apache
0
 
I-CanAuthor Commented:
the issue i am using online hosting service and con't restart these services
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
shobinsunCommented:
HI,

use ini_set('max_user_connections',500);

in your script
0
 
I-CanAuthor Commented:
i did try it but still getting the same error

i think such setting i have to do it with mysql not php
0
 
I-CanAuthor Commented:
Thanks a lot i called them and they guide me to kill the process responsible for it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.