max_user_connection in my website

August 22, 2015 608 views
MySQL PHP PHP Frameworks


Im new here in digital ocean. i made a website here and connect to the database. but the problem is from time to time an error message prompt.. says that..

User ****** already has more than 'maxuserconnections' active connections.

i've search in the net but I can't change the configuration given in the phpmyadmin. many features are have been disable. how can i fix this.


1 Answer

You can modify maxuserconnections in your /etc/my.cnf file on your server; once you raise the limit, just restart MySQL, and you should be good to go. You can verify the new limit using a query like:

SHOW VARIABLES LIKE 'max_user_connections';

to confirm it was updated properly.

Have another answer? Share your knowledge.