How to delete and create openstack nova database

delete and recreate openstack nova database

mysql> drop database nova;
Query OK, 49 rows affected (1.94 sec)

mysql>
mysql>
mysql> CREATE DATABASE nova;
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> GRANT ALL PRIVILEGES ON nova.* TO 'novadbadmin'@'%'
    ->   IDENTIFIED BY 'yourpasssword';
Query OK, 0 rows affected (0.02 sec)

mysql>
mysql>
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>

root@u1204x:~# nova-manage db sync
2012-05-08 05:24:26 DEBUG nova.utils [-] backend from (pid=23587) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:658
root@u1204x:~# 

root@u1204x:~# su -
root@u1204x:~# 


root@u1204x:~# ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa):
/root/.ssh/id_rsa already exists.
Overwrite (y/n)? y
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
92:3f:8b:8f:dd:70:46:da:af:03:4e:92:b5:84:66:51 root@u1204x
The key's randomart image is:
+--[ RSA 2048]----+
|       .E        |
|      .          |
|       o         |
|      +.o        |
|     oo+S..      |
|      oo++       |
|       +=.+      |
|       +.B..     |
|      o.+ oo.    |
+-----------------+
root@u1204x:~#  

root@u1204x:~/openstack/scripts# nova keypair-add --pub_key ~/.ssh/id_rsa.pub research_key
root@u1204x:~/openstack/scripts#