Create a database named nova.
sudo mysql -uroot -pmygreatsecret -e 'CREATE DATABASE nova;'
Create a user named novadbadmin which has access to nova related databases.
sudo mysql -uroot -pmygreatsecret -e 'CREATE USER novadbadmin;'
Grant all privileges for novadbadmin on the Database "nova".
sudo mysql -uroot -pmygreatsecret -e "GRANT ALL PRIVILEGES ON nova.* TO 'novadbadmin'@'%' ;"
Set password for novadbadmin.
sudo mysql -uroot -pmygreatsecret -e "SET PASSWORD FOR 'novadbadmin'@'%' = PASSWORD('novasecret');"