I don't know what I'm doing wrong but I keep getting this error when attempting to mysqldump a database to a sql file:
C:\Users\dixi>mysqldump -u root -p mydatabase > D:\test.sql
Enter password: ****
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using pas
sword: YES) when trying to connect
Server is Windows 2008R2 with Mysql 5.1 installed.
The user is the root user and the password is certainly correct as I can login to the mysql prompt with these credentials.
Command works perfectly on my local mysql db, but not on the server.