Related

Product Now Available: Managed MySQL Databases Product
phpMyAdmin File Limit Question Question
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question

Question

max_user_connection in my website

Posted August 22, 2015 2k views
MySQLPHPPHP Frameworks

Hi,

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.

thanks

Add a comment
aladySG
By:
aladySG
Add a comment

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.

×
1 answer
jmarhee August 25, 2015

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.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help