Failed to connect to MySQL server: DBI connect

After upgrading to CentOS 6.6, our extrabackup backup has stopped working. When I attempt to run the backup off the command line, it fails with: “Access denied for user ‘mysql’@‘localhost’ (using password: NO) at /usr/bin/innobackupex line 2978”.

The complete command line and traceback is at:

Here are a few notes about my setup:

mysql --version

mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

uname -a

Linux hostname.domain.tld 2.6.32-504.8.1.el6.x86_64 #1 SMP Wed Jan 28 21:11:36 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

cat /etc/redhat-release

CentOS release 6.6 (Final)

yum list perl-DBD-MySQL

Loaded plugins: versionlock
Installed Packages
perl-DBD-MySQL.x86_64 4.013-3.el6 @base

Thanks very much for your help.

It’s access problem. Can you please try to connect from mysql user from CLI to check If it connects. Also, share the exact command you used to take backup.

Greetings, Mirfan,

I can log into the database as user ‘mysql’. The command line I’m using for the backup is:

Thanks very much for your help,

Ahh! I found the answer. User ‘mysql’ did not have privileges on the database I wanted to back up.

Thanks very much,