horizon连接数据库出错

一、

OperationalError: (2003, "Can't connect to MySQL server on '192.168.240.242' (111)")

1、编辑my.cnf，默认为/etc/mydql/my.cnf，注释掉bind-address = 127.0.0.1或者修改为0.0.0.0；

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address           = 127.0.0.1

2、重启mysql：

sudo /etc/init.d/mysql restart

二、

OperationalError: (1045, "Access denied for user 'nova'@'192.168.240.242' (using password: YES)")

mysql数据库权限的原因

单节点的时候mysql用户设置成了localhost  权限

所以用ip地址是访问不到的。