Learning OpenStack Networking - Third Edition

Configuring the database

Using the mysql client on the controller node, create the Nova database(s) and associated user(s):

    # mysql

Enter the following SQL statements at the MariaDB [(none)] > prompt:

CREATE DATABASE nova;CREATE DATABASE nova_api;CREATE DATABASE nova_cell0;GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' IDENTIFIED BY 'nova';GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' IDENTIFIED BY 'nova';GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'localhost' IDENTIFIED BY 'nova';GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' IDENTIFIED BY 'nova';GRANT ALL PRIVILEGES ON nova_cell0.* TO 'nova'@'localhost' IDENTIFIED BY 'nova';GRANT ALL PRIVILEGES ON nova_cell0.* TO 'nova'@'%' IDENTIFIED BY 'nova';quit;