query_cache_type = OFF - FAIL (must be strcasecmp

query_cache_type = OFF - FAIL (must be strcasecmp on)

Anyone know how I can change this setting in mysql to show under site optimization as "ok"?

Thanks

You have to be able to edit the mySQL configuration file.  Do you have access to do that?

I believe I do. I use Arvixe as my host and I have cpanel with phpmyadmin.

You can not edit my.cnf with phpMyAdmin.  You can only look at the settings.  You need to contact Arvixe and ask them about this setting.  If you are not on a VPS/dedicated, then that means you are sharing mySQL server.  If you are on a VPS/dedicated then you should be able to edit the configuration files.  Submit a support ticket to Arvixe or use their online-chat (which is usually lower level than submitting a ticket or at least that has been my experience).

Thanks for the reply. I am on a shared environment. I did submit a ticket to them previous to this post. I will see what and if they have a solution for me.

Thanks again

Hi, I have the same issue and have full access to my server. What must be edited where to resolve this issue? Thanks

Actually never mind, I've found it.

On an Ubuntu 16.04 running MySQL 5.7.17 it's in this file: /etc/mysql/mysql.conf.d/mysqld.cnf

Add the line: query_cache_type        = ON

Where your Cache Configuration is, probably in section: # * Query Cache Configuration

Thanks anyways