Just use -p and the rest as specified. The execution in the script will interrogate you with the password securely.
Alternatively, it is possible to create a new person account that may only hook up through the remote https://www.ralantech.com/mysql-dba-support-services/