-1

I am getting error "user has exceeded the 'max_user_connections' resource (current value: 30)".

1 Answer 1

0

Method 1:

Just run the grep command to find the mysql configuration file

$ grep -r "max_user_connections" /etc/mysql

It will point the configuration files, here you can change the value whatever you want.

e.g) max_user_connections = 100

After that we need to restart the mysql server.

Method 2:

You can change the MAX_USER_CONNECTIONS value by run grant mysql command, in this way we can change the value to specific user and host.

mysql> GRANT USAGE ON *.* TO 'user_name'@'localhost' WITH MAX_USER_CONNECTIONS 10;
4
  • By following Method 1 I am getting error: grep: /etc/mysql: No such file or directory Feb 22, 2019 at 8:04
  • By following Method 2 I am getting error: #1045 - Access denied for user 'root'@'localhost' (using password: YES) Feb 22, 2019 at 8:04
  • method1: try this grep -r "max_user_connections" /etc/ Feb 22, 2019 at 8:12
  • How to restart mysql server (any command) Feb 23, 2019 at 5:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.