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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
