Home / ubuntu / Questions / 854202
In Process
ygoe
Asked: 2016-11-28 05:51:36 +0800 CST

MYSQL_PWD and access denied

  • 772

My system monitoring program isn't working anymore since upgrading from Ubuntu Server 14.04 to 16.04 with MySQL 5.6 to 5.7. It performs the following command:

mysqladmin -u statuser extended-status

It also sets the MYSQL_PWD environment variable for that process to the required password. The error message however is:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'statuser'@'localhost' (using password: YES)'

When I try it interactively, it works fine:

mysqladmin -u statuser -p extended-status
(type in the password)

When I try to reproduce the tool's behaviour like this, it also fails:

MYSQL_PWD='********' mysqladmin -u statuser extended-status

So isn't MYSQL_PWD supported anymore? But it says "using password: YES" so it must have noticed my environment variable. It just doesn't seem to read it right.

mysql

1 Answers

  1. Hey buddies I used these commands and it solved my issue:

    mysql -uroot -p -hlocalhost
sudo service mysql restart
mysql -u root -p

    Hope it should relieve you the agony

    • 0