Comment 1 for bug 1575688

I got the same error when trying to populate the keystone-db.

I've created a file /etc/mysql/mariadb.conf.d/60-openstack.cnf to overwrite the defaults containing
~~~~~~~~~~~
[client]
default-character-set = utf8

[mysqld]
bind-address = 127.0.1.1
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
character-set-server = utf8
init-connect='SET NAMES utf8'

[mysql]
default-character-set = utf8
~~~~~~~~~~

and still get the error