MySQL Forums
Forum List  »  MySQL Workbench

mysqldump fail only from workbench
Posted by: Steve Richards
Date: January 09, 2015 02:06PM

From my workstation (Linux) I can access the MySQL instance on another machine (Windows) in my workgroup. I am connecting as user 'root' which has full privileges, so I can successfully query all tables in all schemas.

When I select Data Export I get an error:
====
Running: /usr/bin/mysqldump --defaults-extra-file="/tmp/tmpr0XSlq/extraparams.cnf" --user=root --max_allowed_packet=1G --host=[my Windows box] --port=3306 --default-character-set=utf8 "[my schema]" "[my table]"
mysqldump: Got error: 1045: Access denied for user 'root'@'[my-workstation] .[my-workgroup]' (using password: YES) when trying to connect
=====

This used to work previously but has recently stopped working. I recently changed the workgroup name (on both the workstation and the "server" machine, of course) and I suspect that might be relevant but I can't be sure whether it has worked since the workgroup name change.

Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump fail only from workbench
1896
January 09, 2015 02:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.