I would like to use the migration tool to migrate all databases to a new server. I want to use root as username to migrate the db's to the new server but I can't use this account because the ip address of the pc where the tool is on is not allowed. How should I change the root account or create a new account that allows me to migrate the db's?
I would add a additional mysql root user for the IP address of the external server, so that you can access mysql from that server as root.
