Trouble with Login and importing .sql file

[Steve Clark]

Hey everyone

I understand this is a very basic problem but I'm trying to get some mysql basics down in the next few weeks and am having some problems. I bought the book "learning sql" but it refers to mysql 6.0 which isn't available and I am using 5.5.

First question I have is, when I start the command line, it automatically prompts me for a password, which I enter, afterwards I am automatically logged in as root so my prompts look like this mysql>. I've set up other usernames and passwords but always get errors when I try to log in. I always log in like this mysql -u username -p;

My other question is I have a blank database setup and have a .sql file on my hard drive that I am trying to populate it with which I am also getting errors with. I am using this command source c:\temp\filename.sql

I have the db setup localhost on my hardrive and also am running raid 1 if that makes any difference.