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.
Third
Try again and voila.
1 comment Write a comment