Added logs.

Any help would be appreciated. I can post any other info if necessary.

Mentioning the actual solution not just pointing to the issue might be appreciated by whoever gets caught in the same trap I guess. In case you tried to post an #issuecomment-... fragment URL this forum here has the nasty behaviour of cutting those off..

I assume one of these methods will help:

#issuecomment-433503473

Sign into mysql using a terminal program:

mysql -u root -p
my_password
alter user 'username'@'localhost' identified with mysql_native_password by 'password';

#issuecomment-638453312 (the currently last)

You can also fix this issue using phpmyadmin:
navigate to users->
change password->
enter your new password
make sure to select "Native MYSQL authentication" on the drop down "password hashing" menu

Thanks for pointing out.