title: How to feed mysql queries from bash
body: <p>I'm trying to make a bash script that creates a mysql user and database but I can't find a way to feed the sql into mysql, I'm trying with this format:</p>
  
  <pre><code>mysql &lt; echo "query"
  </code></pre>
  
  <p>But that is not working, see the example below:</p>
  
  <pre><code>mysql --host=localhost --user=user --password=password &lt; echo "CREATE USER 'testuser'@'localhost' IDENTIFIED BY  'jakdJxct8W';
  CREATE DATABASE IF NOT EXISTS 'testuser_dev' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  GRANT ALL PRIVILEGES ON  'testuser_dev' . * TO  'testuser'@'localhost';
  CREATE DATABASE IF NOT EXISTS 'testuser_qa' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  GRANT ALL PRIVILEGES ON  'testuser_qa' . * TO  'testuser'@'localhost';"
  </code></pre>
  
  <p>How to feed mysql with the queries?</p>