mysql -u root -pmypassword -e "CREATE DATABASE food" However, that bothers me for two reasons. One, the password is displayed clearly on the screen, which just creeps me out. ... The last part of the ...

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.