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.

Solution

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.

First

Open MySQLWorkbench and click on “View” menu and Preferences

Second

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

mysql_workbench_mysqldump_access_denied

Third

Try again and voila.

1 comment Write a comment