Set a variable called "MYSQL_PASS" for use in the various commands below:
MYSQL_PASS="mygreatsecret"
Change the bind address from 127.0.0.1 to 0.0.0.0 in /etc/mysql/my.cnf and it will look like this:
bind-address = 0.0.0.0
Restart mysql server to ensure that it starts listening on all interfaces.
sudo restart mysql
If you did not set the mysql root password during installation, set it now.
mysqladmin -u root password $MYSQL_PASS
Create a database named nova.
sudo mysql -uroot -p$MYSQL_PASS -e 'CREATE DATABASE nova;'
Update the database to grant super user privileges for root user to login from any IP.
sudo mysql -uroot -p$MYSQL_PASS -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;"
Set mysql root password for login from any IP.
sudo mysql -uroot -p$MYSQL_PASS -e "SET PASSWORD FOR 'root'@'%' = PASSWORD('$MYSQL_PASS');"