Not the answer you need?
Register and ask your own question!

Failed to connect to MySQL server: DBI connect

bsquaredbsquared EntrantInactive User Role Beginner
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: http://pastebin.com/vEu7jMpR

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

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    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.
  • bsquaredbsquared Entrant Inactive User Role Beginner
    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
  • bsquaredbsquared Entrant Inactive User Role Beginner
    Ahh! I found the answer. User 'mysql' did not have privileges on the database I wanted to back up.

    Thanks very much,
    Bruce
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.