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.

Also, I use MariaDB instead of MySQL in my examples, because that's what I have installed, and because I like the improvements MariaDB includes in both the command-line client and in the database ...