any idea on how to copy username and password to another MySQL server?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 11, 2020, 7:56pm UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/2 "2020-08-11T19:56:46Z")
The best tool for this comes from the Percona Toolkit, [pt-show-grants](https://www.percona.com/doc/percona-toolkit/LATEST/pt-show-grants.html)
Install the toolkit and use this tool to securely copy users and their hashed passwords to another mysql server.
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 20, 2020, 5:40am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/3 "2020-08-20T05:40:43Z")
how about mysqlpump ? it seems it is better ?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 20, 2020, 8:28am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/4 "2020-08-20T08:28:07Z")
> [@](#):
>
> [https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html](https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html "Link: https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html")
> By default, [**mysqlpump**](https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html) does not dump user account definitions, even if you dump the mysql system database that contains the grant tables.
Not for user accounts without modification. pt-show-grants would be easier to get a copy of all the user accounts and simply copy/paste from A-\>B
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 21, 2020, 12:54am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/5 "2020-08-21T00:54:19Z")
I said that as some of your member said mysqlpump is the best and my test is ok with mysqlpump too !
“pt-show-grants would be easier to get a copy of all the user accounts and simply copy/paste from A-\>B”
e.g. this ?
```auto
pt-show-grants --separate --revoke | diff othergrants.sql -
```
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 21, 2020, 1:11am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/6 "2020-08-21T01:11:39Z")
or as from this link [https://serverfault.com/questions/8860/how-can-i-export-the-privileges-from-mysql-and-then-import-to-a-new-server/399875#399875](https://serverfault.com/questions/8860/how-can-i-export-the-privileges-from-mysql-and-then-import-to-a-new-server/399875#399875),
```auto
MYSQL_CONN="-uroot -ppassword"
mysql ${MYSQL_CONN} --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql ${MYSQL_CONN} --skip-column-names -A | sed 's/$/;/g' > MySQLUserGrants.sql
then I just execute MySQLUserGrants.sql, which will create all user with password and respective grants?
```
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 21, 2020, 1:26am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/7 "2020-08-21T01:26:22Z")
[I](https://serverfault.com/questions/8860/how-can-i-export-the-privileges-from-mysql-and-then-import-to-a-new-server/399875#399875) also see from the same link, both of them works perfectly?
METHOD #1
You can use [**pt-show-grants**](http://www.percona.com/doc/percona-toolkit/2.0/pt-show-grants.html) from Percona Toolkit
```auto
MYSQL_CONN="-uroot -ppassword"
pt-show-grants ${MYSQL_CONN} > MySQLUserGrants.sql
```
METHOD #2
You can emulate pt-show-grants with the following
``` MYSQL_CONN="-uroot -ppassword" mysql ${MYSQL_CONN} --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user WHERE user\<\>''" | mysql ${MYSQL_CONN} --skip-column-names -A | sed 's/$/;/g' \> MySQLUserGrants.sql ```
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 21, 2020, 8:29am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/8 "2020-08-21T08:29:19Z")
That’s essentially what pt-show-grants does. Our Percona Toolkit tools are simple wrappers around complex SQL to make things easier. You can do it the complicated way, or the easy way (Percona toolkit)
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 27, 2020, 5:03am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/9 "2020-08-27T05:03:20Z")
“or the easy way (Percona toolkit)”
ahaha.
so my command above is correct?
so this one: “MYSQL\_CONN=”-uroot -ppassword"" , is set in linux ?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 27, 2020, 8:18am UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/10 "2020-08-27T08:18:52Z")
You don’t have to do that MYSQL\_CONN variable. Just put the parameters directly within your call to pt-show-grants
```auto
pt-show-grants -uroot -pmypassword >mysqlusegrants.sql
```
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 27, 2020, 10:38pm UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/11 "2020-08-27T22:38:24Z")
“pt-show-grants -uroot -pmypassword \>mysqlusegrants.sql”
ok, just one command in linux ? so this means pt-show-grants can only backup username and password and nothing else.
so when restore I have to do :
mysql -u root -p \< mysqlusegrants.sql ?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 27, 2020, 10:47pm UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/12 "2020-08-27T22:47:35Z")
\> pt-show-grants can only backup username and password and nothing else
No. It backs up usernames, passwords, and all GRANTs associated with each user account.
\>so when restore I have to do :
\> mysql -u root -p \< mysqlusegrants.sql
Correct
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 27, 2020, 10:59pm UTC](https://forums.percona.com/t/how-to-expert-mysql-user-account-with-password-and-right-permission-to-another-mysql-server/7873/13 "2020-08-27T22:59:19Z")
tks.