Open Stack

On 11/26/12 2:00 PM, "Alan Pevec" <apevec at gmail.com> wrote:

>> As user root, I created the keystone db as follows:
>>
>> root at 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)
>
>CREATE USER missing here?
>
>> mysql> GRANT ALL ON keystone.* TO 'keystoneUser'@'%' IDENTIFIED BY
>> 'keystonePass';
>> Query OK, 0 rows affected (0.00 sec)
>>
>> mysql> quit;



You are very right, I did not issue a "CREATE USER".   I assumed a side
effect of the command "GRANT ALL ON keystone.* TO 'keystoneUser'@'%'
IDENTIFIED BY 'keystonePass';"   would create the user, as a login name
and password is being stated right in the command.

And I feel the user "keystoneUser" does exist.

mysql> select * from mysql.user where User='keystoneUser';
+------+--------------+-------------------------------------------+--------
-----+-------------+-------------+
| Host | User         | Password                                  |
Select_priv | Insert_priv | Update_priv |
+------+--------------+-------------------------------------------+--------
-----+-------------+-------------+
| %    | keystoneUser | *BB845D9C1AA6F1797AA68A8AB73F7C98BBD6A84A | N
     | N           | N           |
+------+--------------+-------------------------------------------+--------
-----+-------------+-------------+
1 row in set (0.00 sec)

mysql>
mysql> select * from mysql.user;
+-----------+------------------+-------------------------------------------
+-------------+-------------+-------------+
| Host      | User             | Password
| Select_priv | Insert_priv | Update_priv |
+-----------+------------------+-------------------------------------------
+-------------+-------------+-------------+
| localhost | root             | *CDC006E5FCB22B379747AF6E75DF97FB503F11B3
| Y           | Y           | Y           |
| novato    | root             | *CDC006E5FCB22B379747AF6E75DF97FB503F11B3
| Y           | Y           | Y           |
| 127.0.0.1 | root             | *CDC006E5FCB22B379747AF6E75DF97FB503F11B3
| Y           | Y           | Y           |
| ::1       | root             | *CDC006E5FCB22B379747AF6E75DF97FB503F11B3
| Y           | Y           | Y           |
| localhost |                  |
| N           | N           | N           |
| novato    |                  |
| N           | N           | N           |
| localhost | debian-sys-maint | *307140694923C5E2853EAF39D19CDCBF0B8A5BB1
| Y           | Y           | Y           |
| %         | keystoneUser     | *BB845D9C1AA6F1797AA68A8AB73F7C98BBD6A84A
| N           | N           | N           |
| %         | glanceUser       | *2252C7F189874DF170B674DE4C86769226676D2A
| N           | N           | N           |
| %         | quantumUser      | *C1AE63E88626E664D7C5DD5B7C7FE95E8E212DF0
| N           | N           | N           |
| %         | novaUser         | *4CFAF03C591D2F6E5301DE786C2544B352458778
| N           | N           | N           |
| %         | cinderUser       | *62B63283714F6D615135B87CE852AE37AE9A131C
| N           | N           | N           |
+-----------+------------------+-------------------------------------------
+-------------+-------------+-------------+
12 rows in set (0.00 sec)




Regards,
Ahmed.