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

password no longer read from ~/.my.cnf

kornexlkornexl EntrantCurrent User Role Beginner
since
upgrade from percona-xtrabackup 2.0.7-552.precise
to 2.1.2-611.precise (Ubuntu 12.04)

the user and password are no longer read from ~/.my.cnf

Now I get the following error:
ERROR: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/etc/mysql/multi-mysql.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld2.sock','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/bin/innobackupex line 1384

The user and password are defined in the [client] section. If I enter the --user and --password at the command-line it runs OK.

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    I am testing it with 2.1.3 and it works for me:


    [email protected]:~# cat .my.cnf


    [client]


    user=root


    password=test

    Try to create the .my.cnf again from scratch, sometimes hidden characters can cause these kind of problems.
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.