For each of the following methods, make sure you have the right credentials to each remote server you are working. You need the right pair of username and password of each machine for a successful transfer.
Create a database named database_name and enter your root database password mysql -u root -p -e "CREATE DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci";