Not Allowed

[wanted420]

ERROR 1044: Access denied for user: '@' to database 'board'

I am trying to create a database and when i try i get this error. I know there is a way to specify the username and password, like -u root or something of that sort. I dont remember. TIA

Wanted420

[rachel2004]

mysql -u username -p

[wanted420]

Ok i got it. Thanks. One more question, i know there is a way to create a file (*.dump) i believe. How do I get mysql to import it or use it? i dont remember, its been a while since i have used mysql. 🙂 TIA

wanted420

[rachel2004]

I think you're talking about LOAD DATA INFILE or mysqlimport() function. I don't use those two often enough to have their syntax memorized, so you might have to check out the MySQL manual for these.

[goldbug]

or if your dump file contains pure sql commands:

mysql -u (username) -p (databasename) < file.dump