Yash Yash - 16 days ago 5
MySQL Question

MySQL server has gone away due to error CHARACTER SET 'utf8'

XAMPP MySQL server crashed and shows an Error message like SQL query:

SET CHARACTER SET 'utf8';


I have tried searched in Apache Friends Support Forum, I am new to XAMPP i am facing this problem, So. Where should i need to change / run the query.

enter image description here

File « D:\xampp\mysql\bin\my.ini

## UTF 8 Settings
init-connect=\'SET NAMES utf8\'
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
character_sets-dir="D:/xampp/mysql/share/charsets"

Answer

After Un-comment PHP's default character set default_charset = "UTF-8" in D:\xampp\php\php.ini file. it is working fine.

; PHP's built-in default is text/html
; http://php.net/default-mimetype
default_mimetype = "text/html"

; PHP's default character set is set to empty.
; http://php.net/default-charset
;default_charset = "UTF-8"

Made some changes in D:\xampp\mysql\bin\my.ini file

## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
character_sets-dir="D:/xampp/mysql/share/charsets"
Comments