Just use -p and The remainder as specified. The execution of your script will interrogate you for that password securely.
MySQL supports numerous storage engines to find out how facts bodily persists on disk. https://www.ralantech.com/mysql-dba-support-services/