title: Create MySQL DB from Command Line
body: <p>I am trying to create a batch file to create a MySQL Database. So far, none of the information I am finding is working. Just for testing, this is what I am trying...</p>
  
  <pre><code>C:\&gt;mysql -uroot -ppassword &lt; CREATE DATABASE testdb;
  C:\&gt;mysql -uroot -ppassword mysql &lt; CREATE DATABASE testdb;
  </code></pre>
  
  <p>No matter how I put it, I keep getting the error "The system cannot find the file specified". If I just put...</p>
  
  <pre><code>C:\&gt;mysql -uroot -ppassword
  </code></pre>
  
  <p>It logs into the MySQL prompt fine. What exactly am I doing wrong?</p>