thank you for your response.
I read the tutorial said that it work with mysql version 8.x so i tried using version 8.4.2 from the mysql download page. It said that it still have the plugin for the legacy authentication but it was disabled and since i don't know how to enable it, i can't make it work ( maybe others who has deeper understanding regarding this can explain / give pointers on how to enable it ). After trial & error, i found out that the latest version of mysql that still have the legacy authentication enabled is version 8.0.39. so for those who want to use newer version of mysql, use that version.