3) Drop the keystone database
4) Restart mysql service
5) Run 'keystone-manage db_sync'
For some reason I was still getting the error when /etc/mysql/conf.d/mysqld_openstack.cnf had the above values, and modifying the files in /etc/mysql/mariadb.conf.d/ was also necessary to fix.
Confirmed @namgon's fix (this is building Openstack Liberty on 16.04; I was seeing the problem populating the keystone database):
1) Replace all instances of 'utf8mb4' with 'utf8' in /etc/mysql/ mariadb. conf.d/ *
2) Add the below to /etc/mysql/ conf.d/ mysqld_ openstack. cnf: character- set = utf8
[client]
default-
[mysqld] storage- engine = innodb file_per_ table set-server = utf8
bind-address = 172.16.3.32
default-
innodb_
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-
[mysql] character- set = utf8
default-
3) Drop the keystone database
4) Restart mysql service
5) Run 'keystone-manage db_sync'
For some reason I was still getting the error when /etc/mysql/ conf.d/ mysqld_ openstack. cnf had the above values, and modifying the files in /etc/mysql/ mariadb. conf.d/ was also necessary to fix.