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

LP #1092235: innobackupex does not read user,password options from ~/.my.cnf

    XMLWordPrintable

    Details

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

      Description

      **Reported in Launchpad by Bryan Aldridge last update 15-05-2015 09:43:47

      1. rpm -q percona-xtrabackup:
        percona-xtrabackup-2.0.3-470.rhel5
      1. uname -a
        Linux localhost 2.6.18-308.24.1.el5 #1 SMP Wed Nov 21 11:42:14 EST 2012 x86_64 x86_64 x86_64 GNU/Linux

      I cannot seem to get innobackupex to read the username, password values set in ~/.my.cnf (/root/.my.cnf), in this case.

      1. cat /root/.my.cnf
        [xtrabackup]
        user=root
        password=abc123
      1. whoami
        root

      [root@localhost]# /usr/bin/perl /usr/bin/innobackupex --incremental /local/backups/xtrabackups_inc/20121219/xtra_backup_inc_hr12 --no-timestamp --incremental-basedir=/local/backups/xtrabackups_inc/20121219/xtra_backup_inc_hr10

      The backup dies with the following:

      innobackupex: Error: mysql child process has died: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

      If I change the /root/.my.cnf file to
      [client]
      user=root
      password=abc123

      it works, but I'd like it to obey the [xtrabackup] section, as the documentation suggests it does.

        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: