Ask Your Question
0

the below error shown while executing the command GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \ IDENTIFIED BY 'KEYSTONE_DBPASS';

asked 2014-02-19 04:25:52 -0500

AZAK gravatar image

error 1064 (42000) : you have an error in your sql syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nera '\IDENTIFIED BY 'KEYSTONE DBPASS' ' AT LINE 1

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
2

answered 2014-02-19 04:39:14 -0500

waqasriaz gravatar image

have you created keystone database before executing this command. if not create one with following command. CREATE DATABASE keystone;

Also try this command in single line without '\' :

GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'KEYSTONE_DBPASS';

edit flag offensive delete link more

Comments

thank , the command worked without '\'

AZAK gravatar imageAZAK ( 2014-02-19 04:51:23 -0500 )edit

I got Query OK, 0 rows affected (0.00 sec) dose it mean it worked ?

AZAK gravatar imageAZAK ( 2014-02-19 06:18:27 -0500 )edit

Yes, it means it worked.

waqasriaz gravatar imagewaqasriaz ( 2014-02-19 13:56:15 -0500 )edit

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

Stats

Asked: 2014-02-19 04:25:52 -0500

Seen: 1,523 times

Last updated: Feb 19 '14