Add host to existing user @ Mysql with the same permission
If you can install or already have the MySQL Utilities, then you can use the mysqluserclone script.

Reference: 5.28 mysqluserclone — Clone Existing User to Create New User

The command is then a simple:

shell&gt; mysqluserclone --source=root@localhost --destination=root@localhost \
      source_user@localhost target_user:secret1@192.168.1.1


In the above example you are connecting to root@localhost (as the source) and root@localhost (as the target) and are then copying the permissions from source_user@localhost to target_user@192.168.1.1.

So you could use:

shell&gt; mysqluserclone --source=root@localhost --destination=root@localhost \
      Reynaldi@localhost Reynaldi:secret1@192.168.1.1


Further details can be found in the rather limited documentation.