Improve company productivity with a Business Account.Sign Up

x
?
Solved

Reset user connection on mysql

Posted on 2010-09-15
6
Medium Priority
?
517 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:I-Can
  • 3
  • 3
6 Comments
 
LVL 14

Expert Comment

by:shobinsun
ID: 33679788
HI,

Set max_user_connections in php.ini and restart mysql and apache
0
 

Author Comment

by:I-Can
ID: 33679802
the issue i am using online hosting service and con't restart these services
0
 
LVL 14

Expert Comment

by:shobinsun
ID: 33679823
HI,

use ini_set('max_user_connections',500);

in your script
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

Author Comment

by:I-Can
ID: 33679926
i did try it but still getting the same error

i think such setting i have to do it with mysql not php
0
 
LVL 14

Accepted Solution

by:
shobinsun earned 500 total points
ID: 33680243
Hi,

Better to contact the hosting provider to increase the mysql max user connection
0
 

Author Closing Comment

by:I-Can
ID: 33741831
Thanks a lot i called them and they guide me to kill the process responsible for it.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question