DBF->MySQL

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’);

Leave a Reply

Your email address will not be published. Required fields are marked *