I need to import a 40Mb .sql dump file to a database on my server. Now my connection isn't too fast so I don't particularly want to use phpmyadmin to upload the file and import... so I have used wget to pull the .sql file to the server.

But to import this I need to command line import to mysql, however whenever I try to login using mysql I get access denied (for all users I try including root).

Anyone managed to get mysql command line access on a plesk server?

Thanks

Did you remember to supply a password? ("-p" option)

Yes I got it working now (although on plesk there is no root username for mySQL, it's admin).

The command I used for info is

/usr/local/psa/mysql/bin/mysql -u USERNAME -p DBNAME < /location/to/sql/dump.sql