epcim
6/3/2014 - 10:58 PM

Delete and Rebuild Keystone database

Delete and Rebuild Keystone database

# Log in to MySQL command line as root

drop database keystone;
create database keystone;
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'KEYSTONE_DBPASS'; 
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'KEYSTONE_DBPASS'; 
exit

# now from the shell
sudo su -c "keystone-manage db_sync" keystone

# Now you can log in to MySQL again as root and run this

use keystone;
desc keystone;

# you should see the keystone table listing