SOLUTION
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:
[mysqld]
skip_ssl
default_authentication_plugin=mysql_native_password