Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1276

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



      **Reported in Launchpad by Henrik Ingo last update 01-10-2013 06:34:00

      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.




            krunal.bauskar Krunal Bauskar (Inactive)
            lpjirasync lpjirasync (Inactive)
            0 Vote for this issue
            1 Start watching this issue



              Smart Checklist