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.

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

1 comment Write a comment

  1. relates to. To fix that you can either include the path to mysqldump executable to the environment variables or run the exec command with a full path to the mysqldump executable (which you can find within XAMPP mysql folder).