yahoo-eng-team team mailing list archive

[Assassins! <shoaibfrasmd@xxxxxxxxx>]

Public bug reported:

- [x] I have a fix to the document that I can paste below including
example: input and output.

When setting up mysql before installing and configuring identity
service, the commands listed in the documentation is for <=mysql8.x
which is

GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \
IDENTIFIED BY 'KEYSTONE_DBPASS';

GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' \
IDENTIFIED BY 'KEYSTONE_DBPASS';

But in the latest release of mysql(for example 15.x) this should be done
in two separate steps

First, create users
[mysql]>CREATE USER 'keystone'@'localhost' IDENTIFIED BY 'mysql';
[mysql]> CREATE USER 'keystone'@'%' IDENTIFIED BY 'mysql';

Second, grant permissions
[mysql]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost';
[mysql]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%';


If you have a troubleshooting or support issue, use the following  resources:

 - Ask OpenStack: http://ask.openstack.org
 - The mailing list: http://lists.openstack.org
 - IRC: 'openstack' channel on Freenode

-----------------------------------
Release:  on 2019-09-18 18:54:05
SHA: 3d26cffc2393ae0270b5d073397ffaccc7dde20b
Source: https://opendev.org/openstack/keystone/src/doc/source/install/keystone-install-ubuntu.rst
URL: https://docs.openstack.org/keystone/latest/install/keystone-install-ubuntu.html

** Affects: keystone
     Importance: Undecided
         Status: New


** Tags: documentation

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1863098

Title:
  Install and configure in keystone

Status in OpenStack Identity (keystone):
  New

Bug description:
  - [x] I have a fix to the document that I can paste below including
  example: input and output.

  When setting up mysql before installing and configuring identity
  service, the commands listed in the documentation is for <=mysql8.x
  which is

  GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \
  IDENTIFIED BY 'KEYSTONE_DBPASS';

  GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' \
  IDENTIFIED BY 'KEYSTONE_DBPASS';

  But in the latest release of mysql(for example 15.x) this should be
  done in two separate steps

  First, create users
  [mysql]>CREATE USER 'keystone'@'localhost' IDENTIFIED BY 'mysql';
  [mysql]> CREATE USER 'keystone'@'%' IDENTIFIED BY 'mysql';

  Second, grant permissions
  [mysql]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost';
  [mysql]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%';

  
  If you have a troubleshooting or support issue, use the following  resources:

   - Ask OpenStack: http://ask.openstack.org
   - The mailing list: http://lists.openstack.org
   - IRC: 'openstack' channel on Freenode

  -----------------------------------
  Release:  on 2019-09-18 18:54:05
  SHA: 3d26cffc2393ae0270b5d073397ffaccc7dde20b
  Source: https://opendev.org/openstack/keystone/src/doc/source/install/keystone-install-ubuntu.rst
  URL: https://docs.openstack.org/keystone/latest/install/keystone-install-ubuntu.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1863098/+subscriptions