{"id":2035,"date":"2016-10-02T08:52:55","date_gmt":"2016-10-02T05:52:55","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2035"},"modified":"2016-12-02T09:04:17","modified_gmt":"2016-12-02T06:04:17","slug":"unknown-variable-default-character-set-utf8-mysql-5-5-or-mariadb-5-5","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/unknown-variable-default-character-set-utf8-mysql-5-5-or-mariadb-5-5\/","title":{"rendered":"Unknown variable default character set utf8 MySQL 5.5 or MariaDB 5.5"},"content":{"rendered":"<p>If you get an error like &#8220;Unknown variable default character set utf8&#8221; MySQL or MariaDB 5.5 in \/var\/log\/mariadb\/mariadb.log when I restart MySQL database, you can resolve this problem with change variable name.<\/p>\n<p><strong>Error<\/strong><\/p>\n<blockquote><p>\nYou can look for error \/var\/log\/mariadb\/mariadb.log<br \/>\n\/usr\/libexec\/mysqld: unknown variable &#8216;default-character-set=utf8&#8217;<br \/>\nAborting<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.fatihacar.com\/blog\/resimler\/mysql.jpg\" alt=\"mysql\" width=\"600\" height=\"266\" class=\"aligncenter size-full wp-image-2030\" srcset=\"http:\/\/www.fatihacar.com\/blog\/resimler\/mysql.jpg 600w, http:\/\/www.fatihacar.com\/blog\/resimler\/mysql-300x133.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><br \/>\n<strong>Solution<\/strong><br \/>\n<!--more--><\/p>\n<blockquote><p>Find my.cnf file.<br \/>\n[root@testdb ~]# locate my.cnf<br \/>\n\/etc\/my.cnf<br \/>\nChange parameter name with vi editor. New variable name is character-set-server=utf8<br \/>\n[root@testdb ~]# vi \/etc\/my.cnf<br \/>\n#default-character-set=utf8<br \/>\ncharacter-set-server=utf8<\/p>\n<p>You can start MySQL or Mariadb database.<\/p>\n<p>[root@testdb ~]# systemctl start mariadb.service\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you get an error like &#8220;Unknown variable default character set utf8&#8221; MySQL or MariaDB 5.5 in \/var\/log\/mariadb\/mariadb.log when I restart MySQL database, you can resolve this problem with change variable name. Error You can look for error \/var\/log\/mariadb\/mariadb.log \/usr\/libexec\/mysqld: unknown variable &#8216;default-character-set=utf8&#8217; Aborting Solution<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[114],"tags":[44,115],"class_list":["post-2035","post","type-post","status-publish","format-standard","hentry","category-errors-and-solutions-mysql","tag-mysql-administration","tag-mysql-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-wP","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2035"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2035\/revisions"}],"predecessor-version":[{"id":2036,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2035\/revisions\/2036"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2035"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}