100% Solve This problem - Connection failed SQLSTATE[HY000][1226] User ''database name' has exceeded the 'max_user_connections' resource (current value: 25)
user has exceeded the 'max_user_connections' resource heroku
user has exceeded the 'max_user_connections' resource (current value: 30)
already has more than 'max_user_connections' active connections
already has more than 'max_user_connections' active connections cpanel
mysql max connections per user
max_user_connections in mysql
error 1226 mysql
increase max_user_connections mysql
In Object Explorer, right-click a server and select Properties. Select the Connections node. Under Connections, in the Max number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect simultaneously to the instance of SQL Server.
How to increase max_user_connections in Hostinger’s hPanel ?
If you have hosting of Hostinger, then you follow the steps given below.
Step 1:- First of all you have to open your hpanel, come to Dashboard
Step 2:- Select the domain on which the problem is coming, then you have to type PHP in the search bar.
Step 3:- Then you get to see PHP Configuration option in Advance Option, you have to click on it.
Step 4:- Then you have to click on the PHP Options button
Step 5:- Now you have to increase the number in maxExecutionTIme and maxInputTime, whatever the number is, you have to double it.
Step 6:- Now you have to click on the Save Button foot
Now you can check by refreshing the website, this problem must have been solved.
How to fix max_user_connection problem from Cpanel
If you have cpanel and you are getting the error “Has exceeded the ‘max_user_connections’ resource” then how can you fix this error?
Step 1:- First of all open the cPanel.
Step 2:- Search by entering MultiPHP INI Editor in Cpanel search bar
Step 3:- Now you have to click on MultiPHP INI Editor
Step 4:- Then you get to see this in front of you, now in “select a location” you have to select the domain on which you are getting to see this problem.
Step 5:- Now you have to increase the number in “max_execution_time” and “max_input_time“, if first it has 25, 30 etc then double it.
Step 5:- After increasing the numbers in “max_execution_time” and “max_input_time”, you have to click Apply Button.
Step 6:- After doing this much work, you refresh the website after some time, the error will be removed.