Don't Know How To Edit my.cnf

Hello

I try to edit my.cnf because my host tool says query_cache_size = 0 - FAIL (must be >= 16777216).

 

Now if I put in putty vi /etc/my.cnf I get that:

 

"[mysqld]
datadir=/home/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
bind-address=127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
~
~
~
~
~
~
~
~
~
~
~
~
"/etc/my.cnf" 11L, 271C"

 

 

There isn't configurations I could change, what I'm doing wrong?

Quote · 30 Mar 2016

Add "query_cache_size=32M" directly under "symbolic-links=0". Then save and restart MySQL.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 30 Mar 2016

Cool thanks a lot Nathan

Quote · 30 Mar 2016
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.