<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>
<div>
<div>Hi, experts:</div>
<div><br>
</div>
<div>I am running "openstack-db" command to initiate database table for nova and saw this error:</div>
<div><br>
</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>[dmd@as-msg1 ~]$ sudo openstack-db --init --service nova --password nova --rootpw mysql</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>Verified connectivity to MySQL.</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>Creating 'nova' database.</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'nova'@'localhost'</div>
</div>
<div><br>
</div>
<div>It traced back to the following two commands in the "openstack-db" script under /usr/bin:</div>
<div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>CREATE USER '$APP'@'localhost' IDENTIFIED BY '${MYSQL_APP_PW}';</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>CREATE USER '$APP'@'%' IDENTIFIED BY '${MYSQL_APP_PW}';</div>
</div>
<div>
<div><br>
</div>
<div><br>
</div>
<div>I tried to manually create DB and user in mysql and it still gave me the same error. </div>
<div>
<div>
<div><span class="Apple-tab-span" style="white-space: pre; "></span>CREATE USER 'nova@'localhost' IDENTIFIED BY 'nova';</div>
<div><span class="Apple-tab-span" style="white-space: pre; "></span>CREATE USER 'nova'@'%' IDENTIFIED BY 'nova';</div>
</div>
<div></div>
</div>
<div><br>
</div>
<div>If I used the following command instead, it passed successfully.</div>
<div>
<div><span class="Apple-tab-span" style="white-space: pre; "></span>CREATE USER 'nova' IDENTIFIED BY 'nova';</div>
</div>
<div><br>
</div>
<div>Is it normal? Thanks!</div>
<div><br>
</div>
<div>Shixiong</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div style="font-family: Calibri; font-size: medium; word-wrap: break-word; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; "><span class="x_Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; font-size: medium; "><span class="x_Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; font-size: medium; "><span class="x_Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; ">
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="543" style="width: 407.25pt; ">
<tbody>
<tr>
<td colspan="3" style="padding: 0in; ">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; font-size: medium; "><span class="x_Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; font-size: medium; ">
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="543" style="width: 407.25pt; ">
<tbody>
<tr>
<td style="padding: 0in; ">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: rgb(54, 95, 145); "> </span><span style="color: rgb(54, 95, 145); "></span></div>
</td>
</tr>
</tbody>
</table>
</span></span></span></div>
</td>
</tr>
</tbody>
</table>
</span></span></span></span></span></span></div>
<div style="font-family: Calibri; font-size: medium; "><img src="cid:339726B9-FB1D-4F23-9820-263F5D7D86E1" type="image/png"></div>
<div style="font-family: Calibri; font-size: medium; word-wrap: break-word; "><span class="x_Apple-style-span" style="border-collapse: separate; font-family: Helvetica; border-spacing: 0px; "><br class="x_Apple-interchange-newline">
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="543" style="width: 407.25pt; ">
<tbody>
<tr>
<td style="padding: 0in; ">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: rgb(54, 95, 145); "></span></div>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
</p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="543" style="width: 407.25pt; ">
<tbody>
<tr>
<td nowrap="" valign="top" style="padding: 0in 0in 11.25pt 0.25in; ">
<p class="x_MsoNormal" style="margin: 0in 0in 12pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">Shixiong Shang</span></b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); "><br>
<b>Solution Architect</b><br>
<b>WWSP Digital Media Distribution</b><br>
<b>Advanced Services</b></span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 12pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">CCIE R&S - #17235</span></b></p>
<p class="x_MsoNormal" style="margin: 0in 0in 12pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); "><a href="mailto:shshang@cisco.com" style="color: blue; "><span style="color: rgb(102, 102, 102); ">shshang@cisco.com</span></a><br>
Phone: +1 919 392 5192<br>
Mobile: +1 919 272 1358</span></b></p>
</td>
<td nowrap="" valign="top" style="padding: 0in 0in 7.5pt 15pt; ">
<p class="x_MsoNormal" style="margin: 0in 0in 12pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">Cisco Systems, Inc.<br>
7200-4 Kit Creek Road<br>
RTP, NC 27709-4987 <br>
United States<br>
<a href="http://www.cisco.com/" style="color: blue; "><span style="color: rgb(102, 102, 102); ">Cisco.com</span></a></span></b></p>
</td>
<td width="179" style="width: 134.15pt; padding: 0in; ">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="font-size: 9pt; font-family: 'Times New Roman', serif; color: rgb(54, 95, 145); "> </span></div>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
</p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="400" style="width: 300pt; ">
<tbody>
<tr>
<td style="padding: 0in 0.25in; ">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">!--- Stay Hungry Stay Foolish ---!</span></b></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(0, 153, 0); "><br>
</span><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); "><br>
This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient),
please contact the sender by reply email and delete all copies of this message.</span><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(0, 153, 0); "></span></div>
</td>
</tr>
</tbody>
</table>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="color: rgb(31, 73, 125); "> </span></div>
<div><span style="color: rgb(31, 73, 125); "><br>
</span></div>
</span></div>
</div>
<br>
</div>
</div>
</div>
</body>
</html>