What sort of bottles did you use? If bottles for crown caps, are you sure you crimped them completely? The sides of the crimped cap should be vertical. If they are flared out, you didn't get a good crimp and they might leak CO2.
The Brewing software link at the top of any page here will take you to Brewer's Friend. They have a bunch of calculators that you can use. One being the
priming calculator. Or you can find any of many other priming calculators elsewhere to use. Keep the calculated CO2 volumes below 3 vols and you should be good for most bottles. Though I have gone higher. Some will recommend no more than 2.5 vols which is safer still. So you decide.
Regardless of whether you are extra safe and use just 2 vols or not, you should always store your beer where it won't be a issue if they do turn into grenades. Mine are always in a box with a lid. And where a box leaking beer won't make a mess to damage anything. And a modicum of care and caution anytime when handling.
I'd go by weight and not volume measures just to be more accurate. I make a solution with the priming sugar and add it to the beer before bottling, but if you like to separately dose each bottle, then many do. But weigh each. Or make a solution you can put in a syringe and that measures in milliliters.
The little bit more water you use to dissolve the sugar isn't going to make a big difference to the beer. I do a 1/4 cup water for my <3 gallon batches. If that results in too thick a solution for a larger batch, then 1/2 cup of water isn't going to be a big deal for a 5 gallon or 80 cups of beer. But you can calculate the differences if that precision matters to you.
If you are using glass screw top bottle with crimp lids. Many say they have a high chance of failure. I've never tried. Also, a lot more are using screw top bottles made from PET or other plastic. So consider those. Especially if you have to get more bottles.