[rhos-list] openstack-db command error

[Pádraig Brady]

On 02/07/2013 07:25 PM, Shixiong Shang (shshang) wrote:
> Hi, experts:
>
> I am running "openstack-db" command to initiate database table for nova and saw this error:
>
> [dmd at as-msg1 ~]$  sudo openstack-db --init --service nova --password nova --rootpw mysql
> Verified connectivity to MySQL.
> Creating 'nova' database.
> ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'nova'@'localhost'
>
> It traced back to the following two commands in the "openstack-db" script under /usr/bin:
> CREATE USER '$APP'@'localhost' IDENTIFIED BY '${MYSQL_APP_PW}';
> CREATE USER '$APP'@'%' IDENTIFIED BY '${MYSQL_APP_PW}';
>
>
> I tried to manually create DB and user in mysql and it still gave me the same error.
> CREATE USER 'nova@'localhost' IDENTIFIED BY 'nova';
> CREATE USER 'nova'@'%' IDENTIFIED BY 'nova';
>
> If I used the following command instead, it passed successfully.
> CREATE USER 'nova' IDENTIFIED BY 'nova';
>
> Is it normal? Thanks!

What version of mysql are you using?

I'll not also that we have a new packstack installer
for setting up these things rather than the lower
level openstack-db commands.

thanks,
Pádraig.