max_user_connection in my website

Posted August 22, 2015 2.3k views
MySQLPHPPHP 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.


These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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.