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

mysql_upgrade does not use current user as default for connecting to server

    XMLWordPrintable

Details

    Description

      mysql_upgrade promises to use the current user to connect to the server unless it was specified in options, but it doesn't happen, it actually has root as a hardcoded default:

      10.5 f544a712

      $ bin/mysql_upgrade --help | grep user
        -u, --user=name     User for login if not current user.
      user                              root
      

      Apparently it has always be so, didn't matter much. It may be a bit more important after switching to unix_socket authentication in 10.4+, because the current user may well have a super-user account in the database. Still, if we want to change it, it is probably only safe to do in 10.5+. Alternatively, we can claim it is by design and just change the help text (which should then be done in all versions where it doesn't work).

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              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.