Make changes to MySQL global variables permanent across reboots
set-variable=var_name=value
is the classic method to do this in my.cnf
. Also, you can specify using flags as --set-variable=var_name=value
. Earlier than MySQL 4.0.2, most configuration options were set using this method.
This is depreciated and even removed in MySQL 5.5. Most options can be set using their actual names in the my.cnf. If you need further help, please be more specific.
You just can add all the variables to /etc/mysql/conf.d/mysql.cnf
file just after [mysqld].
[mysqld]
max_connections=1000
foo=bar
if you found [mysql] replace it with [mysqld]
To make a global system variable setting permanent, you should set it in an option file: http://dev.mysql.com/doc/refman/5.0/en/option-files.html