bloc07 (bloc07) wrote in mysql,
bloc07
bloc07
mysql

can't change max_connections variable

Hi all,

I can't seem to change my max_connections variable in mysql.
If I try to do it through the client I get this.
mysql> set global max_connections=500;
ERROR 1064: You have an error in your SQL syntax near 'max_connections=500' at line 1

Then put
set-variable = max_connections=300
in the my.cnf and restarted mysql.

I did
show variables;
and I get
| max_connections | 100

Why aren't these attempts working?
Subscribe
  • Post a new comment

    Error

    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 4 comments