Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1671

backup fails when mysql user is not specified

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0-2-alpha2
    • Fix Version/s: 8.0-2-alpha2
    • Component/s: None
    • Labels:
      None

      Description

      Error log:

      ./runtime_output_directory/xtrabackup --backup --target-dir=bak1
      xtrabackup: recognized server arguments:
      xtrabackup: recognized client arguments: --backup=1 --target-dir=bak1
      ./runtime_output_directory/xtrabackup version 8.0.1 based on MySQL server 8.0.11 osx10.13 (x86_64) (revision id: )
      encryption: using gcrypt 1.8.3
      181002 15:01:20  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
      Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','',...) failed: Access denied for user 'sergei'@'localhost' (using password: NO) at - line 1315.
      181002 15:01:20 Connecting to MySQL server host: localhost, user: not set, password: not set, port: not set, socket: not set
      Failed to connect to MySQL server: Access denied for user '?8??'@'localhost' (using password: NO).
      

      Note the garbage '?8??'@'localhost'

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                sergei.glushchenko Sergei Glushchenko
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 45 minutes
                  2h 45m