run .sql

Hello,

what i have:
Name of the database: myDB
.sql file: SomeTables.sql

My Goal:
cause i have many many "create table" queries in the .sql file, i don't want to type everything again in the command line. I want to fill the myDB with the tables in SomeTables.sql

What i tried:
mysql myDB < SomeTables.sql

What happened:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

What i think:
i think it's because i'm not logging in as root, which i can't
I'm wondering if there's a way to get around with it.

Millions thanks =)

I always do this through the mysql command interface;
the name of this depends on your installation, for windows it's called mysql.exe and in your mysql\bin directory, for linux you can usually start it anywhere by just typing 'mysql'

you may need to pass command line variables like --user=username and --password so it askes for a password (don't put your password in the command line, as anywone typing 'w' on the same machine will see it!).

Now, you have a mysql prompts.
Start selecting the database by typing:
USE database_name;
if that goes well, you can now open your sql file by typing:
SOURCE script_file;

if you started mysql from the directory the script is in, the filename is enough, otherwise more path-info may be required.

Good luck.

Perfect. Thanks =)

You're welcome