安装OpenStack ValueError: Tables "migrate_version" have non utf8 co
安装OpenStack ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8 在Openstack中，安装 Glance 镜像组件时，初始化# glance-manage db_sync ……
ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8
初始化失败
然后登陆MySQL数据库查看此表，
mysql> use glance; Database changed
mysql> show tables; +------------------+
| Tables_in_glance |
+------------------+
| migrate_version|
+------------------+
1 row in set (0.00 sec)
然后根据报错信息设置 migrate_version表的字符集为 utf8
mysql> alter table migrate_version convert to character set 'utf8';
Query OK, 1 row affected (0.02 sec)
Records: 1Duplicates: 0Warnings: 0 接着再继续初始化
# glance-manage db_sync 问题完美解决
页:
[1]