Install Compute controller services in OpenStack Installation Guide for Ubuntu 12.04/14.04 (LTS) - icehouse-nova_install

[tarawa1943]

[database]
connection = mysql://nova:novadb-xfaiR0ck@controller/nova

If this is defined in /etc/nova/nova.conf
then why would this work if
Use the password you created previously to log in as root. Create a nova database user:

$ mysql -u root -p
mysql> CREATE DATABASE nova;
mysql> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' \
IDENTIFIED BY 'NOVA_DBPASS';
mysql> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' \
IDENTIFIED BY 'NOVA_DBPASS';

should be

mysql> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'controller' \
IDENTIFIED BY 'NOVA_DBPASS';

because of

/etc/hosts

defined controller as 10.0.0.11

-----------------------------------
Built: 2014-07-17T08:12:40 00:00
git SHA: 3144c8b2fabd57012d88fc9fd39d00c9cc64fb00
URL: http://docs.openstack.org/icehouse/install-guide/install/apt/content/nova-controller.html
source File: file:/home/jenkins/workspace/openstack-manuals-tox-doc-publishdocs/doc/install-guide/section_nova-controller.xml
xml:id: nova-controller

[Gauvain Pocentek (gpocentek)]

I know that it's not the case in the install guide, but if the mysql server was to be installed on separate machine, your change wouldn't work. I think we should keep the user setup for the databases as it is now for this reason.