openstack—执行keystone-manage db_sync失败

笔者目前执行keystone-manage遇到两种情形的失败

情形1：

执行命令后卡主不动，查看/etc/keystone/keystone.log日志发现如下

2019-02-20 15:40:16.740 32640 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. -1 attempts left.: DBConnectionError: (_mysql_exceptions.OperationalError) (2013, 'Lost connection to MySQL server at \'reading initial communication packet\', system error: 0 "Internal error/check (Not system error)"') (Background on this error at: http://sqlalche.me/e/e3q8)

这种情形笔者修改/etc/keystone/keystone.conf中的红色部分，需要与hostname一致

[database]
           connection = mysql+pymysql://keystone:keystone@controller1/keystone

情形2:

执行命令后，查看keystone.log日志报错如下

2019-02-20 20:22:20.045 737 CRITICAL keystone [-] Unhandled error: OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller1' (using password: YES)") (Background on this error at: http://sqlalche.me/e/e3q8)

笔者通过修改mysql的keystone用户访问权限解决

grant all privileges on keystone.* to 'keystone'@'controller1' identified by 'keystone';
flush privileges;