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

Maxscale 2.5 not handle single quotes via mysql client throw incorrect "Access denied error"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.5.10, 2.5
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:

      Description

      Connecting via mysql client, where the arguments will be wrapped into backticks leads to not valid
      "Access not ednied "error.

      To reproduce:

      Use docker-.compose setup

      https://github.com/mariadb-corporation/maxscale-docker

      Change maxscale version in docker-compose.yml from 2.4 to 2.5

      With backticks... it throws an error

      ~/mt2/maxscale-docker/maxscale$ mysql -u maxuser -h'127.0.0.1' -p'maxpwd' -P4006 -D'test'
      ERROR 1045 (28000): Access denied for user 'maxuser'@'::ffff:192.168.112.1' (using password: YES)
      

      Without backticks, it works without issue.

      ~/mt2/maxscale-docker/maxscale$ mysql -u maxuser -h127.0.0.1 -pmaxpwd -P4006 -Dtest
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 4
      Server version: 10.3.5-MariaDB-10.3.5+maria~jessie-log mariadb.org binary distribution
      

      Note:

      It works with 22.4 without issue also with backticks.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration