Page 1 of 1

How to open MySQL's max_user_connections setting?

Posted: Sat Jul 11, 2015 4:43 am
by kudouyuzi
How to open MySQL's max_user_connections setting? WHMCS 6 need.
https://dev.mysql.com/doc/refman/5.0/en ... urces.html

Re: How to open MySQL's max_user_connections setting?

Posted: Wed Jul 15, 2015 6:44 am
by skurudo
It was a question?

From mysql console, if you use this manual -> ssh and then

Code: Select all

mysql -uroot -ppassword
onwards use manual ;-)

Re: How to open MySQL's max_user_connections setting?

Posted: Wed Jul 15, 2015 8:06 am
by kudouyuzi
skurudo wrote:It was a question?

From mysql console, if you use this manual -> ssh and then

Code: Select all

mysql -uroot -ppassword
onwards use manual ;-)
Enable MySQL: max_user_connections

Re: How to open MySQL's max_user_connections setting?

Posted: Wed Jul 15, 2015 12:23 pm
by skurudo
kudouyuzi wrote:Enable MySQL: max_user_connections
Wait, I don't get it.

1) ssh
2) then mysql console
3) then in console

Code: Select all

mysql> GRANT USAGE ON *.* TO 'batchjob'@'localhost'
    ->     WITH MAX_USER_CONNECTIONS 50;