If you never set, forgot, or change your MySQL password, you're in luck. This article walks you through these steps, so you'll never be at a loss for that database root user password.

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.

When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we'll share with you a better option after the break), e.g.: mysql --password=secret --user=username ...