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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: