I'd chop off the busted connector and re-terminate the cable with a brand new connector, always nice to repair/recycle stuff. Definitely solder it. As always, the right tools for the job make things much easier. This is a decent walkthrough https://youtu.be/Sg8c5GPSIWc