Member Avatar for bhuvan83

hi every1
i m using mysql as my back end and it runs on whole on intranet in my office.
the error i m getting is
Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR)
mESSAGE Too many connections
when users r trying to access the webpage.
how can i remove the error.
plz help me out.
thanks in advance

  • 6 Contributors
  • 6 Replies
  • 349 Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by Dr AKM
Member Avatar for GliderPilot

In your code are you closing your database connections? If not, it could caus your database to have many open connections that are not being used.

Might not be the problem but this may hopefully help.

Member Avatar for sliver_752

Try to store the connection string in a session and do all your queries with that stored session string.

When you close that session, connection string will be automatically destroyed.

Member Avatar for doms

same here i was encountered this problem set max connection = 3000 and close your connection every time you establish a connection visit www.caragadatacenter.com

Member Avatar for doms

even in vb.net 2005 mysql database connection ived use backgroundworker to connect constantly in my mysql server every second

Member Avatar for mwasif

Did you try to identify why there are so many connections are being created? Are you closing the connections properly after performing queries? What is the value of max_connections? Workaround has already been suggested above that to increase max_connections value in my.cnf/my.ini. MySQL manual has dedicated a page specifically for this error which you can find here.

Member Avatar for Dr AKM

run this sentence in your mysql:

Set Global max_connections=2000

i used phpmyadmin... so i was good!...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.