While working on a staging area for a warehouse, I ran across the need to capture a table schema from a DBF file.
While running the program I received this error
error connecting to database client does not support authentication protocol requested by server; consider upgrading MySQL client
You simply need to (in mysql):
SET PASSWORD FOR username@’host’ = OLD_PASSWORD(‘password’);