I noticed in the latest cpanel there is a bug with the setup remote MySQL not copying the .mysqlscript. it creates (on cpanel server), executes (on remote server), and deletes it (on remote server) but does not copy to the remote server. To get around this, I needed to run the remote MySQL server with ignore grant tables, so it could still login, then copy + run the script by hand...I did a lot of research into the issue and have determined it is definitely a bug of some form. Tried with both key based login and password.