<html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em; }body { font-size: 10.5pt; font-family: 微软雅黑; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);"><b>The permission looks fine, but why the database keystone is empty ?</b></span></div><div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);"><br></span></div><div><span></span><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">MariaDB [mysql]> select Host,User from user where User='keystone';<br>+------------+----------+<br>| Host | User |<br>+------------+----------+<br>| % | keystone |<br>| controller | keystone |<br>| localhost | keystone |<br>+------------+----------+<br>3 rows in set (0.00 sec)<br></span></div><div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);"><br></span></div>
<div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">MariaDB [mysql]> select Host,Db,User from db where User='keystone';<br>+------------+----------+----------+<br>| Host | Db | User |<br>+------------+----------+----------+<br>| localhost | keystone | keystone |<br>| % | keystone | keystone |<br>| controller | keystone | keystone |<br>+------------+----------+----------+<br>3 rows in set (0.00 sec)<br></span></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div style="margin: 10px; font-size: 10pt;">=========================================</div><div style="margin: 10px; font-size: 10pt;"><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">董 建 华<br>地址：杭州滨江区南环路3766号新世纪办公楼<br>邮编：310053<br>手机：13857132818<br>总机：0571-28996000<br>传真：0571-28996001<br>热线：4006728686<br>网址：www.ahope.com.cn<br>Email：dongjh@</span><span style="font-size: 10pt; line-height: 1.5; background-color: window;">ahope.com.cn</span></div></div></span></div>
<blockquote style="margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em;"><div> </div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><div><b>发件人：</b> <a href="mailto:turbo@bayour.com">Turbo Fredriksson</a></div><div><b>发送时间：</b> 2016-12-29 01:35</div><div><b>收件人：</b> <a href="mailto:dongjh@ahope.com.cn">dongjh@ahope.com.cn</a></div><div><b>抄送：</b> <a href="mailto:openstack@lists.openstack.org">openstack</a></div><div><b>主题：</b> Re: [Openstack] 回复: keystone fail</div></div></div><div><div>On 28 Dec 2016, at 17:29, dongjh@ahope.com.cn wrote:</div>
<div> </div>
<div>> Welcome to the MariaDB monitor. Commands end with ; or \g.</div>
<div>> Your MariaDB connection id is 3</div>
<div>> Server version: 10.1.18-MariaDB MariaDB Server</div>
<div> </div>
<div>Ah, MariaDB! I could never get that to work! I only tried for a couple of hours and</div>
<div>then gave up - to much to do and to little time.</div>
<div> </div>
<div>> MariaDB [keystone]> select Host,User from user where User='keystone';</div>
<div>> ERROR 1146 (42S02): Table 'keystone.user' doesn't exist</div>
<div> </div>
<div>Please read the following section again.</div>
<div> </div>
<div>> Look at the ‘mysql’ database:</div>
<div>> </div>
<div>> select Host,User from user where User='keystone’;</div>
<div>> select Host,Db,User from db where User='keystone’;</div>
<div> </div>
</div></blockquote>
</body></html>