When migrating a MySQL database from Server(A) to Server(B) which tables should be dumped and migrated to Server(B), including user grants? I don't want to have to manually re-enter user accounts and passwords. I wish to do this using a third part application like Navicat, without using mysqldump. My understanding is following tables contain user account (grant) data:
mysql > db
mysql > user
However, I've read that the mysql table does not need to be migrated from Server(A) to Server(B) as well as the information_scheme table. But, if the mysql table does not need to be migrated, unless that comment is incorrect, how do I migrate my user grant info with hosts, usernames, passwords, etc.