Solved

Reset user connection on mysql

Posted on 2010-09-15
6
418 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now