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

LP #1725927: "Access denied" in error log upon service start

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Won't Fix
    • Affects Version/s: 5.5.60-38.12, 5.6.40-84.0
    • Fix Version/s: None
    • Component/s: Packaging

      Description

      **Reported in Launchpad by Danila Vershinin last update 19-12-2017 08:38:34

      On CentOS 7 machine with Percona-Server-server-56.x86_64 (5.6.37-rel82.2.el7):

      With "log-warnings=2" in my.cnf my error log always includes:

      [Warning] Access denied for user 'root'@'localhost' (using password: NO)

      The warning entry above is emitted upon every start / restart of MySQL service.

      I've traced it down to ping check inside /usr/bin/mysql-systemd (post function).

      It seems that mysqladmin (inside that script) doesn't resolve ~/.my.cnf properly (I have credentials for root user stored there).

      When supplied HOME variable as "/root" everything works, but I have to override systemctl unit file to do the job as seen here: https://www.getpagespeed.com/monitoring/mysql/mysqltuner-fix-reduce-eliminate-unclosed-connections-network-issues

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: