Oct 02 2016

Unknown variable default character set utf8 MySQL 5.5 or MariaDB 5.5

Category: Errors and SolutionsFatih Acar @ 08:52

If you get an error like “Unknown variable default character set utf8” 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 ‘default-character-set=utf8’
Aborting

mysql
Solution

Find my.cnf file.
[root@testdb ~]# locate my.cnf
/etc/my.cnf
Change parameter name with vi editor. New variable name is character-set-server=utf8
[root@testdb ~]# vi /etc/my.cnf
#default-character-set=utf8
character-set-server=utf8

You can start MySQL or Mariadb database.

[root@testdb ~]# systemctl start mariadb.service

11,921 total views, 36 views today

Tags: MySQL Administration, MySQL Error Solutions

facebook comments:

One Response to “Unknown variable default character set utf8 MySQL 5.5 or MariaDB 5.5”

  1. Gabriel says:

    In my.cnf there’s not a line with default-character-set=utf8, but still have the error
    [ERROR] mysqld: unknown variable ‘default-character-set=utf8’

    i was upgraded fron Debian Squeeze to Wheezy.
    Since i do that, i get this error.

    How can i solve it?

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.