loosenut, when you run mysql, you need to give it a username and password like this:
If you don't add the "-u root" part, you get logged in as "nobody" and don't have permission to do anything.
If you're not familiar with database programs and SQL then I would suggest you use a program like Front-MySQL or (if you happen to have a Web Server handy on your local box

) phpmyadmin.