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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.3.7
    • 2.3.10
    • Authenticator
    • None
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-2621 Incorrect SQL if lower_case_table_names is used.

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko.rajala Marko Rajala (Inactive)
              claudio.nanni Claudio Nanni
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.