← Back to team overview

openstack team mailing list archive

Re: [keystone] mysql question related to OpenStack

 

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     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp




Follow ups

References