[rhos-list] openstack-db command error

[Shixiong Shang (shshang)]

I am using 5.1.66

sudo mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 124
Server version: 5.1.66 Source distribution







On 2/7/13 2:46 PM, "Pádraig Brady" <pbrady at redhat.com> wrote:

>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.