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

Users Credentials

aim28256aim28256 EntrantCurrent User Role Beginner
Server A(old): MySQL 5.1, Server B(New): MySQL 5.7. OS on both: RH Linux 6.8

I have exported DBs from Server A to Server B using mysql workbench. I have installed PERCONA tool kit on Server A.

I need to copy all the users and their passwords to Server B. I am getting errors on Server A when I run the following commands:

]$ pt-show-grants>grants.sql

-bash: grants.sql: Permission denied

$ pt-show-grants

DBI connect(';;mysql_read_default_group=client','',...) failed: Access denied for user 'xyz'@'localhost' (using password: NO) at /usr/bin/pt-show-grants line 1367


1: Do I need to add user ID and password to above PT command to access Server A? How ? I need users IDs and permissions of all users on Server A for restore on Server B. I am able to login to both servers without a problem. I am just getting errors on PT command.

2: Do I need to install PERCONA Tool kit on Server B to restore?

Thanks for your help.
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.