# pt-table-sync password in the old format please change the password to the new format **URL:** \ **Category:** Percona Toolkit\ **Created:** [March 19, 2015, 12:36am UTC](https://forums.percona.com/t/pt-table-sync-password-in-the-old-format-please-change-the-password-to-the-new-format/4108 "2015-03-19T00:36:11Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![nhadie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nhadie/32/867_2.png) [@nhadie](https://forums.percona.com/u/nhadie)\ **Post date:** [March 19, 2015, 12:36am UTC](https://forums.percona.com/t/pt-table-sync-password-in-the-old-format-please-change-the-password-to-the-new-format/4108/1 "2015-03-19T00:36:11Z")
Hi All, I’m looking at doing an upgrade from 5.5 to 5.6. I have 5.6 as a slave to 5.5 then i promote 5.6 as master later on. I want to ensure data integrity by running pt-sync, but i’m getting this error: DBI connect(‘;host=172.16.1.154;mysql\_read\_default\_group=client’,‘myadmin’,…) failed: Server is running in --secure-auth mode, but ‘myadmin’@‘172.16.1.154’ has a password in the old format; please change the password to the new format at /usr/bin/pt-table-sync line 2220 But on master that user is already using new format: select User,Host,Password from user where user=‘myadmin’ and Host=‘172.16.1.154’; ±-----------±-----------±------------------------------------------+ | User | Host | Password | ±-----------±-----------±------------------------------------------+ | myadmin | 172.16.1.154 | \*F1234567893F0BBAFABBA0A6EE6AE9987654321A | ±-----------±-----------±------------------------------------------+ 1 row in set (0.00 sec) May i know if anyone has encountered and have fixed the said issue. Thank you in advanced. Nhadie ---
**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\ **Post date:** [March 19, 2015, 4:02pm UTC](https://forums.percona.com/t/pt-table-sync-password-in-the-old-format-please-change-the-password-to-the-new-format/4108/2 "2015-03-19T16:02:13Z")
Can you please show the exact [pt-table-sync](http://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html) command you used. Do you have new password hash on both i.e. master and slave ? Can you please show us the output as below: master-mysql\> SHOW GLOBAL VARIABLES LIKE ‘%password%’; master-mysql\> select user, host, length(password) from mysql.user where user=‘myadmin’; slave-mysql\> select user, host, length(password) from mysql.user where user=‘myadmin’; slave-mysql\> SHOW GLOBAL VARIABLES LIKE ‘%password%’; The solution is probably to use new hashes on master and slave… ---
**Author:** ![nhadie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nhadie/32/867_2.png) [@nhadie](https://forums.percona.com/u/nhadie)\ **Post date:** [March 19, 2015, 9:02pm UTC](https://forums.percona.com/t/pt-table-sync-password-in-the-old-format-please-change-the-password-to-the-new-format/4108/3 "2015-03-19T21:02:44Z")
thank you for giving me an idea…the slave was still using the old hashes…it works now.