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

LP #1655278: Connecting to MySQL server host: localhost, user: (null), password: not set but trying to connect with root

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Shahriyar Rzayev last update 10-02-2017 16:20:41

      Testing branch -> https://github.com/percona/percona-xtrabackup/pull/303

      If user info specified like, i.e not specified:

      [client]
      #user = root
      #password = msandbox

      [mysqld]
      #user = sh
      #port = 5632

      [xtrabackup]
      #user=msandbox
      #password=msandbox

      Running backup command:

      sh@sh-ubuntu:/usr/local/xtrabackup/bin$ sudo ./xtrabackup --defaults-file=/home/sh/sandboxes/msb_5_6_32/my.sandbox.cnf --backup --datadir=/home/sh/sandboxes/msb_5_6_32/data/ --target-dir=/home/backup_dir/full/ --no-version-check
      170110 13:13:27 Connecting to MySQL server host: localhost, user: (null), password: not set, port: 5632, socket: /tmp/mysql_sandbox5632.sock
      Failed to connect to MySQL server: Access denied for user 'root'@'localhost' (using password: NO).

      Result -> user is null and password is not set, but it is trying to connect using 'root'.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: