Oh, good mindset!
So first you need to build or find a routine, a combination of different exercises who target "every" muscles throughout a week. It can be full body every session, or split: upper body a day, lower body another day, core
(For example, there's a lot of different split, it's better for recovery time but it require to learn more exercices proper form). 3 sessions/week minimum, try to have a rest day between workout. Good recovery time is important, you need quality sleep.
For starting it's better to choose poly-articular exercises, it helps better for every day tasks (what's the point of having big arms if you can't lift anything off the ground).
For every exercises you have to masterize the proper form first to avoid injury and work efficiently, even if it's with little or no weight. And because nobody are built the same, some exercises are more suitable for your body than others.
(Instant pain? Change.)
Now you need to focus on the wright way to contract your muscles, feel each correct muscle and intensity, the "mind-body connection". (When you do chest exercise and it's only your arms who take everything, that's what you need to avoid).
Basically you do 3 sets of 8-10 reps, slow up slow down, 1-3 minutes rest between sets. There's other way to do your workout, like the 3/7 method. A good workout don't have to last more than 45-60 minutes.
Yes you have to sweat, to feel your heart. No you don't have to annihilate your body, don't disgust yourself of doing this (but it's better to try to reach your limits right after the last set). There's some days you have the force of 1000 suns, "great let's do some more"! And others where you feel like a sick shid, "Ok one set, just one set".Try being consistent. It's like watering a plant.
Stay hydrated, eat enough protein and fibers, don't buy every crap you see without reflection.
Of course everything is subject to debate.You rolled the number 360161390 (no dubs or higher)