mysqldump export access denied for user (MySQLWorkbench) on Windows

10:14:37 Dumping my_table

Running: "mysqldump.exe" --defaults-extra-file="c:\users\ycsoftware\appdata\local\temp\tmp0v6jpl.cnf"  --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=localhost --insert-ignore=FALSE --extended-insert=TRUE --user=ycsoftware --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE --add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --databases "my_table"

mysqldump: Got error: 1045: Access denied for user 'ycsoftware'@'localhost' (using password: YES) when trying to connect

Operation failed with exitcode 2

You are trying to export (dump) your database tables and you come across the error message above and you know for sure that you have the proper access.


The issue is that MySQLWorkbench does not know where the your mysqldump.exe (weird huh!). let’s see how we can point it to the “mysqldump.exe” file.


Open MySQLWorkbench and click on “View” menu and Preferences


Go to the administrator tab and browse to the location of you mysqldump.exe, which should be located on your system.



Try again and voila.

1 comment Write a comment