MySQL to Dynamo connection. Object reference not set to an instance of an object


I have been spending the whole day on it, and managed to find the solution! First reconfigure the MySQL server as Legacy Authentication Method, then go to your MySQL server folder under Programdata and add the following in the my.ini file under mysqld: