First, create a new, empty MySQL database from the MySQL console:

create database DATABASE_NAME;

Then, import the .sql file into it:

mysql -u root -p -h localhost DATABASE_NAME < FILE_TO_IMPORT.sql

N.B. Using the root user probably is not ideal... but I do it anyway.