this post helped me fix it
by following these steps
Uninstall mysql-python
Uninstall Mariadb
Install Mariadb again
Install mysql-python again
but i have more issues now when i run “bench --site localhost install-app erpnext”
_mysql_exceptions.ProgrammingError: (1146, “Table ‘334389048b872a53.tabdefaultvalue’ doesn’t exist”)
i checked the database “334389048b872a53” is empty and has no tables? what do i do now