So.. plesk is weird man, it has no root user.. and I was scratching my head for 30 minutes, and trying to break in for as long as an hour until someone with plesk knowledge pointed out my stupidity.

You can also use this method to reset database passwords.

 mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Something worth knowing about.