Charger light green but macbook pro doesnt power on

As of yesterday my Macbook Pro was fine, the battery died cause I was using it. So I plugged it in as always, and the charger led turned green to red so I thought its because the battery is completely drained. I let it be like that overnight, the LED on the charger turned green as you can see in the pic indicating the battery is charged. However its not powering on. All these time I had an older MacOS version but updated the OS two days ago to the latest. I wonder that has something to do with it? I know the charger cable looks bad and this is because I tore it more to see the cable, its only the shield that broke partially so as an Electrical Engineer I wouldn't think that would be the cause of a problem. I took my multimeter at work so cant check the voltage though. Tried the usual remedies like reseting the power management unit, (press and hold alt, control, shift and power ) to no avail. At this point need sone help from the experts.