How can I run a SQL query from a file?
You can use drush sql-connect for this, so you don't need to enter any credentials and/or use mysql's command line:

`drush sql-connect` &lt; my-sql-file.sql


The tildes tell your shell to replace the command drush sql-connect with the command's output. Therefore, when you run this line in your terminal, bash will actually see something like: 

mysql --database=dbname --host=localhost --user=username --password=password &lt; my-sql-file.sql


Check out Drush's documentation for much, much more.