Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-10938

Update docs: Configuring external MySQL database. ALL PRIVILEGES required for user

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • Documentation
    • None
    • 5
    • False
    • None
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • 5

      We would like to ask update in following documentation:
      https://access.redhat.com/documentation/en-us/red_hat_3scale_api_management/2.11/html-single/installing_3scale/index#configure-external-mysql-database
      Chapter 8. Configuring an external MySQL database
      8.2. Externalizing the MySQL database
      9. Create a default 'user'@'%' on the remote MySQL database. It only needs to have SELECT privileges. Also find its base64 equivalents:
      "It only needs to have SELECT privileges"

      Change "It only needs to have SELECT privileges" =>
      TO "Required user privilages: ALL PRIVILEGES"

      The reason for requested change in 2.15 documentation (maybe add it also to documentation?):
      In 3scale release 2.16 (future/next release) - the secret `system-database` is planned to be changed:

      • DB_USER and DB_PASSWORD fields will be removed from the secret
      • URL will be changed - `root` user will be replaced with regular user (that is in DB_USER field)
        This user should have grants to allow full access for the system app to create tables, update tables etc.
        This will allow to avoid use `root` user in 2.16, and have `system-database` secret more simple for usage and understanding.

              Unassigned Unassigned
              vmogilev_rhmi Valery Mogilevsky
              Darren Fennessy Darren Fennessy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: