Ask Your Question

Error 1064 when creat database for Openstack ?

asked 2014-11-21 01:44:11 -0600

anonymous user


updated 2014-11-21 10:06:26 -0600

smaffulli gravatar image

im deploying Openstack and have a problem. i installed mysql like that:

sudo apt-get install mysql-server python-mysqldb

after i want to create a database for Nova as below:

Create MySQL databases to be used with nova, glance and keystone.
Create a database named nova.

sudo mysql -uroot -pmygreatsecret -e ’CREATE DATABASE nova;’

but i get an error

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREAT DATABASE nova' at line 1

please help me to resolve it.

edit retag flag offensive close merge delete

2 answers

Sort by » oldest newest most voted

answered 2014-11-21 10:07:45 -0600

smaffulli gravatar image

Check the error message, looks like a typo to me: CREAT DATABASE nova.

edit flag offensive delete link more

answered 2014-12-02 03:42:39 -0600


just type in terminal,

mysql -u root -p (provide root password) create database nova; grant all privileges on nova.* to 'nova'@'localhost' identified by 'NOVA DBPASS';

grant all privileges on nova.* to 'nova'@'%' identified by 'NOVA DBPASS';

type: exit (come out of the mysql prompt)

then type: su -s /bin/sh -c "nova-manage db_sync" keystone

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2014-11-21 01:43:25 -0600

Seen: 546 times

Last updated: Dec 02 '14