Skip to content

Instantly share code, notes, and snippets.

@discoposse
Created June 3, 2014 22:58
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save discoposse/39045a714249ca7f771c to your computer and use it in GitHub Desktop.
Save discoposse/39045a714249ca7f771c to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment