How to import sql file into MySQL?

Thanks for all of those ways to import into mysql. I got that working. Yay.

mysql db_name < script.sql

Let’s say you want to import a mysql dump into a new database with a new user. <br>Where your mysqldump is source.sql <br> <br># Enter into MySQL using “root” user identified by password <br>mysql -u root -p <br> <br>#Create the database <br>mysql> CREATE DATABASE NEWDB; <br> <br>#Create the user <br>mysql> CREATE USER ‘newuser’@‘localhsot’ IDENTIFIED BY ‘newpass’; <br> <br>#Grant ALL privileges onthe new database to the new User <br>mysql> GRANT ALL PRIVILEGES ON NEWDB.* TO ‘newuser’@‘localhost’ IDENTIFIED BY ‘newpass’; <br> <br>#Switch to the New Database <br>mysql> USE NEWDB; <br> <br>#Insert data from source.sql <br>mysql> SOURCE source.sql