Sorry, that did not work. :(
ŠŠ.. mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye root@novato:~/ahmed/images# mysql -h "localhost" -u "keystoneUser" -p"keystonePass" "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';" ERROR 1045 (28000): Access denied for user 'keystoneUser'@'localhost' (using password: YES) root@novato:~/ahmed/images# root@novato:~/ahmed/images# root@novato:~/ahmed/images# root@novato:~/ahmed/images# mysql -h "localhost" -u "root" -p"mysqlpass" "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';" f5919383a5da4d6a9513e1318eccbf0a Regards, Ahmed. On 11/26/12 10:33 AM, "Mathieu Fortin" <[email protected]> wrote: >mysql> flush privileges; > >On lun, 2012-11-26 at 11:15 -0600, Ahmed Al-Mehdi wrote: >> Hello, >> >> >> 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. >> >> >> As user root, I created the keystone db as follows: >> >> >> root@novato:~/ahmed# mysql -u root -pmysqlpass >> Welcome to the MySQL monitor. Commands end with ; or \g. >> ....... >> mysql> CREATE DATABASE keystone; >> Query OK, 1 row affected (0.00 sec) >> >> >> mysql> GRANT ALL ON keystone.* TO 'keystoneUser'@'%' IDENTIFIED BY >> 'keystonePass'; >> Query OK, 0 rows affected (0.00 sec) >> >> >> mysql> quit; >> Bye >> root@novato:~# keystone service-list >> >>+----------------------------------+----------+----------+--------------- >>---------------+ >> | id | name | type | >> description | >> >>+----------------------------------+----------+----------+--------------- >>---------------+ >> | 1d97a1ca72f84489911b0e1f7665038b | glance | image | OpenStack >> Image Service | >> | 3a52155dab1048ce942476bfb1b2be20 | cinder | volume | OpenStack >> Volume Service | >> | 4980e68e98174e6aae7149b98c7ae3f0 | ec2 | ec2 | >> OpenStack EC2 service | >> | 5aff04cebb1d4ba9a92bdf651b2123ef | quantum | network | OpenStack >> Networking service | >> | a1cfb6677b0a4188bf054663f89bfe70 | keystone | identity | >> OpenStack Identity | >> | f5919383a5da4d6a9513e1318eccbf0a | nova | compute | OpenStack >> Compute Service | >> >>+----------------------------------+----------+----------+--------------- >>---------------+ >> root@novato:~# >> >> >> 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. >> >> >> root@novato:~# mysql -h "localhost" -u "keystoneUser" -p"keystonePass" >> "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';" >> ERROR 1045 (28000): Access denied for user >> 'keystoneUser'@'localhost' (using password: YES) >> root@novato:~# mysql -h "localhost" -u "root" -p"mysqlpass" >> "keystone" -ss -e "SELECT id FROM service WHERE type='"compute"';" >> f5919383a5da4d6a9513e1318eccbf0a >> >> >> Why I cannot access keystone db as "keystoneUser/keystonePass", even >> though I gave that user access to the keystone db. >> >> >> Thank you, >> Ahmed. >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~openstack >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~openstack >> More help : https://help.launchpad.net/ListHelp > > > >_______________________________________________ >Mailing list: https://launchpad.net/~openstack >Post to : [email protected] >Unsubscribe : https://launchpad.net/~openstack >More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : [email protected] Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
