how to migrate MySQL user + password + permission from old MySQL to a newer mysQL

MySQL & MariaDB Percona XtraDB Cluster 8.x
, ,
1

hi,
We are doing Percona XtraDB cluster migration from 5.7x to 8.0.19, any idea on how to migration username, password and their respective permission to the new servers?

my SQL workbench seems not good on this using migration wizard! a lot of error will comes out.
Any idea on what is the way and tools to do it.

for me I other than mysql workbench , I  can do only mysqldump backup and restore:
backup:
mysqldump
-uroot -p --host=<DB host we want to back from >
–all-databases --events --routines --triggers --replace
–master-data=2 > <dump_file.sql>
and restore:
mysql --host=<DB host we want to
restore to > -u root -p < <dump_file.sql>

this is not enough, right? 

2

Duplicate question, answered here: How to expert MySQL user account, with password and right permission to another MySQL server - Database Monitoring and Management - Percona Community Forum