ethan
asked May 12 2017
Answer
You can change by providing value for the variables in my.cnf file.
For example:
If you need to change query_cache_size value go to my.cnf file and add the line in that.
Once its done, restart the mysql service and check it will be updated.
jagannatharumugam
asked May 12 2017
edited Oct 05 2018
how to change the default variable value in mysql
In my Mysql server ther exists many default variables which is shown in show variables command.
But i need to change to my need. Where i need to change or update.