max_user_connections

[darylbewise]

I am using ASP.net to connect to a MySQL database. I think this is a MySQL problem rarther that ASP.net. Please let me know if I have posted in the wrong forum.

This is the first time I have encountered this error:

Error:
Exception information:
Exception type: MySqlException
Exception message: User DATABASE_NAME already has more than 'max_user_connections' active connections

Any suggestion on what the best resolution to this error?

 

[ingresman]

Have a look at this

http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

And do some searches for your particuar version.
What I would say is be carefull, you may be genuinely not have enough connections in which case uet up the limit. But if the connections are not being released at the end of page you may have an issue to correct that.
You can do a show processlist from a mysql client and see if they are being released.