While working on a staging area for a warehouse, I ran across the need to capture a table schema from a DBF file.
If found this link http://ae.inc.ru/dbf2mysql.php
Problem:
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
Solution:
You simply need to (in mysql):
SET PASSWORD FOR username@’host’ = OLD_PASSWORD(‘password’);
