Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 1685786 - Duplicate root user in msql.user table
Summary: Duplicate root user in msql.user table
Keywords:
Status: NEW
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: galera
Version: 10.0 (Newton)
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Damien Ciabrini
QA Contact: nlevinki
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-03-06 04:13 UTC by Khomesh Thakre
Modified: 2019-03-07 11:48 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:
Target Upstream Version:


Attachments (Terms of Use)

Description Khomesh Thakre 2019-03-06 04:13:39 UTC
* Description of problem:
In Mysql DB, I found that there were two root user 

~~~
MariaDB [mysql]> select Host,User,Password from user where user = 'root';
+------------------------+------+-------------------------------------------+
| Host                   | User | Password                                  |
+------------------------+------+-------------------------------------------+
| localhost              | root | *7B7BE044BF32F80272EE3B5C210DC38703A57AAA |  << original 
| overcloud-controller-2 | root | *7B7BE044BF32F80272EE3B5C210DC38703A57AAA |  << Duplicate user
+------------------------+------+-------------------------------------------+
2 rows in set (0.00 sec)
~~~


* Version-Release number of selected component (if applicable):
Red Hat OpenStack Platform release 10.0.10 (Newton)



Additional info:


Note You need to log in before you can comment on or make changes to this bug.