I am using MySQL 4 and trying to cache my queries per this tutorial:
Right now, my query_cache_size is set to 0. I would like to set both the query_cache_size and query_cache_limit parameters.
However, I'm receiving the following error message:
mysql > ERROR 1227: Access denied. You need the SUPER privilege for this operation
What's the next step?
P.S. I was reading another tutorial that had me set the variables in the /etc/my.cnf file but even after restarting mysqld, nothing happened??