I was attempting to use phpMyAdmin to restore a table into a database but phpMyAdmin was choking on the 45MB sql dump file.

So I FTPed the SQL file up to my webspace and upon someone's advice, and SSH to root with

mysql -u[databasename] -p[password] < /home/httpd/vhosts/mydomain.com/httpdocs/database_table.sql

For anything I try I get the following error.

ERROR 1045: Access denied for user: '[databasename]@localhost' (Using password: YES)

What am I doing wrong here?

The correct syntax is:
mysql -u[dbusername] -p[password] database < /home/httpd/vhosts/mydomain.com/httpdocs/database_table.sql

Yeah, I looked it up elsewhere and found that problem. Since I did the PW syntax wrong, it was requesting it from me then giving me the error.

Anyway, I never got it to work and ended up restoring the table by opening it in a text editor and pasting it 300 lines at a time into the SQL query tool.

Took me 6 hours.