can't change max_connections variable
(MySQL Communtiy) Keywords: mysql, sql
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
set-variable = max_connections=300
in the my.cnf and restarted mysql.
and I get
| max_connections | 100
Why aren't these attempts working?