The MySQL command line can be a bit daunting at first, but once you get the hang of it, it’ll become second nature. SEE: Server deployment/migration checklist (Tech Pro Research) ...

mysql: [Warning] Using a password on the command line interface can be insecure. It's that simple—you've now restored your database dbname in the condition it was when you dumped it.