OPENSTACKNova搭建報錯error: (pymysql.err.OperationalError) (1045, u"Access denied for user ‘nova’@‘controller’ (using password: YES)")
访问被拒绝
同步数据库时
[root@controller ~]# su -s /bin/sh -c "nova-manage api_db sync" nova
error: (pymysql.err.OperationalError) (1045, u"Access denied for user 'nova'@'controller' (using password: YES)")
首先觉得是数据库配置时设置授权用户密码有错所以重新输了一遍代码
[root@controller ~]# mysql -uroot -p000000
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.1.12-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> create database nova_api;
ERROR 1007 (HY000): Can't create database 'nova_api'; database exists
MariaDB [(none)]> create database nova;
ERROR 1007 (HY000): Can't create database 'nova'; database exists
MariaDB [(none)]> grant all privileges on nova_api.* to 'nova'@'localhost' identified by '这里写你的密码';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> grant all privileges on nova_api.* to 'nova'@'%' identified by '这里写你的密码';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> grant all privileges on nova.* to 'nova'@'localhost' identified by '这里写你的密码';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> grant all privileges on nova.* to 'nova'@'%' identified by '这里写你的密码';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit
Bye
再次同步数据库,报同样的错误
下面进入/etc/nova/nova.conf下查看配置文件
vi /etc/nova/nova.conf
主要查看
[api_database]
connection = mysql+pymysql://nova:这里写你的密码@controller/nova_api
[database]
connection = mysql+pymysql://nova:这里写你的密码@controller/nova
发现自己【database]文件配置时nova:后面密码输错
再次同步数据库
[root@controller ~]# su -s /bin/sh -c "nova-manage api_db sync" nova
[root@controller ~]# su -s /bin/sh -c "nova-manage db sync" nova
问题解决