mysqldump, 1045 error
Posted: 27. October 2008 17:06
Hi folks,
I've had XAMPP running for a while and all is OK as regards serving up database, running phpMyAdmin and so on. I can also run the mysql command prompt OK and import SQL files.
Trying to dump any database gives the 1045 error. Root does have a password. Initially I had no root password, and got the 1045, so defined one via the XAMPP utility but I still get the error:
I've tried specifying the password in the command, same result though.
XAMPP 1.6.7 on Vista
Thanks,
Bill
I've had XAMPP running for a while and all is OK as regards serving up database, running phpMyAdmin and so on. I can also run the mysql command prompt OK and import SQL files.
Trying to dump any database gives the 1045 error. Root does have a password. Initially I had no root password, and got the 1045, so defined one via the XAMPP utility but I still get the error:
- Code: Select all
>mysqldump -u root -p my-db-name > something.sql
Enter password: ****
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: YES) when trying to connect
I've tried specifying the password in the command, same result though.
XAMPP 1.6.7 on Vista
Thanks,
Bill