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.

First gain access to the MySQL prompt with the command: sudo mysql. Once you’re on the MySQL prompt, create the new database with the command: create database TECHREPUBLIC; Create a USER.

Securing your MySQL installation isn't difficult. Find out how to easily harden MySQL with one command.

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 ...