Failed to connect to MySQL server: DBI connect

MySQL & MariaDB Percona XtraBackup
1

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: [url]http://pastebin.com/vEu7jMpR[/url]

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.
-bsquared

2

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.

3

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,
-bsquared

4

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

Thanks very much,
Bruce