Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2502

Specifying 'information_schema' as default schema upon connection gives 'access denied'

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.7
    • Fix Version/s: 2.3.10
    • Component/s: Authenticator
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-85

      Description

      Any user can connect to an instance, also via maxscale, and change db to 'information_schema', seeing only his objects.
      Nevertheless if 'information_schema' is specified upon connection the connection is denied with:

      # mysql -ujack -p123 -h127.0.0.1 -P4009 -D information_schema
      ERROR 1045 (28000): Access denied for user 'jack'@'127.0.0.1' (using password: YES) to database 'information_schema'
      

      The same connection directly to the node will succeed.

      A workaround is to add this line:

      INSERT INTO mysql.db VALUES ('%','information_schema','jack','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko.rajala Marko Rajala
                Reporter:
                claudio.nanni Claudio Nanni
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: