Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1962

LP #1098360: Access denied for user debian-sys-maint

Details

    Description

      **Reported in Launchpad by Henrik Ingo last update 18-01-2018 08:13:37

      I get the following error when starting mysqld from latest PXC 5.5 on Ubuntu Precise.

      ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

      For this reason, stopping MySQL also fails:

      /etc/init.d/mysql stop

      • Stopping MySQL (Percona XtraDB Cluster) mysqld [fail]

      Debian MySQL packages create their own debian-sys-maint user for administrative tasks. The password is generated randomly by dpkg install scripts and stored in /etc/mysql/debian.cnf. When joining a Galera cluster we will of course copy mysql.user table from the donor node, where the same user has a different password. This leads to the above errors.

      I was using mysqldump sst. I can imagine the same happens with other sst methods too.

      To fix this, it would be necessary to copy the debian.cnf file from the donor. Alternatively the sst script would have to somehow regenerate a new password for debian-sys-maint user at the completion of sst.

      I did not check if Codership deb packages have the same issue.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist