mysql - Running mysqldump throws error 2013 -

i'm using mysql workbench 6.3.6 build 511 ce (64 bits) mysql 5.6.25 on windows 10 bundled xampp 5.6.11.

it used work fine month in configuration. don't recall changing settings, when want export db throws error

mysqldump: got error: 2013: lost connection mysql server @ 'reading authorization packet', system error: 2 when trying connect

operation failed exitcode 2

the error appears when try calling mysqldump myself cmd.

the command workbench used this

14:23:26 dumping invento (all tables) running: mysqldump.exe --defaults-file="c:\users\rog\appdata\local\temp\tmp0apjw4.cnf"  --host=127.0.0.1 --insert-ignore=true --protocol=tcp --user=root --force=true --port=3306 --default-character-set=utf8 --routines --events "invento" 

i should add error doesn't appear

exit code 2 indicates there permissions problem. usual suspect lack of permissions lock tables command on given database or table(s) trying dump.

make sure user use create backup has permission on given database table(s). alternatively can use --skip-lock-tables mysqldump option (also see documentation), you'll like:

mysqldump.exe --defaults-file="c:\users\rog\appdata\local\temp\tmp0apjw4.cnf" --host=127.0.0.1 --insert-ignore=true --protocol=tcp --user=root --force=true --port=3306 --default-character-set=utf8 --routines --events "invento" --skip-lock-tables