<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Hello,</div><div><br></div><div>I have a mysql specific question related to my OpenStack installation. I apologize in advance if this is not the right forum for such a question.</div><div><br></div><div><div>As user root, I created the keystone db as follows:</div><div><br></div><div><div>root@novato:~/ahmed# <b>mysql -u root -pmysqlpass</b></div><div>Welcome to the MySQL monitor. Commands end with ; or \g.</div><div>.......</div><div>mysql> <b>CREATE DATABASE keystone;</b></div><div>Query OK, 1 row affected (0.00 sec)</div><div><br></div><div>mysql> <b>GRANT ALL ON keystone.* TO 'keystoneUser'@'%' IDENTIFIED BY 'keystonePass';</b></div><div>Query OK, 0 rows affected (0.00 sec)</div><div><br></div><div>mysql> quit;</div><div>Bye</div><div><div>root@novato:~# keystone service-list</div><div>+----------------------------------+----------+----------+------------------------------+</div><div>| id | name | type | description |</div><div>+----------------------------------+----------+----------+------------------------------+</div><div>| 1d97a1ca72f84489911b0e1f7665038b | glance | image | OpenStack Image Service |</div><div>| 3a52155dab1048ce942476bfb1b2be20 | cinder | volume | OpenStack Volume Service |</div><div>| 4980e68e98174e6aae7149b98c7ae3f0 | ec2 | ec2 | OpenStack EC2 service |</div><div>| 5aff04cebb1d4ba9a92bdf651b2123ef | quantum | network | OpenStack Networking service |</div><div>| a1cfb6677b0a4188bf054663f89bfe70 | keystone | identity | OpenStack Identity |</div><div><b>| f5919383a5da4d6a9513e1318eccbf0a | nova | compute | OpenStack Compute Service |</b></div><div>+----------------------------------+----------+----------+------------------------------+</div><div>root@novato:~# </div></div></div><div><br></div><div>However, when I access the keystone db as "keystoneUser/keystonePass", I get an "Error: Access denied", however, however when I use "root/mysqlpass", the command succeeds.</div><div><br></div><div>root@novato:~# mysql -h "localhost" -u "keystoneUser" -p"keystonePass" "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';"</div><div>ERROR 1045 (28000): Access denied for user 'keystoneUser'@'localhost' (using password: YES)</div><div>root@novato:~# mysql -h "localhost" -u "root" -p"mysqlpass" "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';"</div><div>f5919383a5da4d6a9513e1318eccbf0a</div><div><br></div><div>Why I cannot access keystone db as "keystoneUser/keystonePass", even though I gave that user access to the keystone db.</div><div><br></div><div>Thank you,</div><div>Ahmed.</div></div><div><br></div></body></html>