# innobackupex.pl: Error:

**URL:** <https://forums.percona.com/t/innobackupex-pl-error/2194>\
**Category:** Percona XtraBackup\
**Created:** [December 20, 2011, 6:49am UTC](https://forums.percona.com/t/innobackupex-pl-error/2194 "2011-12-20T06:49:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fineman8](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@fineman8](https://forums.percona.com/u/fineman8)\
**Post date:** [December 20, 2011, 6:49am UTC](https://forums.percona.com/t/innobackupex-pl-error/2194/1 "2011-12-20T06:49:11Z")

</div>

I did the following

1. downloaded innobackupex - [http://bazaar.launchpad.net/~dveeden/percona-xtrabackup/lp48](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](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?

---

<div class="post-metadata">

**Author:** ![fineman8](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@fineman8](https://forums.percona.com/u/fineman8)\
**Post date:** [December 21, 2011, 4:20am UTC](https://forums.percona.com/t/innobackupex-pl-error/2194/2 "2011-12-21T04:20:47Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [January 17, 2012, 12:39pm UTC](https://forums.percona.com/t/innobackupex-pl-error/2194/3 "2012-01-17T12:39:14Z")

</div>

That’s not a privileges problem, it’s an error with login credentials (authentication - not authorization).