On 11/26/12 2:00 PM, "Alan Pevec" <ape...@gmail.com> wrote:
>> 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) > >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. _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp