Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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

Environment

None

Smart Checklist

Activity

Show:

Kathy Williamson April 22, 2020 at 3:57 PM

MySQL 5.6 is scheduled for EOL in Feb 2021.  At this time, we do not believe that this issue will be fixed prior to EOL.  If you believe this issue is important enough to be be fixed prior to EOL, or that it also affects a later version, please leave a comment and we will consider the new information

Sveta Smirnova July 3, 2018 at 4:37 PM
Edited

Thank you for the feedback.

Indeed, bug has not been fixed.

Danila Vershinin June 14, 2018 at 12:28 PM

I believe this was marked as "Fixed" in error. 

Percona-Server-server-56.x86_64 version 5.6.40-rel84.0.el7 (the latest 5.6 branch available from YUM repository, at the time of the writing) does not supply suggested fix (`User=root`) in systemd unit file.

lpjirasync January 24, 2018 at 11:43 AM

**Comment from Launchpad by: Iwo on: 18-12-2017 08:31:32

5.5 is also affected, verified on 5.5.58-38.10.

lpjirasync January 24, 2018 at 11:43 AM

**Comment from Launchpad by: Laurynas Biveinis on: 24-11-2017 04:38:41

What is 5.5 status?

Won't Do

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Smart Checklist

Created January 24, 2018 at 11:43 AM
Updated March 6, 2024 at 1:42 PM
Resolved April 22, 2020 at 3:57 PM