Solved

Reset user connection on mysql

Posted on 2010-09-15
6
454 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 125 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 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