mysqldump在MySQL Workbench中无法通过SSH通过TCP / IP进行连接
I am receiving the following error when trying to export dump from a server which is connected via TCP/IP over SSH.
Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file="/var/folders/88/vbn7yg591nz5x45d2s3kcm8c0000gn/T/tmp_mpGV4/extraparams.cnf" --user=DB_User --host=localhost --protocol=tcp --port=65461 --default-character-set=utf8 --skip-triggers "test_db"
mysqldump: Got error: 2005: Unknown MySQL server host 'localhost' (0) when trying to connect
Operation failed with exitcode 2 11:09:29 Export of /Users/myuser/dumps/Dump20200326.sql has finished with 1 errors
I have searched through online but found no solution for my problem. I came across a forum saying its a bug in MySQL Workbench, so I downgraded from version 8 to version 6.3.10 but the error still occurs.
Laptop OS: macOS Catalina (version 10.15.3)
MySQL Workbench : version 6.3.10