Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13295

Function PASSWORD does not treat backslashes literally

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.1.23
    • N/A
    • Parser
    • None
    • Debian Stretch

    Description

      When altering the password for a user using the mariadb monitor, backslash characters are not treated literally although in quotation marks:

      set password = PASSWORD('abc\def');
      

      Result: User must log in using passwod "abcdef".

      set password = PASSWORD('abc\\def');
      

      Result: User must log in using password "abc\def" (typing one backslash with the keyboard).

      I find this very confusing and nearly locked myself out of my databases (resetting password for root user).

      Attachments

        Activity

          People

            serg Sergei Golubchik
            schlimmchen Bernhard Kirchen
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.