ERROR [HY000] [MySQL][ODBC 5.1 Driver]User XXX already has more than max_user_connections active connections

Question

User1872364149 posted

hi there, hope in your help.

I use asp net 2 C# and Db MySQL.

In localhost I don't have problems, but in hosting after several pages visited I have this error connection, can you help me?

Error

ERROR [HY000] [MySQL][ODBC 5.1 Driver]User XXX
already has more than 'max_user_connections'
active connections

web.config

  <connectionStrings>
    <clear/>
    <remove name="cs"/>
    <add name="cs" connectionString="Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=XXX;uid=XXX;pwd=XXX;option=3;" providerName="System.Data.Odbc"/>
  </connectionStrings>

Answer 1

User1196771204 posted

hi there,

based on the error message, it looks like the MySQL server is overloaded with tons of connections. You need to check it with your host provider about this issue and your site probably will have to be migrated to the other server

Hope this helps :) 

Answer 2

User1872364149 posted

thank you.