Hi,
I am relatively new with mySQL and I am having big problems importing a *.sql file into mySQL. It was sent to me by a client of mine to work with.

I have tried what is suggested in the logs but it keeps telling me "ERROR 1045: Access denied for user: 'username@localhost' <Using Password: YES>

I am actually typing the following:-
C:\mysql\bin>mysql -u username -p -D database < c:\latestDB.sql

I am running mySQL and Clients 4.0.17
on Windows XP Pro

Please help as it is driving me mad, and I can't see what I am doing wrong.

Thanks.

The permissions on the MySQL server will need to be configured to accept connections to the specific MySQL database via the MySQL username you specify, and to do the specific operations you need (e.g. insert, create tables). this is a common wall to hit when first using MySQL.

I assume you can connect to MySQL using:
shell> mysql --user=root mysql

Then try a variation of:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

I also came across this which might be of use:
http://www.itlab.musc.edu/mysql_user...rs_readme.html