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

innobackupex.pl: Error:

fineman8fineman8 EntrantCurrent User Role Beginner
I did the following

1. downloaded innobackupex - http://bazaar.launchpad.net/~dveeden/percona-xtrabackup/lp48 3827/download/head:/innobackup1.5.1-20090305061108-fxjvmhr91 4de7q81-1/innobackupex

2. environment- windows server 2008 R2 Datacenter, 64Bit operating system, Active pearl 5.12.4.1205

3. Grant permissions to root user -
Grant RELOAD, LOCK TABLES, REPLICATION CLIENT, FILE on *.* to 'root'@'localhost' identified by 'XXXXXXX';
as recommended in http://www.percona.com/doc/percona-xtrabackup/innobackupex/p rivileges.html


4. Flush privileges;

5. Execute Innobackupex - $ "C:/Program Files/xtrabackup-1.6.64bit/innobackupex.pl" --defaults-file="C:/Program Files/MySQL/MySQLInstance2/my.ini" --user=root --password=XXXXXXX D:/Xtrabackup/13306_1


I receive this error
innobackupex.pl: Starting mysql with options: --password='XXXXXXX' --user='root' --unbuffered --
111220 10:28:36 innobackupex.pl: Connected to database with mysql child process (pid=4740)
innobackupex.pl: Error: mysql child process has died: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


does anyone have any idea what privilege is needed by this "mysql child process" or what to do to stop this?

Comments

  • fineman8fineman8 Entrant Current User Role Beginner
    Hi all, i am yet to solve this problem, but for testing purposes i implemented a workaround i have added the SKIP-GRANT-TABLES option in my .ini file and restarted mysql. Innobackupex now works. please note that this is on a dev instance so dont do this in production. i do hope that someone can find out why innobackupex was getting itself in a tight spot there with privileges on mysql.
  • xaprbxaprb Mentor Inactive User Role Beginner
    That's not a privileges problem, it's an error with login credentials (authentication - not authorization).
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.