Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Reset user connection on mysql

Posted on 2010-09-15
6
Medium Priority
?
494 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
In this article, we’ll look at how to deploy ProxySQL.
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

664 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