Creating the Nova Database

Nova performs lifecycle management of compute (VM) instances in the OpenStack project, including creating, scheduling, and terminating VMs.

Perform the following operations on the controller node.

1. Connect to the MySQL database as the root user.

   1	mysql -u root -p

2. Create the nova, nova_api, and nova_cell0 databases.

   1 2 3

   CREATE DATABASE nova_api; CREATE DATABASE nova; CREATE DATABASE nova_cell0;

3. Grant proper access to the databases.

   1 2 3 4 5 6 7 8 9 10 11 12

   GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'localhost' \ IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' \ IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' \ IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' \ IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON nova_cell0.* TO 'nova'@'localhost' \ IDENTIFIED BY 'PASSWORD'; GRANT ALL PRIVILEGES ON nova_cell0.* TO 'nova'@'%' \ IDENTIFIED BY 'PASSWORD';

   

   Replace PASSWORD with the password of the nova database user.

4. Exit the database.

   1

   exit